- Entering Data and Making Changes
- Entering Data
- Editing and Deleting Existing Data
- Zooming Into Your Data
- Undoing and Redoing Changes
- Copying and Pasting Data
- Freezing Rows and Columns
- Splitting a Worksheet
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Moving Data
- Finding Data
- Replacing Data
- Applying a Data Filter
- Sorting Data
- Adding and Managing Cell Comments
This chapter is from the book
This chapter is from the book
This chapter is from the book
Replacing Data
Imagine that you discover some data in your table in which a company’s name has been consistently misspelled, or that a salesperson you reference in a data table has changed his last name. You definitely would not want to find and replace all that data manually. 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.
)
On the Home tab, click Find and Select and then click Replace.
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. (Alternatively, 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.
Tip: Narrowing Your Search Criteria
Clicking on the Options button on the Find and Replace dialog box reveals a few options you can use to make search criteria more specific. To conduct a case-sensitive search (for example, finding all instances of “Thompson” but not “thompson”), 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.