GLOBAL search and replace

[Rebecca]

Hi. I couldn't find any mention of this in HELP. Is it possible to do a
GLOBAL search and replace in Excel 2003, that is, to search and replace
entries on several worksheets (I have about 15 sheets altogether)? Thanks.

 

[Ken Wright]

Edit / Replace / Options / Within = Workbook

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

Hi. I couldn't find any mention of this in HELP. Is it possible to do a
GLOBAL search and replace in Excel 2003, that is, to search and replace
entries on several worksheets (I have about 15 sheets altogether)?

Thanks.

 

[Gord Dibben]

Rebecca

Edit>Replace>Options>Within

Choice of Worksheet or Workbook.


Gord Dibben Excel MVP