Excel 2010 Bible

Part IV: Using Advanced Excel Features

668

Click the Evaluate button to show the result of calculating the expressions within the formula. Each

click of the button performs another calculation. This feature may seem a bit complicated at first, but

if you spend some time working with it, you’ll understand how it works and see the value.

Excel provides another way to evaluate a part of a formula:

1. Select the cell that contains the formula.


2. Press F2 to get into Cell Edit mode.


3. Use your mouse to highlight the portion of the formula you want to evaluate. Or,
   press Shift and use the navigation keys.


4. Press F9.

The highlighted portion of the formula displays the calculated result. You can evaluate other parts

of the formula or press Esc(ape) to cancel and return your formula to its previous state.

Caution
Be careful when using this technique because if you press Enter (rather than Esc), the formula will be modified
to use the calculated values. n

Searching and Replacing

Excel has a powerful search-and-replace feature that makes it easy to locate information in a work-

sheet 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, click Ctrl+F). You’ll see the Find and Replace dialog box shown in Figure 32.14. If you’re

simply looking for information in the worksheet, click 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 the figure displays these additional options.

FIGURE 32.14

Use the Find and Replace dialog box to locate information in a worksheet or workbook.