Tech Tip: Excel – How To Reduce All Numbers In A Spreadsheet By A Percentage

By |2016-10-16T15:56:37+00:00August 5th, 2013|Categories: Tech Tips|Tags: , , , , , |2 Comments
Share This Article:

tip-of-the-dayIf you’re an Excel user, you’ve probably run across some formulas that offer you different ways to reach the same end result. I recently had to take a price sheet and reduce all prices by 2%. I know there’s a few ways you can go about it, and in the past, I would have used a formula to do it.

For me, a better way was to use Paste Special. This way, when I go to edit the price sheet next year, it won’t be full of formulas that I’ll have to tweak.

So, for my example, to reduce a number by a percentage, take your percentage and subtract it from 100, then add a decimal in front of it. In my example, 100-2 is 98, so I’m going to be using .98 on my spreadsheet.

Note: If you want to increase by a percentage, do 1.xx, where the xx is your percentage. For example, if you wanted to do a 2% increase, you would use 1.02.

Now, somewhere in an empty cell, put your number in it (.98 in my example).

Now copy that cell (Control + C).

Now highlight all of the numbers you want to change by this percentage.

Go under your Paste menu and choose Paste Special. Choose Value and choose Multiply. After this, all of your values should be changed by your percentage.


Share This Article:

 

Related Content

2 Comments

  1. Robert Russell (@mindfrost82) August 5, 2013 at 3:55 pm - Reply

    RT @RBRussell_com: Tech Tip: Excel – How To Reduce All Numbers In A Spreadsheet By A Percentage http://t.co/DoE1HGkzGM

  2. Matt C. January 22, 2019 at 5:03 pm - Reply

    Hi Robert,
    I cannot tell you how helpful this tip is!!! It literally is going to save me hours of time as I have a huge price-list that needs to be changed. Thanks for putting it out there.
    Matt

Leave a Comment