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.
