Microsoft Office Tutorials and References
In Depth Information
Editing a Single Formula to Show Direct Precedents
Figure 9.27.
Figure 9.27. Show Formulas mode reveals the formulas in the cells instead
Show Formulas mode reveals the formulas in the cells instead
of the results. This is handy for quick formula auditing.
of the results. This is handy for quick formula auditing.
To hide the formulas and return to normal mode, choose the Show Formulas
icon again.
Editing a Single Formula to Show Direct Precedents
Editing a Single Formula to Show Direct Precedents
It is helpful to identify cells that are used to calculate a formula. These
cells are called the precedentsof the cell.
A cell can have several levels of precedents. In a formula such as =D5+D7,
there are two direct precedents: D5 and D7. However, all the direct precedents
of D5 and D7 are second-level precedents of the original formula.
If you are interested in visually examining the direct precedents of a cell,
follow these steps:
11. Select a cell that has a formula.
22. Press F2 to put the cell in Edit mode. In this mode, each reference of
the formula is displayed in a different color. For example, the for-
mula in cell H5 in Figure 9.28 refers to three cells. The characters
F5 in the formula appear in blue and correspond to the blue box
around cell F5.
Figure 9.28.
Figure 9.28. Editing a single formula lights up the direct precedent cells.
Editing a single formula lights up the direct precedent cells.
Search JabSto ::




Custom Search