Tuesday, July 6, 2010

Excel: Trace Precedents/Trace Dependents

Trace Precedents: Shows arrows that indicate what are all the cells affecting the value of currently selected cell.
Here, value of the currently selected cell H14 is the sum of the cells H10 and H12. In turn, value of H10 and H12 is calculated using other cells.



Trace Dependents: Shows arrows that indicate what cells are affected by the value of the currently selected cell.


No comments:

Post a Comment