MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to perform a search over multiple worksheets?

Posted by Bob on December 03, 2001 1:37 PM

How can I perform a search within an entire Excel spreadsheet (of say 50 worksheets) without having to search each sheet individually? Thanks!

Posted by lenze on December 03, 2001 2:42 PM

Select all the sheets before doing your search. Use the Control key to select multiple sheets, or the shift key to select all sheets between to sheets

Posted by Bob on December 03, 2001 3:05 PM

That works like a charm, Lenze. Now I can write a short macro to select all sheets and go to the search dialog box. Thanks for your help!