Use diagram to audit formulas
-
Select the cell in the data range to audit
-
Go to Formulas tab > Formulas Auditing group > select one of the following:
-
If the selected cell contains data that feeds into a formula, select Trace Precedents
-
If the selected cell contains formula that a cell feeds into, select Trace Dependents
-
To use shortcut to show precedents and dependents without drawing arrows, do the following:
-
Select direct dependent cells: CTRL + ]
-
Select direct and indirect dependent cells: CTRL + SHIFT + ]
-
Select direct precedent cells: CTRL + [
-
Select direct and indirect precedent cells: CTRL + SHIFT + [
-
To remove arrows created by tracing precedents and dependents, go to Formulas tab > Formulas Auditing group > click on Remove Arrows
