MS Excel 2003 Help - URGENT!!!

[blade]

I have a column with prices listed (from top to bottom)
I want to add $5.00 to the prices in that column, without having to do it individually
Is there a way I can add automatically add $5 to each price on that column

 

[donkey42]

the easiest way i know of doing it is:

use the next column, and add the formula (if items in column A, then enter formula's into column B)

A1:A200+$5

then just hide column A

or enter the amount to add in a separate cell then (say B2)

A1:A200+$B$2

the $ makes the link absoute (stays B2 instead of going down the B column) i think thats right, but i havent used excel since excel 97, so wait for more replies

 

[blade]

Sorry, I have no idea what your talking about; can you re-state that in a step by step process

 

[donkey42]

Sorry, I have no idea what your talking about; can you re-state that in a step by step process

right if your column of prices are i column A, enter this formula into column B

A1:A200+$C$2

then enter the amount you wish to add into column C ($5)

i think this will work, but as i said i'm well out of date in using excel, i last used excel when it was excel 97, and my memory is getting worse - it's an age thing

P.S. yes i altered formula - see, memory