Microsoft Office Professional 2010 Step by Step eBook

(Ben Green) #1
The auditing arrow indicates that the cells in the range C3:C7 provide the value for the
formula in cell D8.


  1. In the Formula Auditing group, click the Remove Arrows button.


The arrow disappears.


  1. Click cell A1.

  2. In the Formula Auditing group, click the Error Checking button.


The Error Checking dialog box opens.

The dialog box displays the error found in cell D1.

Finding and Correcting Errors in Calculations 305

Free download pdf