Contextures - Microsoft Excel Tips and Tutorials

Search Contextures Sites

• Home
• Excel Tips
• Excel Files
• Products
• Blog
• Contact
• RSS

Contextures Excel news by email Email: Name (optional): We respect your email privacy	Change Values With Paste Special Video: Divide Numbers with Paste Special Divide Numbers with Paste Special Video: Increase Numbers with Paste Special Add the Same Amount to Selected Numbers Increase Selected Numbers by a Percentage Video: Increase Numbers with Paste Special in Excel 2003 Without using formulas, you can add, subtract, multiply or divide all the numbers in a range by a specific amount. For example, in a price list, all the prices could be increased by $1.50, or the prices could be decreased by 5%. This makes it easy to increase the prices on the worksheet, all at once, by using the Paste Special command on the Excel Ribbon. Just type a value into a cell, then copy that cell, and apply its value to other cells. Thanks to T. Valko for suggesting this page! Video: Divide Numbers With Paste Special Watch this short video to see the steps for dividing numbers with the Paste Special command. Written instructions are below the video. Divide Numbers With Paste Special Without using formulas, you can quickly divide a set of numbers, by using the Paste Special command. In this example, numbers are divided by 1000, and the result is a permanent change to the numbers. In a blank cell, enter the amount by which you want to divide. In this example, 1000 was entered in cell F3 Copy the cell which contains the division amount. Select the cells which contain the amounts that you want to divide. In the screen shot below, cells C2:C11 are selected. On the Ribbon's Home tab, click the arrow on the Paste button, then click Paste Special In the Options section, click Divide, then click OK. Each of the selected numbers is automatically divided by 1000. To complete the change, you can format the numbers, if necessary, and delete the amount typed in cell F3. Video: Increase Numbers With Paste Special Watch this short video to see the steps for adding or multiplying with Paste Special. Written instructions are below the video. For Excel 2003 instructions, please watch this video. 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 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% Video: Increase Numbers With Paste Special in Excel 2003 Watch this short video to see the steps for adding or multiplying with Paste Special in Excel 2003. More Data Entry Tutorials 1. Data Entry Tips 2. Fill Blank Cells 3. Convert Text to Numbers 4. Increase Numbers With Paste Special

Home Excel Tips Excel Files Products Blog Contact
Privacy Policy		Contextures Inc., Copyright ©2013 All rights reserved.	Debra Dalgleish

Last updated: June 9, 2013 7:59 PM