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 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.
As a result, all dependent arrows are removed.