So I'm really just a novice creating a gradebook from scratch. I'm editing my gradebook (create in Excel 03) in my new Excel 07. I used to be able to copy and paste one formula down the rows, and the numbers would adjust, but now I can't. And I know there is a simpler way than changing E21 to E22 to E23, etc. This is my formula:

=$B$51*B78+$C$51*C78+$D$51*D78+$E$51*E78 (it continues on until Q, but you get the idea).

In old Excel I was able to copy the formula straight down the column, and $B$51 would change to $C$52 to $D$51 ... even when I got rid of the $, the formula wouldn't change per row.

I don't even know if I am adequately explaining myself

... I really don't know how to do any of this stuff ..

What am I doing wrong?