| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Line copy - Not just a simple copy paste | Excel Worksheet Functions | |||
| Simple Copy and Paste | Excel Programming | |||
| Copy & paste simple problem | Excel Programming | |||
| Simple Copy & Paste | Excel Programming | |||
| Simple copy and paste | Excel Programming | |||
Hybrid Mode
