Search & Replace

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott Shively - 06 Jan 2005 17:06 GMT

How do I set up a search & replace to go through all of the worksheets in a
workbook when I click on 'replace all' not just the current worksheet?

Reply to this Message

Peo Sjoblom - 06 Jan 2005 17:20 GMT

What version do you have? I believe excel 97 had some problems but with any
later version, group the sheets
first (click the first sheet, hold down shift and click the last), then do
edit>replace
don't forget to ungroup the sheets afterwards

Signature

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

> How do I set up a search & replace to go through all of the worksheets in
> a
> workbook when I click on 'replace all' not just the current worksheet?

Reply to this Message

Gord Dibben - 06 Jan 2005 20:05 GMT

Excel 97's problem was with the "Find" across worksheets.

"Replace" across worksheets always works for me.

Strange doin's<g>

Gord

>What version do you have? I believe excel 97 had some problems but with any
>later version, group the sheets
>first (click the first sheet, hold down shift and click the last), then do
>edit>replace
>don't forget to ungroup the sheets afterwards

Reply to this Message