Auto fill formula

Hi

Hi I have the following formula (I have values in row 7)

=(B7*B8+C7*C8+D7*D8+E7*E8+F7*F8+G7*G8)
=(B7*B10+C7*C10+D7*D10+E7*E10+F7*F10+G7*G10)
=(B7*B11+C7*C11+D7*D11+E7*E11+F7*F11+G7*G11)

I want to carry this on for 1000 rows however when I try to fill it changes to

=(B8*B12+C8*C12+D8*D12+E8*E12+F8*F12+G8*G12)
=(B9*B13+C9*C13+D9*D13+E9*E13+F9*F13+G9*G13)
=(B10*B14+C10*C14+D10*D14+E10*E14+F10*F14+G10*G14)

Is there a way to carry this on?

Thanks

Jess

Try:

=(B$7*B8+C$7*C8+D$7*D8+E$7*E8+F$7*F8+G$7*G8)

and copy down?

Perfect


Thank you