copying and pasting a formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

William - 21 Nov 2005 23:23 GMT

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 to this Message

Gary''s Student - 21 Nov 2005 23:33 GMT

Start with =A1*Z$1
____________________________________
Gary's Student

> 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 to this Message

Gord Dibben - 22 Nov 2005 00:25 GMT

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

>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 to this Message