View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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.