use $A$4 instead of A4

"ISMEGORDO" wrote:

Hi there all,

I know it can be done I just forget the naming of this cell

I want to have several Cells that the formula in it has One Particular cell
in it, I want to then be able to click and Drag this formula Down the page to
Autofill the celles bello, But that one Cell (in the formula cannot change)

ie:Cell D2 =(A4 *B6)
Cell D3 =(A4 * B7)
And So On I am Pretty sure that the cel A4 had ! in it to keep that from
moving to the next cell when auto filling

Any Idead Thanks In Advance

Gordon