This textbook is available at
Chapter 9, Formula Auditing , Q&A, Exercise 01

# How do I interpret the precedent arrows?

### Explanation

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.

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.

Page EX 9-8