shortcut key for dependent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Is there shortcut key that I can go back?
 
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?
 
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 said:
Seems doesn't work...

RagDyeR said:
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?
Click to expand...
Click to expand...
 
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 said:
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 said:
Seems doesn't work...

RagDyeR said:
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?
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
Works fine for me.

How intricate and convoluted are your formulas?

--
Regards,

RD

--------------------------------------------------------------------------
Click to expand...
-
Please keep all correspondence within the NewsGroup, so all may benefit
Click to expand...
!
--------------------------------------------------------------------------
Click to expand...
-
Leung said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top