How to Use Find and Replace in Excel
Occasionally, you'll have a word or number you need to find somewhere in your spreadsheet, but you're not sure where it is. Excel’s Find and Replace commands scan a worksheet for labels and values with just a few clicks of the mouse.
The Find feature makes it very easy to find specific words and values in a worksheet.
Press Ctrl + F.
The Find tab of the Find and Replace dialog box appears.
Excel jumps to the first occurrence of the word, phrase, or value that you entered.
Click Find All to find the cell location of all instances at once.
Now, if you have a word that appears throughout a spreadsheet and needs to be updated, don't update it cell by cell, use Replace instead.
Press Ctrl + H.
The Replace tab of the Find and Replace dialog box appears.
The first instance is selected.
You can use Excel’s search options to change how Excel searches the workbook.
Additional options appear, as described in following table.
Free to distribute with our compliments; we hope you will consider our paid training.