See all Microsoft Excel tips
Strategy: Select the cell, press F2 to put the cell in edit mode, as shown in Fig. 405.
Tip Remember to press the Esc key to change back to the original
formula after using this technique.
In edit mode, the various cells are color-keyed. You can selectively calculate just a portion of the formula. As shown in Fig. 406, using the mouse, highlight a portion of the formula. Hit the F9 key. As shown in Fig. 407, that portion of the formula will be replaced with the current result of the formula.
Additional information: If you hit
F9 without selecting anything, it will calculate the entire formula and replace it in the result, as shown in Fig. 408.
Summary: Placing a cell containing a formula in edit mode, selecting part of the formula, and hitting the F9 key will verify that the selected part of the formula is correct.
Commands Discussed: F2 with a selected cell; F9 in the edit mode.
See all Microsoft Excel tips