• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Part 3. Editing Worksheets > Replacing Data

Replacing Data

Open the Edit menu and choose Replace. The Find and Replace dialog box opens with the Replace tab displayed.

In the Find what text box, type the data you would like to find. Press the Tab key to move the cursor to the Replace with text box, and type the replacement data.

Click Replace All to replace all instances of the data you typed. (Or, click Find Next to find the first instance of the data, and click Replace to replace it.)

Excel notifies you of the number of replacements it made; click OK. When you're done using the Find and Replace dialog box, click its Close button to close it.


Suppose you discover that you consistently misspelled a company's name in your worksheet, or that a person you reference in several cells has gotten married and changed her name. Fortunately, Excel enables you to search for instances of incorrect or outdated data and replace it with new data using its Find and Replace feature.


Narrowing search criteria

Click the Options button on the Find and Replace dialog box to make your search criteria more specific. To conduct a case-sensitive search (for example, finding all instances of Hoffman but not hoffman), choose the Match case option. Choose Match entire cell contents to limit your search to cells that contain no more and no less than the data you type (for example, to find all instances of Hoffman, but not Hoffmann. You can also specify where the search should be conducted (Within Sheet or Within Workbook), ways to search (By Rows or By Columns).

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint