how do I do a global replace in all sheets in a workbook?

K

knutknut

I want to replace all the occurences of a particular character sequence in a
workbook containing 256 worksheets. Is this possible
 
G

Gary L Brown

group all of the worksheetss by going to the first worksheet and selecting
it. Then go to the last worksheet and WHILE HOLDING DOWN THE SHIFT KEY
select the last worksheet.
Now, using the menu...
Edit>Find
put the character sequence in the 'Find What' box.
Select the 'Replace...' button.
Put your replacement character sequence in the 'Replace with' box.
Select 'Replace All'

Ungroup the worksheets by right clicking on a worksheet tab and select
'Ungroup Sheets'.

HTH,
 
K

knutknut

Simple when you know how! Thanks for the help


Gary L Brown said:
group all of the worksheetss by going to the first worksheet and selecting
it. Then go to the last worksheet and WHILE HOLDING DOWN THE SHIFT KEY
select the last worksheet.
Now, using the menu...
Edit>Find
put the character sequence in the 'Find What' box.
Select the 'Replace...' button.
Put your replacement character sequence in the 'Replace with' box.
Select 'Replace All'

Ungroup the worksheets by right clicking on a worksheet tab and select
'Ungroup Sheets'.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.
Click to expand...
 
G

Gord Dibben

If using Excel version 2002 or 2003 you can, in the Find/Replace options, set to
look through Workbook.

So no need to group the sheets.


Gord Dibben MS Excel MVP
 
Top