Microsoft Office Tutorials and References
In Depth Information
Tracing cell references
Figure 8-63 The Watch Window displays all the current information for the watched formula.
Tracing cell references
If you’ve ever looked at a large worksheet and wondered how you could get an idea of the
data low—that is, how the formulas and values relate to one another—you’ll appreciate
cell tracers . You can also use cell tracers to help find the source of those pesky errors that
occasionally appear in your worksheets. The Formula Auditing group on the Formulas tab
contains three buttons that control the cell tracers: Trace Precedents, Trace Dependents,
and Remove Arrows.
Search JabSto ::

Custom Search