Find and Replace Across All Pages In MS Excel
- by Carol Bratt on 20090130 @ 06:10PM EST | google it | send to friends
- Filed under Carol's Corner Office | (related terms: spreadsheet, replace, search)
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!
