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

Excel Paste Special: A Values Multiplier | MyExcelOnline