Replace soemthing in multiple worksheets
 

Can I use the Replace function to go through all the worksheets in a workbook?

Replace soemthing in multiple worksheets
 

Which version of Excel?

For 2002 and newer you can select from the Options to look in "Workbook"

Older versions you had to first select all the sheets into a
group" then editreplace.

Note: in Excel 97 editfind did not work with grouped sheets but editreplace
did.......strange but a fact.


Gord Dibben MS Excel MVP

On Tue, 23 Jan 2007 11:51:01 -0800, J@Y wrote:

Can I use the Replace function to go through all the worksheets in a workbook?

Replace soemthing in multiple worksheets
 

O, I guess i have an old version of excel. Thanks.

"Gord Dibben" wrote:

Which version of Excel?

For 2002 and newer you can select from the Options to look in "Workbook"

Older versions you had to first select all the sheets into a
group" then editreplace.

Note: in Excel 97 editfind did not work with grouped sheets but editreplace
did.......strange but a fact.


Gord Dibben MS Excel MVP

On Tue, 23 Jan 2007 11:51:01 -0800, J@Y wrote:

Can I use the Replace function to go through all the worksheets in a workbook?

Replace soemthing in multiple worksheets
 

Don't guess at your version.

Click HelpAbout to see your version edition and release number.


Gord

On Tue, 23 Jan 2007 12:23:04 -0800, J@Y wrote:

O, I guess i have an old version of excel. Thanks.

"Gord Dibben" wrote:

Which version of Excel?

For 2002 and newer you can select from the Options to look in "Workbook"

Older versions you had to first select all the sheets into a
group" then editreplace.

Note: in Excel 97 editfind did not work with grouped sheets but editreplace
did.......strange but a fact.


Gord Dibben MS Excel MVP

On Tue, 23 Jan 2007 11:51:01 -0800, J@Y wrote:

Can I use the Replace function to go through all the worksheets in a workbook?

Replace soemthing in multiple worksheets
 

Hi J@Y

try this it is useful for u and easy also !

Go to find and replace option ( shortcut Ctrl+H)
u will get the Find :__________ and Replace :_________
there is small button options .
click the options .......... there is blank heading within................
in that black space u just click work book.......

what u want to replace entire work book will change

try this i hope it is useful for u

steps : ctrl+H ,,,,,,, find,,,,,, replace ,,,,,,
options,,,,,,,,within,,,,,worksheet

it will work


waiting for reply
--
Name : K.Prasad
Inventory Manager
CRYSTALGALLERY
DUBAI



"Gord Dibben" wrote:

Which version of Excel?

For 2002 and newer you can select from the Options to look in "Workbook"

Older versions you had to first select all the sheets into a
group" then editreplace.

Note: in Excel 97 editfind did not work with grouped sheets but editreplace
did.......strange but a fact.


Gord Dibben MS Excel MVP

On Tue, 23 Jan 2007 11:51:01 -0800, J@Y wrote:

Can I use the Replace function to go through all the worksheets in a workbook?