Find and Replace Across All Pages In MS Excel

There will always be a time when you need to do a find and replace on every spreadsheet in your MS Excel Workbook. Of course, you could do each find and replace separately but we all know I don't roll that way. I love to save time and keystrokes!

So follow the steps below to learn how:

• Right click on a sheet tab and select Select All Sheets.
   
• Select Edit | Find, or click CTRL + F. 
   
• Enter the term for which you would like to search.
   
• Click the Find Next button.

In versions 97 and earlier you can only search a single spreadsheet.

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!