Microsoft® Excel® 2010 Inside Out

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.

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

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