This textbook is available Logo
Shelly Cashman Series Microsoft Office 365 & Excel 2019 Comprehensive 1st Edition

Shelly Cashman Series Microsoft Office 365 & Excel 2019 Comprehensive (1st Edition)

Book Edition1st Edition
Author(s)Freund, Last
PublisherCengage Learning
SubjectComputer Science
Chapter 9, Formula Auditing , Q&A, Exercise 01
Page EX 9-8

How do I interpret the precedent arrows?


In Excel, trace precedents and trace dependents are used to locate the cells that contain the formula. Trace Precedents indicates the cells that affect the active cell's value and Trace Dependents indicates the cells affected by the active cell. You can identify trace precedents and trace dependents by tracer arrows


How To Show Trace Dependents Or Precedents Arrow In Excel?

In some cases, if there are many formulas in your sheet, you may want to clearly see the relationships among the cells in Excel. To show the trace dependents or precedents arrow will be a good way.

Show trace dependents (precedents) arrow

Show all trace dependents (precedents) arrow with Kutools for Excel 

 Show Trace Dependents (Precedents) Arrow

It is easy to show the trace arrows in Excel.

There are two trace arrow types, one is Trace Precedents arrow, and the other is Trace Dependents arrow.

To show Trace Precedents arrow:


Select cell you need and click Formulas > Trace Precedents.


To show Trace Dependents arrow:

Select cell you need and click Formulas > Trace Dependents.


Tip: You can only add a trace arrow at each time.

 Show All Trace Dependents (Precedents) Arrow With Kutools For Excel

With Excel built-in function, you only can show one type of trace arrows once time, but with Kutools for Excel's Monitor of Dependents and Precedents, you can show all precedents or dependents or booth precedents and dependents in a range once time.

After installing Kutools for Excel, please do as below:(Free Download Kutools for Excel Now!)

1. Click Kutools > More (in the Formula gourp), and then enable one operation you need in the sub menu, See screenshot:

2. Then select a cell or a range that you want to show the trace arrows, and now the type of trace arrow you select are shown in the selection.

Monitor Precedents of RangesMonitor Dependents of RangesMonitoer Precedents and Dependents

Note: Click Kutools > More > Monitor Precedents of Ranges/Monitor Dependents of Ranges/Monitoer Precedents and Dependents again to disable it.










Did you like this example?
Subscribe for full access
Page EX 9-8