copying formulas
What is the easiest way to copy formulas?
Basically I have a sheet that refers to set values per section which act as
a multiplier so I have a function that says '=(a4 * a2)' next one should be
'=(a5 * a2)' and so on. When I paste the formula in it goes to '=(a5 * a3)'.
Is there an easy way to remedy this situation?
|