search work book in excel 97

S

Steve Goodrich

how do i search a workbook in excel 97?
in excel xp i click the first sheet then shift click the last sheet to
select all the sheets, then click find, enter the info and it searches every
sheet in the book.
I have excel 97 at work and the same procedure only searches the first
sheet.
is there a different method. in 97
thanks for any help
steve
 
R

Ron de Bruin

Hi Steve
in excel xp i click the first sheet then shift click the last sheet to
Click to expand...

You don't have to do that in Excel 2002-2003

In Excel 2002-2003, there is a "Within:" option in the Find/Replace dialog.
Workbook is one of the options
 
Top