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

Paste Value Multiply

GET YOUR PDF DOWNLOADABLE EXCEL BOOK:

hmb_logo_01Lg

 

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

Share on Google+

Google+

Related Posts

How to Use Flash Fill In Excel   Flash Fill in Excel is a new feature that was introduced in Excel 2013. It is very handy as Excel predicts the rest of your inputs based on the first entry that you have placed. Once its prediction is correct and you confirm it, it will fill the rest of the rows lite...
Show The Percent Of With Excel Pivot Tables   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF calculation. It will display the value of one item (the Base Field) as the percentage of another item (the Base Item). This optio...
Extra Excel Table Styles The Excel Table Styles give a user a choice of different styles ranging from Light, Medium and Dark. There are over 50 choices depending on your favorite style or company standard but you are not only limited to those. You have extra Table styles in the Page Layout tab in y...
Remove Duplicates in an Excel Table When you have duplicates values within your Excel Table there is a quick and easy way to remove those values. The duplicate values could be all over your Excel Table and sometimes it takes valuable time trying to locate those duplicates and then deleting them. Not to worry,...