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-51.

The Formula Auditing group on the Formulas tab provides access to most of the auditing features.

Figure 8-51. The Formula Auditing group on the Formulas tab provides access to most of the auditing features.

Checking for Errors

Checking for Errors

image with no caption

Click the Error Checking button on the Formulas tab to quickly find any error values displayed on the current worksheet and ...

Get Microsoft® Excel® 2010 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.