Search WorkBook

[edooley]

I am looking for a method that I can search an entire workbook. I simply have several tabs (spreadsheets) and need to be able to search the entire workbook to find the spreadsheet that contains the information that I am looking for. Thanks in advance for any assistance.

 

[Mark O'Brien]

I had to ask.

 

[Ekim]

Choosing "Select All Sheets" and Hit CTRL+F does not work in Excel 97. This has been noted several times in other forums.

Regards,

Mike

 

[marnie]

Thanks for letting me know about Excel 2000. I use the search function frequently. The upgrade would be a big plus.

 

[CosmoPlavix]

the pretty simple manual way to do this is:

1. Right click on a tab.
2. Choose "Select All Sheets"
3. Hit CTRL+F
4. Type the info you're searching for in the dialogue box
5. It will search the whole workbook for your information.

HTH

EDIT:: I forgot to say: "Welcome to the Board"
_________________
Mark O'Brien

[SIZE=-1][ This Message was edited by: Mark O'Brien on 2002-10-07 15:25 ][/SIZE]

Thank you! You saved me $300.

 

[windowslasvegas369]

that's is awesome


bay window las vegas
buy window direct las vegas
buy windows direct las vegas