search work book in excel 97

[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

 

[Frank Kabel]

Hi
this is a change in the later Excel versions. Excel 97 does not support
this workbook search.But you may try Jan Karel Pieterse's FLEXFIND.XLA
from

http://www.bmsltd.ie/mvp/

 

[Ron de Bruin]

Hi Steve

in excel xp i click the first sheet then shift click the last sheet to

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