Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007.
By using the “Trace Dependents” feature, you can very quickly understand exactly the influence a cell has in your spreadsheet. The best part of this feature is, that you will see big arrows that enable you to visually see the relationship, so you don’t have to decipher formulas and cell names to make sense of it all.
To turn on Trace Dependents:
1) Select the cell you want to see the dependents of
2) Make sure you are on the “Formulas” tab of the ribbon
3) Look for the “Formula Auditing” group (about 3/4 of the way along the ribbon)
4) Click on “Trace Dependents”
Now you will see arrows pointing you in the right direction!
‘till next time!