|
| Open the Edit menu and select 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 (in this example, Hoffman). |
| Click the Find Next button. |
| Excel finds the first instance of the data and makes it the active cell. Click Find Next to search for the next instance, or click Close to end the search. |
INTRODUCTION Sometimes, 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. |
TIP Finding All Instances of Data 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. |
|