Paste Special has a few different Paste features and operations that many users do not know about.

One of them is the Paste Special > Values > Multiply combination.

What that does is multiply a range of selected cells by a value, called the multiplier.  So if you want to increase all your values by 10%, you can….see how below:

Excel Paste Special: A Values Multiplier | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

STEP 1: Enter the amount to multiply by (the multiplier) in an empty cell, e.g. 1.10Excel Paste Special: A Values Multiplier | MyExcelOnline

STEP 2: Copy that cell

Excel Paste Special: A Values Multiplier | MyExcelOnline

STEP 3: Select the data range you want to multiply, Right Click and select Paste Special

Excel Paste Special: A Values Multiplier | MyExcelOnline

 

STEP 4: Select Values & Multiply and press OK

paste special values

Your values have now been multiplied by the multiplier!

Excel Paste Special: A Values Multiplier | MyExcelOnline

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn