You might want to see the result of just one part of a complex formula if, for example, you are tracking down a discrepancy.

To change only part of a formula to a value, select the part you want to change and press F9. You also can use this technique to change highlighted cell references in formulas to their values.

If you’re just checking your figures, press the Esc key to discard the edited formula. Otherwise, if you press Enter, you replace the selected portion of the formula.

Tip: Use Evaluate Formula to troubleshoot

You can also choose Tools, Formula Auditing, Evaluate Formula to troubleshoot your workbook models.