Excel Productivity Guide

Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.

How To Multiply In Excel Using Paste Special

    how to multiply using paste special in excelSometimes, you have to perform some quick calculations in excel.

    And, you can use paste special for these quick calculations instead of formulas.

    In this post, you will learn a quick tip for these calculations.

    I will show you how can you use paste special to quickly multiply in excel. Not only multiple but subtract, divided, and minus as well.

    In paste special, we have four different options [Add, Subtract, Multiply, and Divide] which you can use for your quick calculations.

    Multiply In Excel Using Paste Special Option

    Table of Content

    1. Multiply With Paste Special
    2. If You Have Formulas In Cell
    3. Dynamic Calculations

    Multiply In Excel Using Paste Special Option

    Let’s say, you have a data table with call tariff rates from India to other countries.

    Due to some hike in costing you have to increase your tariff rates by 20%. Rather than using excel functions

    Now, rather than using excel functions you can use paste special to multiply.

    Follow these simple steps.

    • Select the cell in which you have your %age of increment(I have used 1.2 for increasing the tariff by 20%) and copy it.
    • Now, select the entire range on which you want to apply the calculation.
    • Use shortcut key [Alt + E + S] to get the paste special dialog box.
    • Go to Operation, select the “multiply” option, click okay.

    In below example, I have used an increased rate of multiplication.
    Multiply In Excel Using Paste Special Option in Cells

    Using the same method you can divide, subtraction and addition.

    And, When You Have Cells With Formulas

    Now, this is one of the most amazing things you can do with paste special.

    If you have some cell where you already have formulas, you can still use paste special.

    Multiply In Excel Using Paste Special Option with formulas

    In above example, the price is the sum of fixed cost (E2) & variable cost (E3). I have increased the price by 32.25%.

    Paste Special for Dynamic Calculations

    One more useful thing you can do with paste-special is, you can perform a dynamic calculation.

    Use-Paste-Special-Operations-for-a-Quick-Multiply-in-Excel-5

    Let’s say, you have a data set of five products for different zones and you have to calculate an incremental price for all the five products using different incremental rate.

    Just select the all the cells having incremental rates and follow the same steps which we have used above.

    Shortcuts

    • Multiply –  Alt + V + H + M
    • Divide –  Alt + V + H + I
    • Add –  Alt + V + H + D
    • Subtract –  Alt + V + H + S

    Conclusion

    Using paste special for multiplication and for other small calculations is a time saver. There is no need to write formulae for these.

    It’s quick, simple, and easy.

    Now tell me one thing. Have you ever tried this before? Share with me in the comment box.

    More Quick Tips



    • Ankur Shukla

      Thanks Puneet for sharing the valuable info… 🙂 keep it good work and share it around the world 🙂

      • Puneet Gogia

        Thanks Ankur

    • ratanak

      Thanks for sharing such informative tricks.keep sharing

      • Puneet Gogia

        Thanks Ratanak

    • Pingback: How to Sort Data from Left to Right in Excel - Quick Tip()

    • Patty Ball

      silly question/comment, but isn’t 20% .2 and not 1.2? What am I missing? Other than that, thanks for the info

      • Puneet Gogia

        No Patty, it isn’t.

        Let me tell you.

        If you want to increase value by 20% then you have to raise current value to 120%. Like, for 10, 2 is 20% but the final value will be 12 (100%+20%).

        That’s why 1.2 or 120% you can say.

        Good day.