Find in several sheets

[gdeleon]

Hi:

I have an Excel workbook with several sheets. Sometimes I want to find some text that can be in any of those sheets.
Is there a way to find the text in one single operation?

Thank you,

Gustavo de Leon

 

[Wray69]

Select all the sheets that you want to search by holding the CTRL key and left clicking on them. Then simply go to Edit/Find and type in what you are searching for.

Hope this helps.

Regards,

Wray

 

[KenWright]

Jan Karel Pieterse has a great utility for doing this called FlexFind:-

http://www.bmsltd.co.uk/MVP/Default.htm

Regards
Ken................

 

[tazman99]

By the way,

With Excel XP, you can search 'Workbook or Worksheet' under the 'Find and Replace' dialog box, and Options button.

-tazman

 

[gdeleon]

Thanks to all of you.

Gustavo