| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Two formulas in on cell based on two numbers in another cell? | Excel Discussion (Misc queries) | |||
| How to change cell reference within formulas | Excel Worksheet Functions | |||
| How to change Cell color using formulas | Excel Discussion (Misc queries) | |||
| Pasting formulas | Excel Discussion (Misc queries) | |||
| Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
Linear Mode
