You can search for a specific label or number anywhere in your spreadsheet. To search for text or numbers, follow these steps:
1. Click the Home tab.
2. Click the Find & Select icon in the Editing group.
A pull-down menu appears.
3. Click Find.
The Find and Replace dialog box appears, as shown in Figure 7-14.
If you click the Replace tab, you can define the text or number to find and new text or numbers to replace it.
The Find and Replace dialog box lets you search your worksheet.
4. Click in the Find What text box and type the text or number you want to find.
If you click the Options button, the Find and Replace dialog box expands to provide additional options for searching, such as searching in the displayed sheet or the entire workbook.
5. Click one of the following:
Find Next: Finds and selects the first cell, starting from the currently selected cell that contains the text you typed in Step 4
Find All: Finds and lists all cells that contain the text you typed in Step 4, as shown in Figure 7-15
The Find All button names all the cells that contain the text or number you want to find.
6. Click Close to make the Find and Replace dialog box go away.