O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required