- Editing Data
- Overwriting and Deleting Data
- Undoing and Redoing Changes
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Cutting, Copying, and Pasting Data
- Flipping Rows and Columns
- Moving Data
- Finding Data
- Replacing Data
- Adding and Viewing Cell Comments
- Editing and Deleting Cell Comments
- Inserting Symbols
- Tracking Changes
- Accepting or Rejecting Tracked Changes
- Checking Spelling
Replacing Data
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.
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.