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

 

GET YOUR PDF DOWNLOADABLE EXCEL BOOK:

hmb_logo_01Lg

 

6

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin