1 column multiplied by 1 row throughout sheet
 

I want to copy a formula from 1 cell or a group of cells in which the column
and row values will not change.
Ex: Cell D6 = C6*D5
Cell H11 = C11*H5
Cell J15 = C15*J5
I want to be able to copy this formula into several cells without the C or
the 5 changing. How can this be achieved?

1 column multiplied by 1 row throughout sheet
 

Use a dollar sign ($) to maintain the column or row or both when copying a
formula.

=$C6*D$5

HTH,
Paul

--

"Rob Maeurer" <Rob wrote in message
...
I want to copy a formula from 1 cell or a group of cells in which the
column
and row values will not change.
Ex: Cell D6 = C6*D5
Cell H11 = C11*H5
Cell J15 = C15*J5
I want to be able to copy this formula into several cells without the C or
the 5 changing. How can this be achieved?

1 column multiplied by 1 row throughout sheet
 

hi
use absolute reference instead of relative reference

relative reference.... =C6*D5
asolute reference.... =$C$6*$D$5

regards
FSt1

"Rob Maeurer" wrote:

I want to copy a formula from 1 cell or a group of cells in which the column
and row values will not change.
Ex: Cell D6 C6*D5 Cell H11 = C11*H5
Cell J15 = C15*J5
I want to be able to copy this formula into several cells without the C or
the 5 changing. How can this be achieved?