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 -