Trace Dependents

Draws tracer arrows to the active cell from formulas that depend on values in the active cell.

The area of all cells that are used together with the active cell in a formula is highlighted by a blue frame.

To access this command...

From the menu bar:

Choose Tools - Detective - Trace Dependents.

From the context menu:

With Fill Mode active, choose Trace Dependents.

From the tabbed interface:

Choose Tools - Trace Dependents.

On the Tools menu of the Tools tab, choose Trace Dependents.

From toolbars:

Trace Dependents

From the keyboard:

Shift+F5

This function works per level. For instance, if one level of traces has already been activated to show the precedents (or dependents), then you would see the next dependency level by activating the Trace function again.

Detective