If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
fomula tracing
Bill Manville;565424 Wrote: 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 You can use "Trace Precedents" under Formula Auditing @ Office 2007 or under Tools @ Office 2003 to go back to the starting point. -- birdsting |
Thread Tools | |
Display Modes | |
|
|