Display the relationships between formulas and cells
Sometimes, checking formulas for accuracy or finding the source of an error can be difficult when the formula uses precedent or dependent cells:
Precedent cells are cells that are referred to by a formula in another cell. For example, if cell L10 contains the formula =J7, cell J7 is a precedent to cell L10.
Dependent cells contain formulas that refer to other cells. For example, if cell L10 contains the formula =J7, cell L10 is a dependent of cell J7.
To assist you in checking your formulas, you can use the Trace Precedents and Trace Dependents commands to graphically display, or trace the relationships between these cells and formulas with tracer arrows.
In the example shown above, you can simply go to Formula Tab and click Trace Precedents to find out the calculations behind the Net Expenses number.
To display a tracer arrow to each cell that is dependent on the active cell, on the Formulas tab, in the Formula Auditing group, click Trace Dependents.
and you can use Remove Arrows button to get rid of all the arrows from the woksheets.
