When working with a large spreadsheet in Microsoft Excel, it can be challenging to track which cell contains the data you’re looking for. To make it easier to find your data, you can use tracer arrows to show the relationships between cells. Tracer arrows are blue lines with arrows in Excel that connect cells that contain related data. Tracer arrows make it easy to see which cells are referenced by a formula, and which cells reference other cells. In this article, we’ll demonstrate to you how to show tracer arrows in Excel in comfortable ways.
What Are Tracer Arrows in Excel?
Basically, the tracer arrows are the blue line arrows that actually show the relationship between the cells used in a formula. There are two types of tracer arrows. One is Trace Precedents Arrow and the other is Trace Dependents Arrow. Both arrows are important to show the relationship between the cells. Here we have discussed how to show these tracer arrows in Excel.
How to Show Tracer Arrows in Excel: 2 Easy Ways
The Tracer Arrows may be shown in 2 ways one Trace Precedents and the other Trace Dependents. These two basically show the relationship between the active cells with the other cells. We have discussed 2 ways to show the Tracer Arrows. Follow the instructions stated below.
1. Selecting Trace Precedents Option
The Trace Precedents arrow is a built-in feature in Excel. It shows the relationship between the active cells and the other cells. If a cell contains a formula with other cells the Trace Precedents arrows help us to show the relationship. Here, we demonstrate the simple steps to show the Trace Precedents arrow.
📌 Steps:
- First of all, enter the formula in cell E5.
Thus, cell E5 is precedented by cells C5 and D5. However, we can see this relation using the Trace Precedents command. This command will display a blue line with arrows to show the dependency.
- Then, select cell E5 >> go to the Formulas tab.
- Afterward, under the Formula Auditing command click on the Trace Precedents option.
Eventually, the blue tracer line of Trace Precedents will appear just like the image below.
Read More: How to Use Blue Line with Arrows in Excel
2. Choosing Trace Dependents Option
Mainly, the Trace Dependents arrow shows the relationship between the selected cell and the other cells. The group of cells that are affected by the selected cell is displayed by the blue arrows. It is the Trace Dependents arrow. Follow the steps to show the Trace Dependents arrow.
📌 Steps:
- Firstly, select cell C5.
- Then go to the Formulas tab >> under the Formula Auditing ribbon group, and pick the Trace Dependents command.
Finally, this will show all the dependent cells under C5 with the blue line of tracer arrows.
How to Remove Tracer Arrows in Excel
Sometimes you might need to remove the tracer arrows in your worksheet. It is as simple as showing the arrow. There are built-in features to remove the tracer arrows. Follow the steps to remove it.
📌 Steps:
- In the very beginning, go to the Formulas tab and click on the Remove Arrows command under Formula Auditing.
- Subsequently, this will remove all the blue lines with arrows whether they are line Trace Precedents or Trace Dependents commands.
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. Please do it by yourself.
Download Practice Workbook
Download the following practice workbook. It will help you to realize the topic more clearly.
Conclusion
That’s all about today’s session. And these are the ways to show the tracer arrows in Excel. Please let us know in the comments section if you have any questions or suggestions. For a better understanding, please download the practice sheet. Thanks for your patience in reading this article.
Related Articles
- How to Insert Curved Arrow in Excel
- How to Insert Trend Arrows Based on Another Cell in Excel
- How to Add Up and Down Arrows in Excel
- Up and Down Arrows in Excel Using Conditional Formatting
- Double Headed Arrow in Excel
- How to Insert Red Arrow in Excel Cell
- How to Add Trend Arrows in Excel
<< Go Back to Arrows in Excel | Excel Symbols | Learn Excel