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

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

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

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...
EditFind
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

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"knutknut" wrote:

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

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

Simple when you know how! Thanks for the help


"Gary L Brown" wrote:

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...
EditFind
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

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"knutknut" wrote:

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

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

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

On Mon, 26 Jun 2006 06:35:02 -0700, knutknut
wrote:

Simple when you know how! Thanks for the help


"Gary L Brown" wrote:

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...
EditFind
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

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"knutknut" wrote:

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