Find and Replace Across All Pages In MS Excel

Dennis Faas's picture

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, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

| Tags:
Rate this article: 
No votes yet