I hope I understand your question correctly. If so, have you attempted writing your formulas using the "$" symbol to "lock" the column and/or row reference. If not, it is as simple as this:
To lock the column reference only you would rewrite A1 as $A1.
Now you can drag a...