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:
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
GET YOUR PDF DOWNLOADABLE EXCEL BOOK: