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.