"Find" through entire Workbook

  • Thread starter Thread starter AMMC
  • Start date Start date
A

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.
 
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
 
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.
 
p.s. don't forget to go back to a single sheet selection before making
changes - otherwise you're editing them all at once...



Ron de Bruin said:
Try this

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