Part II: Working with Formulas and Functions
Searching and Replacing
Excel has a powerful search-and-replace feature that makes it easy to locate information in
a worksheet or across multiple worksheets in a workbook. As an option, you can also search
for text and replace it with other text.To access the Find and Replace dialog box, start by selecting the range that you want
to search. If you select any single cell, Excel searches the entire sheet. Choose Home ➪
Editing ➪ Find & Select ➪ Find (or press Ctrl+F).If you’re simply looking for information in the worksheet, select the Find tab. If you want
to replace existing text with new text, use the Replace tab. Also note that you can use the
Options button to display (or hide) additional options. The dialog box shown in Figure 19.3
displays these additional options.FIGURE 19.3
Use the Find and Replace dialog box to locate information in a worksheet or workbook.Searching for information
Enter the information to search for in the Find What text box and then specify any of the
following options:Within drop-down list Specify where to search (the current sheet or the entire
workbook).
Search drop-down list Specify the direction (by rows or by columns).
Look In drop-down list Specify what cell parts to search (formulas, values, or comments).
Match Case check box Specify whether the search should be case sensitive.
Match Entire Cell Contents check box Specify whether the entire cell contents must be
matched.