Microsoft Office Tutorials and References

In Depth Information

**Auditing a Worksheet**

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

Use any of the following options:

• Click the
Trace Precedents
button to find cells that provide data to a for-

mula.

• Click the
Trace Dependents
button to find out which formulas refer to a

cell.

• Click the
Error Checking
button arrow, and then click
Trace Error
to loc-

ate the problem if a formula displays an error value, such as #DIV/0!.

• Click the
Remove Arrows
button arrow, and then click
Remove Precedent

Arrows
,
Remove Dependent Arrows
, or
Remove All Arrows
to remove

precedent and dependent arrows.