Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses london - Tracing precedents
|
|
|
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. |
excel vba courses london - Tracing precedents
Resolved · Low Priority · Version Standard
Reply Wed 15 Aug 2007, 13:46Delegate Tim said...
Tim has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced course
Tracing precedents
When formula auditing, Is it possible to trace precedents onto different pages of a workbook.
When you go to trace precedents for a particular cell, it just has a line to a little excel sheet sign. How do you follow the line on to the page where the referred to cell is?
Is there a command to show the different pages to which a cell refers concurrently?
For upcoming training course dates see: Pricing & availability
RE: Tracing precedents
Hi Tim
Thank you for your question.
What will happen when you use Trace Error where the cell in question refers to cell/s on other sheets, you will get a dashed line and a little spreadsheet icon appear on the spreadsheet. If you double-click at any point along the dashed line, the Go To dialogue box will appear on your screen listing the cells that are referred to in the formula so that you can select a cell reference from the Go To dialogue box and click OK to go to that cell and investigate what the problem might be.
This also gives you a way of being able to see what cells a particular formula refers to.
I hope this helps.
Amanda
|