
Tracing Excel formula errors is tedious, if not guided by the built-in formula auditing tools. The formula bar itself is a good starting place to debug formula errors but when the formula gets longer and more complicated, a visual guide to trace the dependents is a great help. You can use the Trace Precedents button on the Formula Auditing toolbar to trace all the generations of cells that contribute to the formula in the selected cell...