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.

Simple Copy & Paste..Confusing??
 

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.

Simple Copy & Paste..Confusing??
 

=$a$1+B1

--
Regards,
Tom Ogilvy

"Gee-off" wrote in message
...
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.

Simple Copy & Paste..Confusing??
 

Thanks Tom, that helped me out a lot.

"Tom Ogilvy" wrote:

=$a$1+B1

--
Regards,
Tom Ogilvy

"Gee-off" wrote in message
...
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.

Simple Copy & Paste..Confusing??
 

Thanks Rowan...that was exactly what I needed. I knew it would be something
simple, but this is why I am starting Info Tech program at Univ of Phoenix,
so I can know it. thanks again.

"Rowan Drummond" wrote:

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.

Simple Copy & Paste..Confusing??
 

You're welcome.

Gee-off wrote:
Thanks Rowan...that was exactly what I needed. I knew it would be something
simple, but this is why I am starting Info Tech program at Univ of Phoenix,
so I can know it. thanks again.