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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Free Excel Templates If you want ready made custom Excel templates then you do not have to pay for them as they are FREE inside your Excel workbook!To activate this you need to go to File > New and choose from a variety of categories, such as:Budgets, Planners, Lists, Invoices, Calendars, ...
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...
Running Total In % with an Excel Pivot Table A Running Total In is the accumulation of values over a certain period, like days, month or years.  It is sometimes referred to as the Year to Date analysis.A Running Total In takes one period's values, then adds a second period, then a third period...and so on, to give the a...
Rank Smallest to Largest 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 RANK SMALLEST TO LARGEST calculation.This option will immediately calculate the rankings (1 being the smallest value) for your values, allowin...