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