Dependency Auditor Window
Dependency Auditor Window.

Dependency Auditor shows all dependent or precedent cells in hierarchical form:
precedents
Just expand a branch too see next level of dependency.
single cell. Expand this branch too see its dependents\precedents.

range of cells. Expand it to see each cell separately.

constant value, entered into Names Collection. For example, you can define name PI=3.14159265 and use it in formulas.

range from other workbook. It could not be expanded, but you can trace dependents\precedents for this range in a separate window using context menu.

single cell (hidden) added as a result of using OFFSET or INDIRECT functions.

range of cells (hidden) added as a result of using OFFSET or INDIRECT functions.