Forum home » Delegate support and help forum » Microsoft Excel Training and help » Trace dependants
|
|
|
The UK's most regular 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. |
Trace dependants
Resolved · Low Priority · Version 2003
Reply Fri 30 May 2008, 15:48Delegate Des said...
For upcoming training course dates see: Pricing & availability
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
|