Moving changes the formula unless you make the references absolute as Anne
suggests.

There is another way. Cut and paste instead of copy and paste, but that
removes the formula from its original cell.

--
Ken Russell


Remove yourhat to reply by e-mail
..

"CShannon" wrote in message
...
I have a formula such as "=sum(d34+d35)", I decided to move the location,
but
when I move the location the formula is now "=sum(d31+d31). I would like
to
move the first formula anywhere on the spreadsheet w/o it being changed.
How
do you do that? Is it an absolute value or something like that?