Is there a shorten way to increase the value
 

Hi Everyone,

1 had a file with a lot of number thru out the cell and now I wish to
increase the value to another 20% on the below table. Is there a way I
highlight it an just x 120%

A B C D E F G
1 1 9 2 2 6 5 6
2 3 5 4 6 2 21 24
3 5 21 56 4 14 6 24
4 7 2 69 59 9 4 86
5 9 9 7 2 5 88 35
6 10 4 8 5 2 2 7
7 45 5 1 9 10 6 59
8 19 3 5 58 6 7 1
9 20 8 6 6 97 2 4
10 5 8 2 2 69 39 7

Is there a shorten way to increase the value
 

--Enter 1.2 in a cell and Copy the cell
--Keeping the copy Select your data
--Right clickPasteSpecialMultiplyOK


If this post helps click Yes
---------------
Jacob Skaria


"Sky" wrote:

Hi Everyone,

1 had a file with a lot of number thru out the cell and now I wish to
increase the value to another 20% on the below table. Is there a way I
highlight it an just x 120%

A B C D E F G
1 1 9 2 2 6 5 6
2 3 5 4 6 2 21 24
3 5 21 56 4 14 6 24
4 7 2 69 59 9 4 86
5 9 9 7 2 5 88 35
6 10 4 8 5 2 2 7
7 45 5 1 9 10 6 59
8 19 3 5 58 6 7 1
9 20 8 6 6 97 2 4
10 5 8 2 2 69 39 7