Increasing prices on excel spreadsheet

[Templeprint]

Hi

I am new to excel. I have produced a spreadsheet with pricing tables on but now I want to increase all the prices by 10%. Is there a simple way to do this by just highlighting the colums with prices in and doing a formula?

[#2]

Hi The quickest and easiest is to enter 1.1 in an empty cell. Then select and copy that cell. Select/highlight all the prices that you wish to increase. Then right click, select paste special select value and check the multiply box. This process won't manage decimals to two places for example, but it will add 10%

[#3]

Hi Paul
I have tried that but cannot see the check multiply box so it does not work
Any more suggestions?

[#4]

Hi

So enter for example 1.1 in cell A1.  Ctl C A1.  Then select the range you want to update and go to paste special and select as below....

Cheers

Paul

[#5 · Accepted solution]

Perfect
Thank you Paul