98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Trace dependants
Trace dependants
Resolved · Low Priority · Version 2003
RE: trace dependants
Hi Des,
Thank you for question.
To show the dependencies, you need to go to Tools - Formula Auditing - Show the formula auditing toolbar.
If you then select a cell that contains a formula, click on the second button on the toolbar which is Trace precedents. This will show you the cells that are used in the formula.
The second option is useful if you have something like an interest rate that is used in formulas throughout your spreadsheet. Select the cell that contains the interest rate and click on the fourth button on the toolbar Trace dependents. This will then show you all the cells that are dependent(cells that will change) upon the interest rate changing.
I hope this answers your question.
Regards
Simon
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Get back to active cellIf you have scrolled away from the active celland want to get back t it quicly you can Ctrl and Backspace to get back |