Why not print (CTRL+P) this tip and
Microsoft Excel "Quick Tips"
Find/Replace Across All Sheets
Note that in Excel 97 and earlier you can only search a single sheet.
- Right click on a sheet tab and choose Select All Sheets.
- Select Edit, Find (or press CTRL+F).
- Enter what you want to search for and click the Find Next button.
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 TheExcelAddict.com/Newsletter.htm 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