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

Auditing a Worksheet

In a complex worksheet, it can be difficult to understand the relationships between cells and formulas. Auditing tools enable you to clearly determine these relationships. When the Auditing feature is turned on, it uses a series of arrows to show you which cells are part of which formulas. When you use the auditing tools, tracer arrows point out cells that provide data to formulas and the cells that contain formulas that refer to the cells. A box is drawn around the range of cells that provide data to formulas.

Trace Worksheet Relationships

Click the Tools menu, point to Formula Auditing, and then click Show Formula Auditing Toolbar.

  • Trace Precedents To find cells that provide data to a formula.

  • Trace Dependents To find out which formulas refer to a cell.

  • Trace Error To locate the problem if a formula displays an error value, such as #DIV/0!.

  • Remove Precedent Arrows, Remove Dependent Arrows, or Remove All Arrows To remove precedent and dependent arrows.

Click OK to locate the problem.

Did You Know?

You can circle invalid data. To circle invalid data in a formula, click the Circle Invalid Data button on the Formula Auditing toolbar. Click the Clear Validation Circles button to clear the circles.


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