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?

=(A4*$A$2)

--

Regards,

Peo Sjoblom

"Boz" wrote in message
...
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?