cell reference

[Rohit]

Hi

if cell A1 is reference to A10. And when i double click in cell A1 it goes
to cell A10. my question is how to come back to cell A1.

 

[Ms-Exl-Learner]

Try this.

If it is 2003:
Tools>>Options>>Edit>>Settings>>(Check the) Edit Directly in Cell

If it is 2007:
Excel Options>>Editing Options>>(Check the) Allow Editing Directly in Cells

Now go to a1 cell and do double click

If this post helps, Click Yes!

 

[RagDyer]

Use:
<Ctrl> <]>

BTW, instead of double clicking in A1, you could jump back and forth between
A1 and A10 by holding <Ctrl> and hitting < [ > and then < ] >.

 

[Ms-Exl-Learner]

Nice Shortcut Regdyer!

--------------------
(MS-Exl-Learner)
--------------------

Use:
<Ctrl> <]>

BTW, instead of double clicking in A1, you could jump back and forth between
A1 and A10 by holding <Ctrl> and hitting < [ > and then < ] >.
--
HTH,

RD

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

Hi

if cell A1 is reference to A10. And when i double click in cell A1 it goes
to cell A10. my question is how to come back to cell A1.

 

[Rohit]

Hi
for some reason, returing to cell A1 is not working. is it ctrl ]
or...........

Use:
<Ctrl> <]>

BTW, instead of double clicking in A1, you could jump back and forth between
A1 and A10 by holding <Ctrl> and hitting < [ > and then < ] >.
--
HTH,

RD

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

Hi

if cell A1 is reference to A10. And when i double click in cell A1 it goes
to cell A10. my question is how to come back to cell A1.