ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   fomula tracing (https://www.excelbanter.com/links-linking-excel/159012-fomula-tracing.html)

Elysia

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.


Bill Manville

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


birdsting

Quote:

Originally Posted by Bill Manville (Post 565424)
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.


All times are GMT +1. The time now is 09:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com