Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying and pasting a formula
I have the formula "=A1*Z1." I would like to copy and paste this formula to
several cells starting with the first cell down. I would like the next cell down to be "=A2*Z1" and the next one "=A3*Z1," etc. Instead what I get is "=A2*Z2" and the next one "=A3*Z3," etc. Is there a way that I can copy and paste this formula to a large amount of cells and and keep the second factor "Z1" from changing? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying and pasting a formula
Start with =A1*Z$1
____________________________________ Gary's Student "William" wrote: I have the formula "=A1*Z1." I would like to copy and paste this formula to several cells starting with the first cell down. I would like the next cell down to be "=A2*Z1" and the next one "=A3*Z1," etc. Instead what I get is "=A2*Z2" and the next one "=A3*Z3," etc. Is there a way that I can copy and paste this formula to a large amount of cells and and keep the second factor "Z1" from changing? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying and pasting a formula
William
=A1*$Z$1 The $ signs anchor the cell reference. $Z1 anchors the column Z$1 anchors the row $Z$1 anchors row and column. For more on this see Help on Absolute and Relative references. Gord Dibben Excel MVP On Mon, 21 Nov 2005 15:23:03 -0800, "William" wrote: I have the formula "=A1*Z1." I would like to copy and paste this formula to several cells starting with the first cell down. I would like the next cell down to be "=A2*Z1" and the next one "=A3*Z1," etc. Instead what I get is "=A2*Z2" and the next one "=A3*Z3," etc. Is there a way that I can copy and paste this formula to a large amount of cells and and keep the second factor "Z1" from changing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting formula doesn't work | Excel Worksheet Functions | |||
Copying and Pasting between Workbooks | Excel Worksheet Functions | |||
Trouble copying and pasting a formula | Excel Discussion (Misc queries) | |||
Copying & Pasting Formula | Excel Discussion (Misc queries) | |||
Trouble copying and pasting a formula | Excel Worksheet Functions |