- 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
Finding Data
There might be times when you’ll need to find specific information in a large spreadsheet. For example, suppose you want to quickly find the row that deals with sales data in Region 5 of your company. Instead of scanning each row for the data you need, which can be time-consuming, you can use Excel’s Find feature.
Open the Edit menu and choose Find. The Find and Replace dialog box opens with the Find tab displayed.
In the Find what text box, type the data you want to find.
Click the Find Next button.
Excel finds the first instance of the data you typed and makes the cell that contains it the active cell. Click Find Next to search for the next instance, or Close to end.