Increase numbers by 15% in multiple cells
 

If I have an excel worksheet with numbers in multiple cells and I want to
increase every number by 15%, how do I do that across the worksheet rather
than go into each cell individually? Any advice would be much appreciated.

Increase numbers by 15% in multiple cells
 

enter 115% in a free cell
copy that cell
select all the cells to multiply by
goto menu EditPasteSpecial
select Multiply
OK
clear the cell with 115% in it

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mrudnet" wrote in message
...
If I have an excel worksheet with numbers in multiple cells and I want to
increase every number by 15%, how do I do that across the worksheet rather
than go into each cell individually? Any advice would be much
appreciated.

Increase numbers by 15% in multiple cells
 

One way:

Enter 1.15 in an empty cell. Copy the cell. Select the cells to increase
the value. Choose Edit/Paste Special, selecting the Values and Multiply
radio buttons.

In article ,
mrudnet wrote:

If I have an excel worksheet with numbers in multiple cells and I want to
increase every number by 15%, how do I do that across the worksheet rather
than go into each cell individually? Any advice would be much appreciated.

Increase numbers by 15% in multiple cells
 

Place 1.15 into any empty cell. Copy that cell. Select the cells you want to
increase and then Paste Special - Choose Multiply...
--
HTH...

Jim Thomlinson


"mrudnet" wrote:

If I have an excel worksheet with numbers in multiple cells and I want to
increase every number by 15%, how do I do that across the worksheet rather
than go into each cell individually? Any advice would be much appreciated.

Increase numbers by 15% in multiple cells (Thank you - it worked)
 

Thank you to all who replied. It worked.

"mrudnet" wrote:

If I have an excel worksheet with numbers in multiple cells and I want to
increase every number by 15%, how do I do that across the worksheet rather
than go into each cell individually? Any advice would be much appreciated.