In MS Excel, you can multiply a list of values by 1.1 without inserting a formula

Question:     I would like to multiply a list of values by 1.1 without inserting a formula.  Can this be done in MS Excel?

Answer:        Yes, by using the Paste special function. 

Why:            To quickly increase values by 10% without inserting a formula. 

Applies To: Excel 2003, 2007, 2010

  1. For this example the screen shot below will be used

2.  To increase the selling price by 10% without inserting a formula; select E3 and copy the contents of the cell

3.  Select D3:D19  and right click over the selected data area

4.  Select Pastel Special. Then select as below

5.  The result will be as displayed below. The Selling price values have been increased by 10% without inserting formulas.

If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email [email protected] and yours could be the next Tip of the Week.



Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations