Microsoft Office Tutorials and References
In Depth Information
Tracing Dependents
see additional levels. In this case, practically every cell on the
worksheet is a precedent of cell D32.
33. To remove the arrows, use the Remove Arrows icon in the Formula
Auditing group.
Tracing Dependents
Tracing Dependents
The Formula Auditing section provides another interesting option besides the
ones discussed so far in this chapter. You can use the Formula Auditing sec-
tion to trace dependents so you can find all the cells on the current work-
sheet that depend on the active cell. Before deleting a cell, consider clicking
Trace Dependents to determine whether any cells on the current sheet refer to
this cell. This prevents many #REF! errors from occurring.
Caution
Even if tracing dependents does not show any cells that are dependent
on the current cell, other cells on other worksheets or on other
workbooks might rely on this cell.
Using the Watch Window
Using the Watch Window
If you have a large spreadsheet, you might want to watch the results of some
distant cells. You can use the Watch Window icon in the Formula Auditing
section of the Formulas tab to open a floating box called the Watch Window
screen. To use the Watch Window screen, follow these steps:
11. Click the Add Watch icon. The Add Watch dialog appears.
22. In the Add Watch dialog, specify a cell to watch, as shown in Figure
9.30 . After you add several cells, the Watch Window screen floats
above your worksheet, showing the current value of each cell that
was added to it. The Watch Window screen identifies the current value
and the current formula of each watched cell.
Search JabSto ::




Custom Search