Chapter 32: Making Your Worksheets Error-Free
669
Searching for information
Enter the information to search for in the Find What text box and then specify any of the following
options.l Within drop-down list: Specify where to search (the current sheet or the entire workbook).l (^) Search drop-down list: Specify the direction (by rows or by columns).
l Look In drop-down list: Specify what cell parts to search (formulas, values, or comments).
l (^) Match Case check box: Specify whether the search should be case sensitive.
l Match Entire Cell Contents check box: Specify whether the entire cell contents must be
matched.
l Format button: Click to search for cells that have a particular formatting (see the upcom-
ing “Searching for formatting” section).
Click Find Next to locate the matching cells one at a time or click Find All to locate all matches. If
you use the Find All button, the Find and Replace dialog box expands to display the addresses of
all matching cells in a list (see Figure 32.15). When you select an entry in this list, Excel scrolls the
worksheet so that you can view it in context.
Tip
After using Find All, press Ctrl+A to select all the found cells. n
FIGURE 32.15
Displaying the result of a search in the Find and Replace dialog box.