Excel 2007 : Is there an easy way of copy/pasting formulas

HI, i need help please!! i am making a rollbook for my classes... the thing is that for each of my students i am using this 3 formulas:
A
=N1SR!M14
=IF(J10="","",(J10/J4))
=IF(J11="","",(RANK(J11,$F$11:$R$11)))

in column B
=N2SR!M14
=IF(K10="","",(K10/K4))
=IF(K11="","",(RANK(K11,$F$11:$R$11)))

and so on until i fill 35 students and 12 columns, my problem is that if i copy/paste either goign down or trying to the cell to the right the references changes and either way i end up fixing the reference by hand. I have 5 clases each with 35 students so i am getting tired of going one by one do you know if there is an easy way to do it?

By using $. If you copy a formula in a1 that refers to b1 and paste it in a2 it will refer to b2 but if you use $B$1 it will stay b1.

In A1 =B1*C1 would result
In A2 =B2*C2

In A1 =$B$1*C1 would result
In A2 =$B$1*C2

In A1 =B1*$C$1 woul result
In A2 =B2*$C$1

your second and third formula work fine if copied across. for the first one, you can put the sheet name in a cell and refer to it in an INDIRECT formula.