replace function for multiple sheets

  • Thread starter Thread starter marty
  • Start date Start date
M

marty

I know how to replace (Edit > Replace) text within a
sheet.
Is it also possible to use "replace all" for all the
sheets in the workbook instead of only the 'active' sheet?
 
Hi marty

If you use Excel 2002/2003 there is a "Within:" option in the Find/Replace dialog.(choose workbook)
If you use 97/2000 then select all the sheets first before you do the replace
 
You must log in or register to reply here.

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

Excel shortcut options 0
problem with fractions to decimal 1
how to find and replace content of a specific cell based on its ad 4
Excel Move or Copy Stopped Working? 0
Replace data from sheet 2 into sheet 1 1
Set the Find and Replace, Options, 'Within' default to Workbook 1
Replacment in excel 1
Keeping Workbook Name Out of Sheet When Copying to Different Book 2

Back
Top