Yes, you can use

=A1*$B$1

where B1 holds the constant

another way woul be to copy B1, select the range and do editpaste special
and select multiply

Regards,

Peo Sjoblom

"flotowntiger" wrote:

I want to multiply a group of cell's by a constant in anouther cell. If I
drag the bottom right corner it changes the referenced cell. Isn't the "$"
somehow used in this function?