O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

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 Workbooks

The auditing features are some of the most useful tools in Excel. These tools can help you detect problems in your worksheet formulas. Excel supplies a Formula Auditing toolbar to help you find errors on your worksheets, attach comments to cells, and track problems in your worksheet formulas.

Using auditing tools can help you understand, visualize, and troubleshoot the relationships among cell references, formulas, and data.

When you're auditing formulas in your worksheets, you might want to use the Go To Special command to quickly search for comments, precedents, dependents, or any other auditing information. The Go To Special command helps you find the following information while auditing your worksheets:

  • Comments

  • Constants ...

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