Search & Replace

S

Scott Shively

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?
 
P

Peo Sjoblom

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

--
Regards,

Peo Sjoblom

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

Gord Dibben

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

"Replace" across worksheets always works for me.

Strange doin's<g>

Gord
 
Top