Finding and replacing data

 

Replacing data

To find and replace data in a worksheet, follow these steps:

1. Choose Find & Select in the Editing group on the Home tab, and then select Find (or press Ctrl+F). 2. The Find and Replace dialog box appears with the Find tab on top. 3. In the Find What box, enter the data you want to locate. 4. (Optional) Click the Options button to expand the dialog box and specify any desired options.

Within: Search just the current worksheet or the entire workbook. Search: Select whether to search first across the rows or down the columns. Look In: Select whether you want to search through the values or formula results, through the actual formulas, or if you want to look in the comments. Match Case: Check this box if you want your search to be case-specific. Match Entire Cell Contents: Check this box if you want your search results to list only the items that exactly match your search criteria. 5. Click Find Next. Excel jumps to the first occurrence of the match. If this is not the entry you’re looking for, click Find Next again. Excel advises you if it doesn’t locate the data you’re searching for. 6. Click Close when you’ve located the entry you want.

Replacing data