Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / June 2006

Tip: Looking for answers? Try searching our database.

how to use find binoculars in excel 2000 .xls ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ttodd0450 - 27 Jun 2006 23:24 GMT
I have an excel spreadsheet with up to letter K in columns ( 11 columns) and
each column has 8717 rows of information ( academy awards list of the past 77
years).. Trouble is the find button doesn't find anything.
If go to find and type in ' Gone with the wind ", it says Microsoft excel
cannot find the name you are searching for, if you are certain the data
exists in the current sheet, check your spelling"... huh?

and of course other titles say the same. I have tried for over ten minutes
to get this to work.

I have 'search by rows' look in formulas' and both boxes are unchecked..
I have tried various ways to handle this and cannot get the .xls to co
operate.

what is there left for me to check?

using office 2000 on windows Xp pro.

thanks

Signature

please reply

Michael M - 28 Jun 2006 01:42 GMT
Hi
Are you putting your search in inverted commas "  ",
If so, this will only find the text that is actually in inverted commas.
Try searching for "gone", without the commas.
It works fine for me.

HTH
Michael M

> I have an excel spreadsheet with up to letter K in columns ( 11 columns) and
> each column has 8717 rows of information ( academy awards list of the past 77
[quoted text clipped - 15 lines]
>
> thanks
Steved - 28 Jun 2006 01:44 GMT
Hello from Steved

Search is Column or Row
Look in is Value

see how you go with that as it worked for me.

> I have an excel spreadsheet with up to letter K in columns ( 11 columns) and
> each column has 8717 rows of information ( academy awards list of the past 77
[quoted text clipped - 15 lines]
>
> thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.