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?