Microsoft Office Tutorials and References

In Depth Information

**Finding and correcting errors in calculations**

6

3

On the
Formulas
tab, in the
Formula Auditing
group, click the
Remove Arrows

button to remove the tracer arrow.

7

Click cell
A1
.

8

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

D21.

9

Click
Next
to move to the next error. Excel displays a message box indicating that

there are no more errors in the worksheet.

10

Click
OK
to close both the message box and the
Error Checking
dialog box.

11

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.