• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Auditing Workbooks

Excel workbooks can often grow large and complex. The more complex a workbook is, the harder it is to ensure that it's doing its job correctly. With cell values and formulas used throughout the worksheet, finding the source of errors can be a real chore-unless you use Excel's built-in auditing features.

With Excel, you can display tracer lines to find precedents (cells that are referred to by a formula), dependents (cells that contain formulas that refer to other cells), and errors in any cell. Most of the time when you use the auditing feature, you probably want to trace the precedents to a formula to find out what other cells contribute to the formula in that cell. Once you find the source of your error, you can remove all tracer lines from the display with the click of a button.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint