 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Fastest ways to trace formulas (especially when cells link to other worksheets)
Hello, I am finding it challenging to trace my formulas when they link to other spreadsheets. It is a manual and tedious process, and I am thinking that there has got to be a faster way than physically searching for the cells to which the formulas are referring. Does anyone know of a fast way to jump to precedents and dependents of formulas. (I did notice the formula auditing toolbar, but it seems to only work when you are trying to trace formulas in the SAME worksheet). Thanks for any suggestions. For tracing across sheets, if you were to double-click on the dotted arrow that points to/from the little spreadsheet icon, that'll bring up a "Go To" dialog to navigate quickly to either the precedent(s) / dependent(s)  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Hello, I am finding it challenging to trace my formulas when they link > to other spreadsheets. It is a manual and tedious process, and I am [quoted text clipped - 7 lines] > > Thanks for any suggestions. > For tracing across sheets, if you were to double-click on the dotted arrow > that points to/from the little spreadsheet icon, that'll bring up a "Go To" [quoted text clipped - 20 lines] > > - Show quoted text - Thanks! Incredibly helpful. welcome, Mike. SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- "Mike C" wrote Thanks! Incredibly helpful. Ctrl+[ Pressing control+[ while on a formula will jump to the first cell or range that the formula refers to. This can be particularly useful when the ranges are external references as it will then open the workbook and jump to the appropriate range. > Hello, I am finding it challenging to trace my formulas when they link > to other spreadsheets. It is a manual and tedious process, and I am [quoted text clipped - 7 lines] > > Thanks for any suggestions. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.