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?
|