Excel not copying

[megan]

My Excel is not copying properly. When I copy paste 1A +1B, to the next line
It's still giving me 1A + 1B rather than 2A + 2B.

Also, it is suddenly not recalculating values. So when I put in a new value
in a cell the total is not changin.

 

[Gord Dibben]

If you enter a formula such as =A1 + B1 then copy/paste to another cell and it
does not change, I would suggest your Tools>Options>Calculation mode is set the
"Manual".

Change it to "Automatic".


Gord Dibben MS Excel MVP

 

[David Biddulph]

1A and 1B are text, not cell references, so they won't change when you copy
them.
Cell references look like A1 and B1.
--
David Biddulph

My Excel is not copying properly. When I copy paste 1A +1B, to the next
line
It's still giving me 1A + 1B rather than 2A + 2B.

....