Forum Discussion

Copper Contributor

Jan 13, 2023

Solved

Increasing prices on excel spreadsheet

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 pri...

excel

Templeprint
Jan 24, 2023
Perfect
Thank you Paul

Paul_Aberdeen

Copper Contributor

Jan 13, 2023

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%

Templeprint
Copper Contributor
Jan 13, 2023
Hi Paul
I have tried that but cannot see the check multiply box so it does not work
Any more suggestions?
- Paul_Aberdeen
  Copper Contributor
  Jan 13, 2023
  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
  - Templeprint
    Copper Contributor
    Jan 24, 2023
    Perfect
    Thank you Paul