copying formulas

[soozstray]

How can I copy a formula by pulling the cell I want to copy down the whole column? I used to be able to do this and now it doesn't work. Example of what I want it to do:

=SUM(F2*G1)

=SUM(F3*G1)

=SUM(F4*G1)

This is what it's doing that I don't want:

=SUM(F2*G1)

=SUM(F3*G2)  

=SUM(F4*G3)

Thanks!

[#2]

@soozstray No need for the SUM, but fix the G1 reference using $ signs like:

=F2*$G$1

and copy it down.

[#3]

Oh wow! thanks so much!