Search Contextures Sites

Increase Excel Values 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. In a blank cell, enter the amount of the increase. In this example, 1.50 was entered in cell D2 Copy the cell which contains the increase amount. Select the cells which contain the amounts that you want to increase. Here, cells B2:B5 are selected. On the menu bar, click Edit | Paste Special Click Values, and click Add, then click OK. 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. In a blank cell, enter the amount of the increase. In this example, 1.05 was entered in cell D8 Copy the cell which contains the increase amount. Select the cells which contain the amounts that you want to increase. Here, cells B8:B11 are selected. On the menu bar, click Edit | Paste Special Click Values, and click Multiply, then click OK. 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 Excel Data Entry Videos

Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact
Privacy Policy		Contextures Inc., Copyright ©2010 All rights reserved.	Debra Dalgleish

Last updated: August 21, 2010 3:55 PM