View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gee-off Gee-off is offline
external usenet poster
 
Posts: 19
Default Simple Copy & Paste..Confusing??

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.