For example in row 1 the amount is $10.00 and I want to increase it by 5% to
$10.50, and row 2 the amount is $15.00 I want to increase by 5% to $15.75,
and row 3 the amount is $20.00 and I want to increase by 5% to $21.00, etc.
"Bernard Liengme" wrote in message
...
If you want another column with the new values:
Suppose first old value is in A1, then in B1 enter =A1*1.05
Drag this down the column

If you want to alter the original data
In an unused cell type 1.05 ( or =1+ 5% and do not worry if this displays
as 105.00%)
Copy this cell
Select the column of data
Use Edit | Paste Special with Multiply specified
Now you can delete the 1.05

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"S1L1Y1" wrote in message
...
I have Office XP. In Excel I want to increase the price in the whole
column
by lets say 5% how do I do it?
Sol