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.

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.

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.

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.

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.