If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
don't want cell numbers to change when pasting formulas
Hi all!
I wrote a payroll program in excel, but when I try to make a "template" and copy it I find that it automatically adjusts the cell numbers, which I do not want it to do. I have tried pasting and pasting "special" and cannot get it to just paste the formula without adjusting the cell numbers. |
#2
|
|||
|
|||
don't want cell numbers to change when pasting formulas
You need to lock the cell down by using the "$" sign
so rather than having =c4 make instead of =$c$4 and then copy as needed. -- Wag more, bark less "Sarah Z" wrote: Hi all! I wrote a payroll program in excel, but when I try to make a "template" and copy it I find that it automatically adjusts the cell numbers, which I do not want it to do. I have tried pasting and pasting "special" and cannot get it to just paste the formula without adjusting the cell numbers. |
#3
|
|||
|
|||
don't want cell numbers to change when pasting formulas
you can put $ in all the cell references, like: =sum($a$1.$a$10)
not sure if there is a quicker way? "Sarah Z" wrote: Hi all! I wrote a payroll program in excel, but when I try to make a "template" and copy it I find that it automatically adjusts the cell numbers, which I do not want it to do. I have tried pasting and pasting "special" and cannot get it to just paste the formula without adjusting the cell numbers. |
#4
|
|||
|
|||
don't want cell numbers to change when pasting formulas
Thank you! I knew there had to be an easy way to do this! Works great!
"Brad" wrote: You need to lock the cell down by using the "$" sign so rather than having =c4 make instead of =$c$4 and then copy as needed. -- Wag more, bark less "Sarah Z" wrote: Hi all! I wrote a payroll program in excel, but when I try to make a "template" and copy it I find that it automatically adjusts the cell numbers, which I do not want it to do. I have tried pasting and pasting "special" and cannot get it to just paste the formula without adjusting the cell numbers. |
Thread Tools | |
Display Modes | |
|
|