copy value from cell above
 

I am trying to copy the value of the cell above but no matter, I get the cell
reference instead of the cell value.

What switch do I need to turn on or off, I have never had this problem before.

Thanks
--
Jeff C
Live Well .. Be Happy In All You Do

copy value from cell above
 

CNTRL-d
should copy from the cell directly above.
--
Gary''s Student - gsnu200756


"Jeff C" wrote:

I am trying to copy the value of the cell above but no matter, I get the cell
reference instead of the cell value.

What switch do I need to turn on or off, I have never had this problem before.

Thanks
--
Jeff C
Live Well .. Be Happy In All You Do

copy value from cell above
 

Great, Thanks .. but what was going on? I typed =, then up arrow, then cntr
enter and got the cell refrerence, ex: A12
--
Jeff C
Live Well .. Be Happy In All You Do


"Gary''s Student" wrote:

CNTRL-d
should copy from the cell directly above.
--
Gary''s Student - gsnu200756


"Jeff C" wrote:

I am trying to copy the value of the cell above but no matter, I get the cell
reference instead of the cell value.

What switch do I need to turn on or off, I have never had this problem before.

Thanks
--
Jeff C
Live Well .. Be Happy In All You Do

copy value from cell above
 

You are 100% correct!

say we put =1+2 in A1
if we click on A2 and touch CNTRL-d the same formula appears in A2
if we click on A2 and touch = UPARROW CNTRL-ENTER
a reference appears in A2.

These are two different legal ways to get two different results
--
Gary''s Student - gsnu200756


"Jeff C" wrote:

Great, Thanks .. but what was going on? I typed =, then up arrow, then cntr
enter and got the cell refrerence, ex: A12
--
Jeff C
Live Well .. Be Happy In All You Do


"Gary''s Student" wrote:

CNTRL-d
should copy from the cell directly above.
--
Gary''s Student - gsnu200756


"Jeff C" wrote:

I am trying to copy the value of the cell above but no matter, I get the cell
reference instead of the cell value.

What switch do I need to turn on or off, I have never had this problem before.

Thanks
--
Jeff C
Live Well .. Be Happy In All You Do

copy value from cell above
 

After =, then up arrow, press F9 before pressing enter.


On Nov 14, 3:31 pm, Jeff C wrote:
Great, Thanks .. but what was going on? I typed =, then up arrow, then cntr
enter and got the cell refrerence, ex: A12
--
Jeff C
Live Well .. Be Happy In All You Do



"Gary''s Student" wrote:
CNTRL-d
should copy from the cell directly above.
--
Gary''s Student - gsnu200756

"Jeff C" wrote:

I am trying to copy the value of the cell above but no matter, I get the cell
reference instead of the cell value.

What switch do I need to turn on or off, I have never had this problem before.

Thanks
--
Jeff C
Live Well .. Be Happy In All You Do- Hide quoted text -

- Show quoted text -