Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping forumla cell reference after cut and pasting
I am trying to cut and paste data, while maintaining the same forumula
references that I had before. For example before I cut and paste lets say the formula is: =$A$1+$B$1 Now lets say I want to move the data in A1 and B1 over one spot, so I cut the two cells and paste them in B1 and C1. Excel automatically updates the formula to: =$B$1+$C$1 How do I make the formula stay as it was orginally? Thanks for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping forumla cell reference after cut and pasting
=INDIRECT("$A$1")+INDIRECT("$B$1")
-- David Biddulph "Eli" wrote in message ... I am trying to cut and paste data, while maintaining the same forumula references that I had before. For example before I cut and paste lets say the formula is: =$A$1+$B$1 Now lets say I want to move the data in A1 and B1 over one spot, so I cut the two cells and paste them in B1 and C1. Excel automatically updates the formula to: =$B$1+$C$1 How do I make the formula stay as it was orginally? Thanks for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping forumla cell reference after cut and pasting
One way
replace the formula with =INDIRECT("A1")+INDIRECT("B1") or for that particular formula =SUM(INDIRECT("A1:B1")) no need to use the dollar signs since it is a text reference inside INDIRECT -- Regards, Peo Sjoblom "Eli" wrote in message ... I am trying to cut and paste data, while maintaining the same forumula references that I had before. For example before I cut and paste lets say the formula is: =$A$1+$B$1 Now lets say I want to move the data in A1 and B1 over one spot, so I cut the two cells and paste them in B1 and C1. Excel automatically updates the formula to: =$B$1+$C$1 How do I make the formula stay as it was orginally? Thanks for your help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping forumla cell reference after cut and pasting
perhaps a bit crude, but if you don't have to do this routine much before
copying you can edit the formula to "z=$A$1+$B$1" (without the quotes) then Copy and paste. In the pasted cell - Edit (F2) and remove the "z". Done "Eli" wrote: I am trying to cut and paste data, while maintaining the same forumula references that I had before. For example before I cut and paste lets say the formula is: =$A$1+$B$1 Now lets say I want to move the data in A1 and B1 over one spot, so I cut the two cells and paste them in B1 and C1. Excel automatically updates the formula to: =$B$1+$C$1 How do I make the formula stay as it was orginally? Thanks for your help. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping forumla cell reference after cut and pasting
Eli,
Thought I would pass along a very simple technique. IF you copy the formula within the formula edit bar and use the check mark before you leave the formula bar all "Pastes" will remain as your wrote it. "JMay" wrote: perhaps a bit crude, but if you don't have to do this routine much before copying you can edit the formula to "z=$A$1+$B$1" (without the quotes) then Copy and paste. In the pasted cell - Edit (F2) and remove the "z". Done "Eli" wrote: I am trying to cut and paste data, while maintaining the same forumula references that I had before. For example before I cut and paste lets say the formula is: =$A$1+$B$1 Now lets say I want to move the data in A1 and B1 over one spot, so I cut the two cells and paste them in B1 and C1. Excel automatically updates the formula to: =$B$1+$C$1 How do I make the formula stay as it was orginally? Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy & Paste Forumla - but reference cell is changing | Excel Discussion (Misc queries) | |||
pasting a forumla w/o the paste/special/value | Excel Discussion (Misc queries) | |||
Using cell reference and wildcards in a forumla | Excel Discussion (Misc queries) | |||
Keeping a cell reference. | Excel Discussion (Misc queries) | |||
Is there a forumla to link an absolute cell reference in multiple. | Excel Worksheet Functions |