Search a word in a work book

  • Thread starter Thread starter Gomathi Sankar
  • Start date Start date
G

Gomathi Sankar

Hi,
In excel I am able to use the find option to search a word
in the current sheet. How do search the same word through
out the workbook with multiple sheets.

Thanks,
Gomathi
 
Select the first sheet tab you want to search, hold down shift and select
the last sheet tab,
then do the search, once you are done right click any tab and select ungroup
sheets
 
hold down Ctrl button and select all sheets you want to
search. it will find your word on any sheet you select.
 
In Excel XP, if you want to search through the entire workbook, select Edit,
Find, and then click the Options button. The "Within" field contains an
option for Workbook.
Judy Freed
 
Back
Top