Formula auditing

Formula auditing groups the tools that help you understand and fix a calculation. Trace Precedents and Dependents shows where a value comes from and where it goes, Evaluate Formula runs the calculation step by step, and the Watch Window monitors distant cells. They are in the Formulas tab.

Example

Formulas > Evaluate Formula to follow each step of a complex calculation.

Related concepts

The whole glossary