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?