GLOBAL search and replace
 

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.

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 :-)
----------------------------------------------------------------------------

"Rebecca" wrote in message
...
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.

Rebecca

EditReplaceOptionsWithin

Choice of Worksheet or Workbook.


Gord Dibben Excel MVP

On Fri, 25 Feb 2005 16:23:01 -0800, "Rebecca"
wrote:

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.