cell reference

  • Thread starter Thread starter Rohit
  • Start date Start date
R

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.
 
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!
 
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 < ] >.
 
Nice Shortcut Regdyer!

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



RagDyer said:
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 !
---------------------------------------------------------------------------
Rohit said:
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.
Click to expand...
Click to expand...
 
Hi
for some reason, returing to cell A1 is not working. is it ctrl ]
or...........


RagDyer said:
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 !
---------------------------------------------------------------------------
Rohit said:
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.
Click to expand...
Click to expand...
 
Back
Top