Microsoft Office Tutorials and References
In Depth Information
Finding and correcting errors in calculations
On the Formulas tab, in the Formula Auditing group, click the Remove Arrows
button to remove the tracer arrow.
Click cell A1 .
On the Formulas tab, in the Formula Auditing group, click the Error Checking
button to open the Error Checking dialog box, which displays the error found in cell
Click Next to move to the next error. Excel displays a message box indicating that
there are no more errors in the worksheet.
Click OK to close both the message box and the Error Checking dialog box.
On the Formulas tab, in the Formula Auditing group, click the Error Checking arrow,
and then in the list, click Trace Error . Blue arrows appear, pointing to cell D21 from
cells C12 and D19 . These arrows indicate that using the values (or lack of values, in
this case) in the indicated cells generates the error in cell D21.