GLOBAL search and replace

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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)?
Click to expand...
Thanks.
 
Rebecca

Edit>Replace>Options>Within

Choice of Worksheet or Workbook.


Gord Dibben Excel MVP
 
Back
Top