Microsoft Office Tutorials and References
In Depth Information
Detecting and Correcting Errors in Formulas
Tracing cell references
In a complex worksheet in which formulas are piled on top of one another
and the results of some formulas are computed into other formulas, it helps
to be able to trace cell references. By tracing cell references, you can see
how the data in a cell figures into a formula in another cell; or, if the cell
contains a formula, you can see which cells the formula gathers data from
to make its computation. You can get a better idea of how your worksheet is
constructed, and in so doing, find structural errors more easily.
Figure 3-11 shows how cell tracers describe the relationships between cells.
A cell tracer is a blue arrow that shows the relationships between cells used
in formulas. You can trace two types of relationships: