Just put a $ in front of the Row/Column reference to "freeze" it..

e.g D$11 will "freeze" the 11 and $D$11 will "freeze" the column D and the row 11.