Lets say I have a table with 4 columns - desc, price, qty, total

In the first row I put a formula in the 4th column to multiply the price and
the qty - so far so good.

Now how do I copy that formula to every row?

If I cut and paste then it retains the reference to price and qty in the
first row instead of the same row as the formula (as excel would do). This
means I have to manually enter a formula for every single row - is there any
way around this?