MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Search the entire workbook

Posted by Ian on July 03, 2001 12:13 AM

I would like to search across my entire workbook. The search function in excel seems only to search the present sheet that is open. Is this possible to search several sheets or the entire workbook?

Posted by Ivan F Moala on July 03, 2001 12:28 AM

If you mean Find across sheets ?? then just
select the other sheets while pressing Ctrl
that you want to search and then do a Find command
Is this what you meant ??
Note: to select ALL sheets use Shift and then
select the last sheet on your sheets tab.