Microsoft® Office Excel® 2007 Inside Out

Auditing and Documenting Worksheets

Office Excel 2007 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-52.

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

Checking for Errors

Click the Error Checking button to quickly find any error values displayed on the current worksheet and display the Error Checking dialog box, as shown in Figure 8-53. The first erroneous cell in the worksheet is selected, ...