View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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.