Search a word in a work book

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
 
P

Peo Sjoblom

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
 
G

Guest

hold down Ctrl button and select all sheets you want to
search. it will find your word on any sheet you select.
 
J

Judy Freed

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
 
Top