Excel Search Tip #4: Search and Replace
If you are searching for something in your Excel sheet, you might want to change whatever you’re searching for. If you have a sheet with a bunch of data that needs to be changed, you can easily use the Replace feature while searching. Hit CTRL+F and click the Replace tab, or just hit CTRL+H to open up the replace tab without clicking it.
You can use the Excel search features the same way you would use them to just do a regular search, including all the extra search options. The difference with the replace tab is it gives you a new field to enter, Replace With.
You can use this to quickly change a typo, or change the format of an existing cell.
If you wanted to fix the spelling of something, enter the incorrect spelling as found in your sheet in the “Find What” field. Then enter the correct spelling in the “Replace With” field.
If you wanted to change cell formats, you can select the format currently used in your sheet in the first format option. In the second format option, choose the format you want to change to.
You can click the “Replace” button to replace each instance one-by-one, or click the “Replace All” button to replace every instance at once.