Simple if you know how.

I have a column with a list of all prices (wholesale).

This column needs to add a set amount to all prices.

EG,

Prices A Prices + 5 B

6 =A1+5
8 =A2+5
11 =A3+5 and so on....
17
4
etc etc

Now I know we can use the absolute and relative referencing to just drag B1,s box down to fill all the column in but the problem is in Office excel 2007 when I do this I am just getting the same value all the way down the column that is in B1.

Anyone know what I need to change so the values are all relative to the corresponding value in the A column.

Hope that makes sense.

Thanks.