How to increase or decrease values in excel without using formulas

Let's say you have to increase all the values in a worksheet to 10%. You can of course use a formula and multiply the value by 1.10. There is an alternate way, however, that you might like to use.
This will be useful specially when you need the new values without the formula. Use the excel paste special function. Yes, you've read it right,the paste special function!

Here's how to us this tool. First input the value in a cell, in this case the value 1.10. Copy this cell, then select all cells which contains the value to be changed and then right click. Choose paste special.

A dialog box will come up. Choose "multiply".

Click "OK". Now you're done! All your values are now 10% higher. All values are multiplied by 1.10. 

This can also be used to add, subtract, and divide the values by clicking the appropriate option buttons.

Happy computing!

Tweet