Increasing everything by 30%

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet with a bunch of numbers in the table.
I want to increase all the numbers across the board by 30%.
Is there a shortcut to changing all of them simultaneously or
do I have to manually enter each one in?

Thanks in advance,
Stephanie Myers
 
Hi

Enter 1.3 into free cell and copy the cell.
Select the range with your data, and then PasteSpecial.Multiply - all
numbers in selected ranged are multiplied with 1.3

Arvi Laanemets
 
Hi
- enter 1.3 in an empty cell
- copy this cell
- select your data
- goto 'Edit - Paste Special' and choose 'Multiply'


--
Regards
Frank Kabel
Frankfurt, Germany

im Newsbeitrag
news:[email protected]...
 
Thanks much - I am impressed with how expedient people are with responses.

Have a great day everyone!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

increase an entire spreadsheet by a percentage 2
How to increase all prices in price sheet by certain percent? 6
Increasing by a percent 1
Increasing all values in spreadsheet by same percentage. 1
How to increase a number by 1 every time the spreadsheet opens? 1
How do I increase a $ by a % to a current amount in a cell? 4
increase existing cells 3
Increase numbers by 15% in multiple cells 4

Back
Top