Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trace dependants/precedents from another worksheet
How do I trace dependants/precedents that come from another worksheet? When
the dotted arrow comes up pointing to the little spreadsheet icon, I can't click on the icon to see what it's referring to! Peter |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trace dependants/precedents from another worksheet
If you were to double-click on the dotted arrow, that'll bring up a "Go To"
dialog to navigate to either the precedent(s) / dependent(s) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Atreides" wrote: How do I trace dependants/precedents that come from another worksheet? When the dotted arrow comes up pointing to the little spreadsheet icon, I can't click on the icon to see what it's referring to! Peter |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trace dependants/precedents from another worksheet
Great, thanks Max!
Not especially obvious if you ask me, but at least it works. "Max" wrote: If you were to double-click on the dotted arrow, that'll bring up a "Go To" dialog to navigate to either the precedent(s) / dependent(s) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Atreides" wrote: How do I trace dependants/precedents that come from another worksheet? When the dotted arrow comes up pointing to the little spreadsheet icon, I can't click on the icon to see what it's referring to! Peter |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trace dependants/precedents from another worksheet
You're welcome, Peter !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Atreides" <atreides1AThotmailD0Tcom wrote in message ... Great, thanks Max! Not especially obvious if you ask me, but at least it works. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trace dependants/precedents from another worksheet
Thanks, Atreides.....works like a charm!
"Atreides" wrote: How do I trace dependants/precedents that come from another worksheet? When the dotted arrow comes up pointing to the little spreadsheet icon, I can't click on the icon to see what it's referring to! Peter |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trace dependants/precedents from another worksheet
Hi Max,
Is there a way to do this without the double click (i.e. use a keystroke instead of double clicking)? Thanks, Chaim "Max" wrote: If you were to double-click on the dotted arrow, that'll bring up a "Go To" dialog to navigate to either the precedent(s) / dependent(s) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Atreides" wrote: How do I trace dependants/precedents that come from another worksheet? When the dotted arrow comes up pointing to the little spreadsheet icon, I can't click on the icon to see what it's referring to! Peter |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trace dependants/precedents from another worksheet
For some reason I can't see the entire thread ... just this post.
Anyway, no need to click on the Menu Bar. Just select the cell of interest, and this will not only jump to other sheets, but will also even open closed workbooks! <Ctrl < [ and/or <Ctrl < ] -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "clubin" wrote in message ... Hi Max, Is there a way to do this without the double click (i.e. use a keystroke instead of double clicking)? Thanks, Chaim "Max" wrote: If you were to double-click on the dotted arrow, that'll bring up a "Go To" dialog to navigate to either the precedent(s) / dependent(s) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Atreides" wrote: How do I trace dependants/precedents that come from another worksheet? When the dotted arrow comes up pointing to the little spreadsheet icon, I can't click on the icon to see what it's referring to! Peter |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trace dependants/precedents from another worksheet
This shortcut only takes you to where the formula for the cell is
referencing. However, if the cell is being used on a separate worksheet (i.e. there is a dependent not on the formula bar) the only way to get to it seems to be with bringing up the trace precedents/dependents and then clicking on the worksheet icon. I am wondering if there is a keystroke that can be used instead of double clicking on the worksheet icon when this is the case. Thank you for the insight though. If anyone else knows the anwers to this it would be appreciated. Thank you, Chaim "RagDyer" wrote: For some reason I can't see the entire thread ... just this post. Anyway, no need to click on the Menu Bar. Just select the cell of interest, and this will not only jump to other sheets, but will also even open closed workbooks! <Ctrl < [ and/or <Ctrl < ] -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "clubin" wrote in message ... Hi Max, Is there a way to do this without the double click (i.e. use a keystroke instead of double clicking)? Thanks, Chaim "Max" wrote: If you were to double-click on the dotted arrow, that'll bring up a "Go To" dialog to navigate to either the precedent(s) / dependent(s) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Atreides" wrote: How do I trace dependants/precedents that come from another worksheet? When the dotted arrow comes up pointing to the little spreadsheet icon, I can't click on the icon to see what it's referring to! Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need data from one worksheet to be in a list in another worksheet. | Excel Discussion (Misc queries) | |||
Excel: Relative worksheet references? | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Trace ALL dependent cells in any worksheet anywhere in Excel | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions |