Find/Replace Across Entire Workbook in Excel 2000

[Guest]

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

 

[Guest]

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

 

[Guest]

Thanks so much, I will give this a try.

Tiffany

 

[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