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 » Dependencies
Dependencies
Resolved · Low Priority · Version 2003
RE: dependencies
Hi Jenna,
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:Colouring cells containing formulasCells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells. |