Pinterest Pixel

Excel Paste Special: A Values Multiplier

Paste Special has a few different Paste features and operations that many users do not know about.... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

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:

Excel Paste Special: A Values Multiplier | MyExcelOnline
Download excel workbookPaste-Value-Miltiply.xlsx

STEP 1: Enter the amount to multiply by (the multiplier) in an empty cell, e.g. 1.10Excel Paste Special: A Values Multiplier

STEP 2: Copy that cell

Excel Paste Special: A Values Multiplier

STEP 3: Select the data range you want to multiply, Right Click and select Paste Special

Excel Paste Special: A Values Multiplier

 

STEP 4: Select Values & Multiply and press OK

Excel Paste Special: A Values Multiplier

Your values have now been multiplied by the multiplier!

Excel Paste Special: A Values Multiplier

 

 

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

See also  How to Use Flash Fill In Excel
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!