cannot search in excell

  Lord Justice 10:08 08 Sep 2006
Locked

i have entered a number of client details into an excell spreadsheet.
Each cleints names and corresponding reference number is listed in fields.
occasionaly i need to search for a particular name however the find facility will not allow this.
It will not find any name in the sheet at all.
Could you please help me with this proble.
Thanks you in advance.

  johnnyrocker 10:10 08 Sep 2006

do you get an error when trying to use search? what os?



johnny.

  Lord Justice 10:15 08 Sep 2006

Well i do not get an error but it simply says not found.

I am using win xp

Thanks

  ArrGee 10:26 08 Sep 2006

If you are searching for the name Brown (as an example), try typing in *bro*

  Noldi 12:35 08 Sep 2006

You could try auto filter

Select all active cells (A1 > Ctrl+Alt+End) then Data > Filter > Auto Filter then search the name in the drop down list.

Noldi

  Noldi 12:39 08 Sep 2006

Sorry should have mentioned then you can do a custom search.

EG - equals B* for Brown etc

  Lord Justice 18:07 21 Sep 2006

Thank you guys all sorted now

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?