Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut key for dependent
I know that Tracying the dependent cell, i should use Ctrl + "[" . Is there shortcut key that I can go back? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut key for dependent
Sort of intuitive to try:
<Ctrl <] NO? -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Leung" wrote in message ... I know that Tracying the dependent cell, i should use Ctrl + "[" . Is there shortcut key that I can go back? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut key for dependent
Seems doesn't work...
"RagDyeR" wrote: Sort of intuitive to try: <Ctrl <] NO? -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Leung" wrote in message ... I know that Tracying the dependent cell, i should use Ctrl + "[" . Is there shortcut key that I can go back? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut key for dependent
Works fine for me.
How intricate and convoluted are your formulas? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Leung" wrote in message ... Seems doesn't work... "RagDyeR" wrote: Sort of intuitive to try: <Ctrl <] NO? -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Leung" wrote in message ... I know that Tracying the dependent cell, i should use Ctrl + "[" . Is there shortcut key that I can go back? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut key for dependent
Hi
My formula is simply: in Sheet1!A1 =+Sheet2!C1 So when I am in Sheet1!A1, I click Ctrl + "[" then I will be in Sheet2!C1, but is there any shortcut that I can go back to Sheet1!A1 ? I am using Office XP + Excel 2003. thanks Leung "Ragdyer" wrote: Works fine for me. How intricate and convoluted are your formulas? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Leung" wrote in message ... Seems doesn't work... "RagDyeR" wrote: Sort of intuitive to try: <Ctrl <] NO? -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Leung" wrote in message ... I know that Tracying the dependent cell, i should use Ctrl + "[" . Is there shortcut key that I can go back? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut key for dependent
There's no actual *shortcut* to return to another sheet, if that cell has no
reference to show anything back in the original sheet. To return, you'll have to follow a procedure which I don't categorize as a shortcut. Say you <Ctrl < [ from Sheet1 A1, to Sheet2 C1. Once you're in C1, click: <Tools <Auditing <Trace Dependents This will give you an arrow with a dashed line, pointing to a worksheet icon. Hover your cursor over that dashed line until it changes to an arrow ... Then ... *double click*. This brings up the GO TO window, with the path *back* to the original cell in Sheet1 displayed in the GoTo box. *Double click* on the path, and you'll end up back where you started, in Sheet1. Now, that's not really a shortcut, but it does work. BTW, you'll still have that WS icon and arrow displayed. If you jump to C1 again, you can use it again. But if you want to get rid of it: <Tools <Auditing <Remove Arrows Also, FWIW, you don't need that plus sign in your link formula! =Sheet2!C1 Is good enough. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Leung" wrote in message ... Hi My formula is simply: in Sheet1!A1 =+Sheet2!C1 So when I am in Sheet1!A1, I click Ctrl + "[" then I will be in Sheet2!C1, but is there any shortcut that I can go back to Sheet1!A1 ? I am using Office XP + Excel 2003. thanks Leung "Ragdyer" wrote: Works fine for me. How intricate and convoluted are your formulas? -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Leung" wrote in message ... Seems doesn't work... "RagDyeR" wrote: Sort of intuitive to try: <Ctrl <] NO? -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Leung" wrote in message ... I know that Tracying the dependent cell, i should use Ctrl + "[" . Is there shortcut key that I can go back? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dependent rows | Excel Worksheet Functions | |||
Cell dependent on another | Excel Discussion (Misc queries) | |||
Sum if contains dependent | Excel Discussion (Misc queries) | |||
Dependent lists | Excel Worksheet Functions | |||
dependent dropdown | Excel Discussion (Misc queries) |