Perform 'Find' across all worksheets

M

Mirthrindr

Using Excel 2000 as part of Office 2000. Is there a way when doing a 'Find'
to have Excel search across all the worksheets in a spreadsheet? Currently
when doing a 'Find', Excel only searchs the worksheet I am currently on.
Thanks in advance.

Jim
 
R

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 with a Workbook option.

You may want to try Jan Karel Pieterse's FlexFind (97-2003) at:
http://www.bmsltd.co.uk/MVP/Default.htm
 
Top