"Find" through entire Workbook

[AMMC]

How do I use the "Find" function to search through an
entire workbook instead of just one sheet in the
Workbook?? Any advice would be greatly appreciated.

 

[Ron de Bruin]

Try this

Right-Click one of the sheets and click "Select All Sheets" on the shortcut menu, then perform your search.

If any one of your sheets has more than one cell selected, this method won't
work correctly. After selecting all sheets, press Ctrl+A to select all
cells on all sheets to force the Find to search them all.

If you are using XL97, the "select all sheets" method will not work. You can
"Replace" across sheets, but not "Find".(Gord Dibben)

In Excel 2002/2003, there is a "Within:" option in the Find/Replace dialog.


You may want to try Jan Karel Pieterse's FlexFind at:
http://www.bmsltd.co.uk/MVP/Default.htm

 

[Vaughan]

If you select all the sheets first (Click on the first tab, then Shift + Click on the last) then run your find query, it should look through them all.

 

[Stephen Dunn]

p.s. don't forget to go back to a single sheet selection before making
changes - otherwise you're editing them all at once...

Try this

Right-Click one of the sheets and click "Select All Sheets" on the

shortcut menu, then perform your search.