Microsoft Office Tutorials and References
In Depth Information
T RACE D EPENDENTS
Click in the cell for
which you want to
Click the Formulas tab.
Click Trace Dependents.
l Excel draws arrows between the formula’s
cell and the dependent cells.
Click Remove Arrows.
Excel removes the arrows.
Note: Click the down arrow next to Remove
Arrows to choose Remove Arrow, Remove
Precedent Arrows, or Remove Dependent
Did You Know?
When working with large or complicated worksheets, where the result of the formula is
dependent on the results of another formula in another cell, you may want to monitor cell
values. To do so, you can use the Watch Window. To add a cell to the Watch Window, click
Watch Window on the Formulas tab in the Formula Auditing group. The Watch Window
appears at the bottom of your screen. Click the Add Watch button. The Add Watch dialog
box appears. Click and drag to select the cells you want to watch and then click Add. You
can now monitor the cells you have added to the Watch Window.
Chapter 3: Copy, Format, and More