Poradnik Excela

How to Trace Precedents and Dependents in Excel

Tracing precedents and dependents helps you visualize data relationships and troubleshoot errors in your spreadsheets.

Krok po kroku

1
Navigate to the Formulas tab
Click on the 'Formulas' tab in the top ribbon menu.
2
Select the target cell
Click the cell containing the formula you want to audit.
3
Trace relationships
In the 'Formula Auditing' group, click 'Trace Precedents' to see arrows pointing to source cells, or 'Trace Dependents' to see arrows pointing to formulas that use the current cell.
4
Remove arrows
Click 'Remove Arrows' in the same group to clear the visual indicators.

Double-clicking an arrow will instantly jump your selection to the source or destination cell.

What is the difference between a precedent and a dependent?

Precedents are cells that provide data to a formula; dependents are cells that contain formulas that refer to other cells.