Who else wants to know the secret to Excel Formulas?Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today
Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007, Excel 2010 or Excel 2013.
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!