Microsoft Office Tutorials and References
In Depth Information
Evaluating Part of a Formula
22. Press F9. Excel calculates just the highlighted portion of the for-
mula, as shown in Figure 9.33 .
Figure 9.33.
Figure 9.33. Press F9 to calculate just the highlighted portion of the for-
Press F9 to calculate just the highlighted portion of the for-
mula.
mula.
Be sure to press the Esc key to exit the formula after you use this method.
Instead, if you press Enter to accept the formula, that portion of the for-
mula permanently stays in its calculated form, such as 0.407407.
Search JabSto ::




Custom Search