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:


DOWNLOAD EXCEL WORKBOOK

STEP 1: Enter the amount to multiply by (the multiplier) in an empty cell, e.g. 1.10

STEP 2: Copy that cell

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

 

STEP 4: Select Values & Multiply and press OK

paste special values

Your values have now been multiplied by the multiplier!

 

 

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