MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Finding text across worksheets???

Posted by Perdita on April 02, 2001 8:37 PM

This seems quite basic, but no-one I have asked seems to know the answer!

How can you find text* (simply) in a workbook with multiple worksheets?

*i use an Excel 97 spreadsheet as a simple database (about 8 sheets) and Ctrl+F will only search for text within the page I am on.

Surely there is a way?

Posted by Dave Hawley on April 03, 2001 1:09 AM

Hi Perdita

There most certainly is a way. Right click on any sheet name tab and select "Select all sheets". If there are sheets you do not want included then Hold down the Ctrl and left click the tab.

Now do your Find as normal.


OzGrid Business Applications

Posted by Perdita on April 03, 2001 2:12 PM

Dave - YOU ARE A GOD!!!
I am most humble before thine magnificence, o great excel guru.
Thank you SO much!!!