Increasing everything by 30%

  • Thread starter Stephanie Myers
  • Start date
S

Stephanie Myers

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
 
A

Arvi Laanemets

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
 
F

Frank Kabel

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]...
 
S

Stephanie Myers

Thanks much - I am impressed with how expedient people are with responses.

Have a great day everyone!
 
Top