When you have a excel sheet full of formulas, understanding how each value is used by different formulas becomes more challenging. Easiest way to see the relation is:
Highlight the cell you want to know is used by which formulas and click on Formulas->Trace Dependence. All formulas which are directly using this value are highlighted.
Sign up our newsletter at: http://www/ascentprofessional.com/contact%20us.htm
WebSite: http://www.ascentprofessional.com/
No comments:
Post a Comment