Microsoft Office Tutorials and References

In Depth Information

**Detecting and Correcting Errors in Formulas**

Figure 3-10:

Running

the error

checker.

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:

Figure 3-11:

Tracing the

relationships

between

cells.