Use absolute references i.e change your original formula to =$A$1+$B$1
and then copy it as required.

Hope this helps
Rowan

Gee-off wrote:
A B
1 (=A1+B1)
2
3

Alright, we allknow how to copy and paste cell to cell. What i don't know
to do, is I want to move "A1" to "B2" & "C2". How do I move these while
keeping the formula as in "A1"? I don't want the formula to change at all
when it gets moved to"B2" & "C2". Thanks for your help.