Trace dependants

The UK's most regular instructor-led training courses.
Training information: excel 2003 visual basic intermediate course · Excel in courses · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Trace dependants

Des has attended:
Excel Intermediate course

by - delegate Des [1 post] (2008 May 30 Fri, 15:48) Reply

How do you trace dependants

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 12 Mon	Bayswater	3	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	1	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
2007	2009 Jan 20 Tue	Bloomsbury	3	book now	£224	£224
2003	2009 Jan 20 Tue	Southwark	4	book now	£207	£215
Full Schedule: See all 134 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: trace dependants

by - trainer Simon gold contributer [214 posts] (2008 Jun 4 Wed, 13:22) Reply

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

· Advanced Excel Training - takes you to the next level
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· Improve Performance Of Your Excel Macros
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Database Tips from an Excel Training Course

Please browse our web site to find out more about
excel 2003 visual basic intermediate course and other Microsoft training courses.

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips

Rate this page: