Microsoft Office Tutorials and References
In Depth Information
Auditing and documenting worksheets
Auditing and documenting worksheets
Excel has a number of powerful and flexible features that help you audit and debug your
worksheets and document your work. Most of the Excel auditing features appear on the
Formulas tab, in the Formula Auditing group, which is shown in Figure 8-56.
Figure 8-56 The Formula Auditing group on the Formulas tab provides access to most of the
auditing features.
Checking for errors
On the Formulas tab, click the Error Checking button to quickly find any error values
displayed on the current worksheet and display the Error Checking dialog box if any errors are
found, as shown in Figure 8-57. The first erroneous cell in the worksheet is selected, and its
contents are displayed in the dialog box along with a suggestion about the nature of the
problem.
Figure 8-57 The Error Checking dialog box helps you figure out what’s wrong with formulas that
display error values.
Search JabSto ::




Custom Search