- 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
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.