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?