- 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
You will often encounter situations where you will need to find specific information in a large spreadsheet. For example, suppose you want to quickly find the row that shows the sales information for Jerry Thompson. Instead of scanning each row for the data you need, which can be time consuming, you can use Excel’s Find feature.
On the Home tab, click Find and Select, and then click Find or press shortcut key Ctrl+F.
In the Find What text box, enter 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. You can click the Find Next button to search for the next instance.
Click the Close button when you are done searching.