Hi Rory,
HTH
Use a helper cell and enter £20. Copy the helper and paste specialadd into
the cells you want to increase.
ray

"Rory" wrote:

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.