Microsoft Office Tutorials and References
In Depth Information
Tracing cell references
The tracer arrows indicate that cell B2 is directly referred to by the formulas in cells C5, C6,
C7, and C8. If you click Trace Dependents again, another set of arrows appears, indicating
the next level of dependencies—or indirect dependents. Figure 8-65 shows the results.
Figure 8-65 When you click Trace Dependents again, arrows point to the next level of formulas,
ones that indirectly refer to the selected cell.
One handy feature of the tracer arrows is that you can use them to navigate, which can be
advantageous in a large worksheet. For example, in Figure 8-65, with cell B2 still selected,
double-click the arrow pointing from cell B2 to cell C8. The selection jumps to the other
end of the arrow, and cell C8 becomes the active cell. Now, if you double-click the arrow
pointing from cell C8 to cell E8, the selection jumps to cell E8. If you double-click the same
arrow again, the selection jumps back to cell C8. If you double-click an arrow that extends
beyond the screen, the window shifts to display the cell at the other end. You can use this
feature to jump from cell to cell along a path of precedents and dependents.
Clearing tracer arrows
As you trace precedents or dependents, your screen quickly becomes cluttered, making it
difficult to discern the data low for particular cells. To remove all the tracer arrows from the
screen, click the Remove Arrows button in the Formula Auditing group. Alternatively, you
can click the small downward-pointing arrow next to the Remove Arrows button to display
the Remove Arrows menu, where you can be more selective by choosing Remove
Precedent Arrows or Remove Dependent Arrows.
Tracing precedent cells
You can also trace in the opposite direction by starting from a cell that contains a formula
and tracing the cells that are referred to in the formula. In Figure 8-66, we selected cell E5,
which contains one of the net wages formulas, and then clicked Trace Precedents twice to
show the complete precedent path.