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

Add Custom Symbols With Your Numbers in Excel A cool feature within Excel is the ability to format a cell's value by pressing CTRL + 1 on any cell. This brings up the Format Cells dialogue box and under the Custom category you can customize the Type to whatever you like and even insert symbols! There are four formattin...
Drop Down Menu In Your Excel Table Apart from creating a simple Drop Down Menu/List or Data Validation List, you can expand this concept to include it in your Excel Table or Database. Watch how to insert a Data Validation List That way you don't have to do repetitive tasks like entering the same customer ov...
Filter Unique Records The Advanced Filter allows you to filter unique records and copy them to another location outside the data set.  This is useful when you want to use a filtered list for further analysis. This can also be achieved by using a Pivot Table.  Placing a Field in the Row Labels will ...
Show The Percent of Row Total With Excel Pivot Tab... 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 ROW TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers such as sales data, exp...