Microsoft Excel "Quick Tips"

Find/Replace Across All Sheets

  1. Right click on a sheet tab and choose Select All Sheets.
  2. Select Edit, Find (or press CTRL+F).
  3. Enter what you want to search for and click the Find Next button.

Note that in Excel 97 and earlier you can only search a single sheet.

Why not print (CTRL+P) this tip and
share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".
Subscribe at the and you could win a really cool t-shirt.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright 2002 All Rights Reserved by FJH Marketing

Close this window