Worksheet Or Workbook?
Did you know that when you do a Find / Replace in MS Excel, you can control how much of the file is searched?
Yep, that’s right. You can choose to work on a single worksheet or on the entire workbook. It’s all up to you. You just have to know where to look for the setting.
To begin, you need to run the Find / Replace as usual. (Ctrl + H or Edit menu, Replace choice).
Once in the Find and Replace window, you’re looking for the Options button.
This will expand the window to this:
Take a look at the first new setting added to the window. See where it says “Within“? It’s here that you can choose from the drop down list. You’ll find that you have two choices: sheet and workbook.
Make your selection and then it’s back to the Find / Replace business as usual.