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

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

"Tiffany" wrote:

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

Thanks so much, I will give this a try.

Tiffany


"Sean Timmons" wrote:

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

"Tiffany" wrote:

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

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

On Mon, 5 Feb 2007 14:18:01 -0800, Tiffany
wrote:

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