Excel -- Data Entry -- Increase Numbers With Paste Special

Add the Same Amount to Selected Numbers
Increase Selected Numbers by a Percentage

View the steps described below, in a short video clip. Excel 2007 video

Thanks to T. Valko for suggesting this page!
   

Add the Same Amount to Selected Numbers

You may want to increase all the numbers in a range by a set amount. For example, in this price list, all the prices should be increased by $1.50. The following technique makes it easy to increase the prices, all at once.

  1. In a blank cell, enter the amount of the increase. In this example, 1.50 was entered in cell D2
  2. Copy the cell which contains the increase amount.
  3. Select the cells which contain the amounts that you want to increase. Here, cells B2:B5 are selected.
  4. On the menu bar, click Edit | Paste Special
  5. Click Values, and click Add, then click OK.
  6. Each of the selected numbers is automatically increased by $1.50

 

Watch the Video

View the steps described above, in a short video clip. Excel 2007 video

  

Increase Selected Numbers by a Percentage

You may want to increase all the numbers in a range by a set percentage. For example, in this price list, all the prices should be increased by 5%. The following technique makes it easy to increase the prices, all at once.

  1. In a blank cell, enter the amount of the increase. In this example, 1.05 was entered in cell D8
  2. Copy the cell which contains the increase amount.
  3. Select the cells which contain the amounts that you want to increase. Here, cells B8:B11 are selected.
  4. On the menu bar, click Edit | Paste Special
  5. Click Values, and click Multiply, then click OK.
  6. Each of the selected numbers is automatically increased by 5%

 

Watch the Video

View the steps described above, in a short video clip. Excel 2007 video

 

  

 

 

1. Data Entry -- Tips
2. Data Entry -- Fill Blank Cells
3. Data Entry -- Convert Text to Numbers
4. Data Entry -- Increase Numbers With Paste Special
 

       Home     Excel Tips     Excel Files      Blog    Contact

 

RSS Feed

 

 

 

The Excel Store

Last updated: July 5, 2008 10:44 PM