When you are developing complex formulas, or when you are examining the formulas developed by others, it can often be beneficial to look at the results of a particular portion of a formula. For instance, consider the following formula:
You may want to know the value of C3/F8. In order to find this out, you can do the following:
- Press F2 to edit the formula in the cell.
- Select the portion of the formula whose value you want to see. In this instance, you would select C3/F8.
- Press F9. Excel replaces the portion of the formula with its result.
At this point, you have two options. If you press Enter or otherwise move to a different cell, Excel assumes you have edited the formula and makes the change. The second option is to press the Esc key, which tells Excel to not make any changes to the formula.