O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, 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. In this section, you explore the following features: cell tracers, error checking, Formula Auditing mode, the Evaluate Formula dialog box, the Watch Window, Text To Speech, the Comment command, and Go To Special.

Most of Excel's auditing features can be accessed via the Formula Auditing toolbar, which is shown in Figure 9-8. You display the Formula Auditing toolbar by choosing Formula Auditing on the Tools menu and then clicking Show Formula Auditing Toolbar.

The Formula Auditing toolbar provides access to most of Excel's auditing features.

Figure 9-8. The Formula Auditing ...

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