Microsoft Office Tutorials and References
In Depth Information
Identifying dependents
Figure 202-1: This worksheet displays arrows that indicate cell precedents for the formula in cell C13.
Identifying dependents
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.
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, and Excel draws arrows to
indicate the cell’s dependents. Click this button multiple times to see additional levels of
dependents. Choose Formulas
Formula Auditing
Formula Auditing
Remove Arrows to hide the arrows.
Again, these techniques are limited to identifying dependent cells only on the active worksheet.
Search JabSto ::

Custom Search