See all How-To Articles

How to Hide All Dependency Tracer Arrows at Once in Excel

In this tutorial, you will learn how to hide dependency tracer arrows in Excel.

 

hide dependency tracer arrow 4

 

Hide Dependency Tracer Arrows

You can use Trace Dependents commands to graphically display and trace the relationships between cells and formulas with tracer arrows. The Trace Dependents feature shows arrows that indicate which cells are affected by the value of the currently selected cell. This helps a lot when you are checking formulas for the accuracy or finding the source of an error.

1. To hide all dependency tracer arrows at once, in the Ribbon, go to the Formulas tab.

2. Click the arrow next to Remove Arrows.

3. Then select Remove Dependent Arrows.

 

hide dependency tracer arrow 5

 

As a result, all dependent arrows are removed.

 

hide dependency tracer arrow 4