Microsoft Office Tutorials and References
In Depth Information
Searching a Spreadsheet
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 8-15
6. Click Close to make the Find and Replace dialog box go away.
the text or
want to find.
Searching for formulas
Formulas appear just like numbers; to help you find which cells contain
formulas, Excel gives you two choices:
Display formulas in your cells (instead of numbers)
Highlight the cells that contain formulas
To display formulas in a spreadsheet, press Ctrl+` (an accent grave
character, which appears on the same key as the ~ sign and often appears to the left
of the number 1 key near the top of a keyboard). Figure 8-16 shows what a
spreadsheet looks like when formulas appear inside of cells.
To highlight all cells that contain formulas, follow these steps:
1. Click the Home tab.
2. Click the Find & Select icon in the Editing group.