# How to Show Tracer Arrows in Excel (2 Methods)

## What Are Tracer Arrows in Excel?

Tracer arrows are blue line arrows that visually represent the relationship between cells used in a formula. There are two types of tracer arrows: Trace Precedents Arrow and Trace Dependents Arrow. Both are essential for understanding cell relationships.

### Method 1 – Using the Trace Precedents Option

• Enter a formula in cell E5.
=C5*D5

This means that cell E5 depends on cells C5 and D5.

• To reveal the relationship, use the Trace Precedents command:
• Select cell E5.
• Go to the Formulas tab.
• Under Formula Auditing, click Trace Precedents.

• A blue tracer line with arrows will appear, indicating the dependency.

### Method 2 – Using the Trace Dependents Option

• Select cell C5.
• Go to the Formulas tab.
• Under Formula Auditing, click Trace Dependents.

This will show all cells dependent on C5, represented by blue tracer arrows.

## Removing Tracer Arrows

• To remove tracer arrows:
• Go to the Formulas tab.
• Click Remove Arrows under Formula Auditing.

• This will remove all the blue lines (trace dependents and trace precedents) with arrows.

Read More: How to Remove Tracer Arrows in Excel

## Practice Section

We have provided a practice section on each sheet on the right side for your practice.

## Related Articles

<< Go Back to Arrows in Excel | Excel Symbols | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Fahim Shahriyar Dipto

Fahim Shahriyar Dipto is a graduate of Mechanical Engineering at BUET. With over 1.5 years of experience at Exceldemy, he authored 70+ articles on ExcelDemy. He has expertise in designing worksheets at You’ve Got This Math. Currently, He is a Team Leader at Brainor. Dipto's passion extends to exploring various aspects of Excel. Beyond tech, he enjoys creating engaging kids' worksheets using Illustrator. A dedicated employee and innovative content developer, He incorporates a commitment to academic excellence and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF