Excel’s Trace Error auditing tool helps you to discover the source of formula errors on your worksheet. The Trace Error tool draws arrows from the cell that causes the error to the active cell that contains the error. Should you have a relatively complex formula, this feature can save you a lot of time in trying to track down formula inaccuracies.
Some typical error values are:
#VALUE - The wrong type of operand or value is used in the formula
#DIV/0! - Occurs when a number is divided by zero.
#REF - The cell reference in the formula is not valid.
#N/A - Occurs when a value is not available to a function or formula.
#NAME - Occurs when Excel does not recognize text in a formula.
To Trace Errors in a Worksheet
- Select the cell that contains the error.
- Click the Formulas tab on the Ribbon.
- Click the arrow next to the Error Checking button on the Formula Auditing group on the Ribbon.
- Click Trace Errors.
- To remove arrows, click the Remove Arrows button on the Formula Auditing group on the Ribbon.