Search and Replace entire workbook?

S

sue egan

Is there a way to search and replace ALL sheets in a
workbook simultaneously? (We are working in Excel 2002
SP2)
 
G

Gord Dibben

Sue

Select first sheet tab then hold SHIFT key and select last sheet tab. This
"groups" the sheets.

Do your Edit>Replace on the grouped sheets.

NOTE: DO NOT FORGET to "ungroup" sheets when complete. What you do to one
will be done to all.

Right-click on one sheet tab and "ungroup sheets".

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
K

Ken Wright

XP (2002) - Edit / Replace / Options / Change 'Within Sheet' to 'Within Workbook'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WORD VBA Search and switch to advanced ... 1
FIND AND REPLACE TEXT ON ALL SHEETS IN ONE ACTION 0
Prompt For Replace in Selection And More... 0
Shift Collate sheet 1-20 when printing entire workbook? 0
Replace 1
Disable Outlook AutoCorrect with GPO 0
Need Help with Macro Security 1
Sharing workbooks limitations - Merged Cells 12

Top