Microsoft Office Tutorials and References
In Depth Information
Tracing Precedents and Dependents
Solving Formula
Errors
Figure 18-3:
This example shows
the direct precedents
of cell H2. As you can
see, H2 calculates
the student’s final
grade based on the
test results that are
stored in cells C2 and
F2. Because these two
arrows overlap, they
appear as one arrow,
but you can clearly
see two circles, each
of which represents
the starting point of
an arrow (one each
on cells C2 and F2).
Figure 18-4:
Excel also lets you
trace multiple levels
of relationships. Just
click the Trace
Precedents button again
to see whether the
precedent cells have
other precedents.
Here you can see that
the test result cells
are themselves
calculations that rely on
other cells. C2 makes
its calculations using
cells B2 and B12.
The first time you click Trace Precedents, you see the direct precedents . These cells
are the ones directly referenced by the current formula. However, these precedents
may themselves refer to other cells. To see these cells, click Trace Precedents again.
There’s no limit to how many times you can click Trace Precedents. As long as
there are more indirect precedents, Excel continues adding arrows. At any point,
you can remove a single level of arrows by clicking the Remove Precedent Arrows
button, or you can clear everything by choosing Formulas Formula Auditing
Remove Arrows.
Search JabSto ::




Custom Search