For example; cells F9 - F20 are filled with prices and i would like to add
£20 to each cell price.
I would like to add £20 to cell F9 and then be able to drag down the coloumn
to F20 and the prices to update.
Can anyone please tell me how to do this.

Thanks
Rory.