Neil,

It sounds like you cut/paste instead of copy/paste.

Ctrl+x = cut
Ctrl+c = copy

Pamela :)

"Neil22" wrote:


I just ran into a Excel problem that is new to me. We are running Excel
2000.
If I have a formula =SUM(A1:C1) in cell D1 and I copy the formula to
cell D2 the formula in cell D2 should be =SUM(A2:C2) but it is not! it
is =SUM(A1:C1). Some settings must be off.

Please help!
Thanks,
Neil


--
Neil22
------------------------------------------------------------------------
Neil22's Profile: http://www.excelforum.com/member.php...fo&userid=4179
View this thread: http://www.excelforum.com/showthread...hreadid=481730