Find/Replace Across Entire Workbook in Excel 2000

T

Tiffany

Hello, in Excel 2003 there is an option under Edit, Find/Replace, Options to
Search across the entire workbook. I am looking to do this in Excel 2000,
but the option is not there. Is there another way to find/replace across the
entire workbook in Excel 2000?

Thanks so much in advance,
Tif
 
S

Sean Timmons

Click on the first tab, hold the shift key, click on the last tab.
then do your find/replace.
 
G

Gord Dibben

Tiffany

"Group" the sheets before doing your find/replace.

Select first sheet and right-click "select all sheets" or CTRL + click for
non-contiguous sheets or SHIFT + click for selecting less than all sheets.


Gord Dibben MS Excel MVP
 
Top