The Find and Replace feature of Microsoft Excel is often needed in spreadsheets that contain a lot of data and workbooks. This feature scans your worksheet or workbook for specific words or phrases and provides that information in a list format. The "Replace" feature will change each instance of your "Find" phrase to a different set of text that you designate. "Ctrl" and "F" is the shortcut key to open the Find and Replace dialog box.
Step 1
Open your Microsoft Excel file.
Video of the Day
Step 2
Press "Ctrl" and "F" to open the "Find and Replace" dialog box.
Step 3
Enter text into the "Find what:" field. Click the "Options" button to add search criteria. Your options include searching one sheet or the entire workbook, searching by row or column or designating where to look.
Step 4
Click the "Find Next" button to go through each instance individually.
Step 5
Click the "Find All" button to generate a chart. This chart provides a listing of the row and column of each instance of the word you searched.
Step 6
Click the "Replace" tab to change your text. Enter the text you want to find. Enter the text you want to replace it with. Click "Replace" to go through individually. Select "Replace All" to automatically change each instance.
Video of the Day