shortcut key for dependent

[Guest]

I know that Tracying the dependent cell, i should use Ctrl + "[" .

Is there shortcut key that I can go back?

 

[RagDyeR]

Sort of intuitive to try:

<Ctrl> <]>

NO?

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I know that Tracying the dependent cell, i should use Ctrl + "[" .

Is there shortcut key that I can go back?

 

[Guest]

Seems doesn't work...

 

[Ragdyer]

Works fine for me.

How intricate and convoluted are your formulas?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Seems doesn't work...

Sort of intuitive to try:

<Ctrl> <]>

NO?

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I know that Tracying the dependent cell, i should use Ctrl + "[" .

Is there shortcut key that I can go back?

 

[Guest]

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

Works fine for me.

How intricate and convoluted are your formulas?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Seems doesn't work...

Sort of intuitive to try:

<Ctrl> <]>

NO?

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I know that Tracying the dependent cell, i should use Ctrl + "[" .

Is there shortcut key that I can go back?

 

[Ragdyer]

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 !
---------------------------------------------------------------------------

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

Works fine for me.

How intricate and convoluted are your formulas?

--
Regards,

RD

--------------------------------------------------------------------------

-

Please keep all correspondence within the NewsGroup, so all may benefit

!

--------------------------------------------------------------------------

-

Seems doesn't work...

:

Sort of intuitive to try:

<Ctrl> <]>

NO?

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I know that Tracying the dependent cell, i should use Ctrl + "[" .

Is there shortcut key that I can go back?