MrExcel Publishing
Your One Stop for Excel Tips & Solutions

EXCELL FIND FUNCTION


Posted by Josh Arnold on October 15, 2001 11:21 AM

I am trying to run a Find on an excel workbook, so far I have figured out how to seach a spreadsheet within the book, or a column within the spreadsheet but my file(s) have in ecess of 75 sheets in the book and short of running find on every sheet I would like to know if anyone out there has figured this out.

Thanx in advance.
Josh Arnold


Posted by Mark W. on October 15, 2001 11:29 AM

Right-click on any one of your workbook's tabs and
choose "Select all Sheets" before performing your
Find.

Posted by Joe Garza on October 16, 2001 5:56 AM

If you click on the tab once, then hold the shift key and click on another tab, it will highlight all the tabs in between...then do a find. Another way is to click on a tab, then hold the Ctrl key down and click as many tabs as you want...then do a Find.