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

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?''.


"knutknut" wrote:

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

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...
> 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?''.
>
>
> "knutknut" wrote:
>
> > I want to replace all the occurences of a particular character sequence in a
> > workbook containing 256 worksheets. Is this possible

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
<[email protected]> 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...
>> 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?''.
>>
>>
>> "knutknut" wrote:
>>
>> > I want to replace all the occurences of a particular character sequence in a
>> > workbook containing 256 worksheets. Is this possible