replace function for multiple sheets

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

Ron de Bruin

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
 
Top