How to Hide All Dependency Tracer Arrows at Once in Excel

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on July 19, 2023

This tutorial demonstrates 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 accuracy or for 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 click Remove Dependent Arrows.

hide dependency tracer arrow 5

As a result, all dependent arrows are removed.

hide dependency tracer arrow 4


AI Formula Generator

Try for Free

See all How-To Articles