Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
fomula tracing
I am handling a very large financial model. Using fomula tracing
tools, I can double click the dotted line and go to the another spreadsheet giving input to the current sheet. My question is the following: Is there an easy way to come back to the current sheet that I jump from? Otherwise, I have to remember the sheet that I have bowsed and search it manually. Thanks a lot. |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
fomula tracing
Elysia wrote:
Is there an easy way to come back to the current sheet that I jump from? F5, Enter? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
You can use "Trace Precedents" under Formula Auditing @ Office 2007 or under Tools @ Office 2003 to go back to the starting point.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for alphabet tracing | Excel Discussion (Misc queries) | |||
Tracing precedents | Excel Worksheet Functions | |||
Auding Tool bar for Precedent Tracing Greyed Out | Excel Discussion (Misc queries) | |||
Tracing dependents - Excel 2003 | Excel Discussion (Misc queries) | |||
Tracing Dependents | Excel Discussion (Misc queries) |