Microsoft Office Tutorials and References
In Depth Information
Excel’s Auditing Tools
Figure 21-10: This worksheet displays lines that indicate cell precedents for the formula in cell C13.
You can identify formula cells that use a particular cell in a number of ways:
h Display the Go To Special dialog box. Select the Dependents option and then select
either Direct Only (for direct dependents only) or All Levels (for direct and indirect
dependents). Click OK. Excel selects the cells that depend on the active cell. This
technique is limited to identifying cells on the active sheet only.
h Press Ctrl+] to select all direct dependent cells on the active sheet.
h Press Ctrl+Shift+] to select all dependent cells (direct and indirect) on the active sheet.
h Choose Formulas
Trace Dependents. Excel draws arrows to
indicate the cell’s dependents. Click this button multiple times to see additional levels of
dependents. Choose Formulas
Remove Arrows to hide the arrows.
Tracing error values
If a formula displays an error value, Excel can help you identify the cell that is causing that error
value. An error in one cell is often the result of an error in a precedent cell. Activate a cell that
contains an error value and choose Formulas
Excel draws arrows to indicate the error source.
Fixing circular reference errors
If you accidentally create a circular reference formula, Excel displays a warning message, displays
Circular Reference (with the cell address) in the status bar, and draws arrows on the worksheet
to help you identify the problem.