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