1 column multiplied by 1 row throughout sheet

[Rob Maeurer]

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?

 

[PCLIVE]

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

=$C6*D$5

HTH,
Paul

 

[FSt1]

hi
use absolute reference instead of relative reference

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

regards
FSt1