- 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
Finding Data
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.
Tip: Finding All Instances
Click the Find All button in the Find and Replace dialog box to view a list, complete with cell locations and worksheet tab names, of all the instances of the data you entered in the Find What text box. While there, you can press Ctrl+A to have Excel select all the cells in that list.