Thank You. I am trying to change all rows in column N. How do I do it?
"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