Microsoft Office Tutorials and References
In Depth Information
Audit a Worksheet for Errors
Audit a Worksheet
for Errors
If you see an error message, such as #DIV/0!,
you should double-check your formula references
to ensure that you referenced the correct cells.
Locating the source of an error is difficult,
however, in larger worksheets. If an error occurs,
you can use Excel’s Formula Auditing tools —
namely, Error Checking and Trace Error — to
examine and correct formula errors.
Audit a Worksheet for Errors
Apply Error Checking
1 Click the Formulas tab on the
Ribbon.
2 Click the Error Checking button.
1
2
Excel displays the Error Checking
dialog box and highlights the first
cell containing an error.
3 To fix the error, click Edit in
Formula Bar .
3
To find help with an error, you can
click here to open the help files.
To ignore the error, you can click
Ignore Error .
You can click Previous and Next
to scroll through all of the errors
on the worksheet.
4 Make edits to the cell references in
the Formula bar.
5 Click Resume .
When the error check is complete,
a prompt box appears.
6 Click OK.
4
5
6
200
 
Search JabSto ::




Custom Search