How to Use Paste Special to Multiply Numbers in Excel

Get FREE Advanced Excel Exercises with Solutions!

Multiplication of a number is a quite frequently used operation in Excel. We can multiply that from a range of cells by a specific number in various ways. We can use the Paste Special option of Excel to multiply a range of cells by one or multiple numbers. In this article, I will discuss the use of Paste Special to multiply numbers in Excel.


How to Use Paste Special to Multiply Numbers in Excel: 5 Simple Methods

We can use the Paste Special option of Excel in various ways to multiply a range of cells by one or more numbers. Here, I will discuss 5 simple methods to show the use of Paste Special to multiply numbers in Excel.

1. Use Paste Special to Multiply with a Number

We can use the Paste Special option to multiply the values of a range of cells by a specific number. For demonstration purposes, I have included the Product, Initial Price, Multiplication value, and Updated Price of some commodities. I will show the stepwise procedure to multiply the values of the Updated Price by the Multiplication Value.

excel paste special multiply

  • First, copy the cell D7 which contains the number to multiply. You can copy the cell by pressing Ctrl + C or right-clicking.
  • Select the data range whose value we want to multiply and right-click >> Choose Paste Special from the context menu.

Now, a Paste Special window will appear.

  • Select Values from the Paste field >> click Multiply from the Operation field >> Press OK.

Bravo! We have successfully multiplied the Updated Price by the Multiplication Value.


2. Apply Paste Special to a Formula for Multiplication

We can also use Paste Special to multiply a number by a formula in Excel. For demonstration, I have used a dataset that includes the product, Initial Price, Tax, Added Price, Multiplication Value and Updated Price. The Updated Price cells contain a formula to add data from the column Initial Price and Tax. We will multiply this column’s data with a Multiplication Value. Let’s follow the steps given below.

Apply Paste Special to a Formula for Multiplication

  • Select and copy cell F7 >> Select the range G5:G9 (whose values we want to multiply) >> Right-click and choose Paste Special.

Consequently, the Paste Special window will pop up.

  • Select Values from the Paste field >> Multiply from the Operation field >> Press OK.

Instantly, we will see the values (which are the results of a formula) of the Updated Price multiplied by the Multiplication Value.

 excel paste special multiply result


3. Insert Paste Special to Multiply by Different Numbers

Instead of multiplying the whole range with one number, we can multiply each cell value with different numbers. The dataset I used for demonstration is similar to Method 1, except it has several multiplication values. I am showing below the stepwise procedures.

Insert Paste Special to Multiply by Different Numbers

  • Select and copy the range of data D5:D9 from the Multiplication Value column >> Select data range E5:E9 which has the Updated Price.
  • Now, right-click and choose Paste Special from the options.

Consequently, the Paste Special window will appear.

  • Select Values from the Paste field >> Multiply from the Operation field >> Hit OK.

Yahoo! We have successfully multiplied the values from Updated Price with multiple values from Multiplication Value.

 excel paste special multiply result


4. Multiply Every Nth Number Using Paste Special

Instead of multiplying the whole range of numbers, we can multiply some of the data and keep others unchanged. The dataset is similar to Method 3, except it has 1 and 1.2 alternatively in the Multiplication Value. I am showing the steps for these procedures below.

Multiply Every Nth Number Using Paste Special

  • Copy the cell range D5:D9 (Multiplication Value) >> Select cell range E5:E9 and right-click >> Click on Paste Special from the options.

Consequently, the Paste Special window will appear.

  • Select Values from the Paste field and Multiply from the Operation field >> Tap OK.

Hurrah! We can see the multiplication done by using Paste Special.

Read More: PasteSpecial Method of Worksheet Class Failed


5. Keyboard Shortcut to Apply Paste Special for Multiplication

We can apply the Paste Special method by using the keyboard shortcut. The dataset is similar to Method 1. Let’s follow the steps given below for the procedures.

Keyboard Shortcut to Apply Paste Special for Multiplication

  • Copy cell D7 which contains the Multiplication Value >> Select the range of cells E5:E9 which contains the Updated Price.
  • Now, press the keyboard shortcut Alt + E + S + M.

 excel paste special multiply shortcut key

Consequently, the Paste Special window will appear.

  • Click Values from Paste >> Hit OK.

  • We will see the Updated Price multiplied by the Multiplication Value.

Read More: Difference Between Paste and Paste Special in Excel


How to Use Paste Special to Divide Number in Excel

We can also use the Paste Special option to divide numbers by a specific value. The procedure is similar to multiplication with a slight change. I have included the Product, Initial Price, Division Value, and updated Price. We will divide the Updated Price by Division Value. Let’s follow the steps given below for the procedures.

  • Select and copy cell D7 which contains the Division Value >> Select cell range E5:E9 and right-click.
  • After that, choose Paste Special from the options.

How to Use Paste Special to Divide Number in Excel

Consequently, a Paste Special window will pop up.

  • Select Values from the Paste field >> Divide from the Operation field >> Press OK.

Finally, we will see the Updated Price is divided by the Division Value.


Download Practice Workbook

You can download the practice workbook from here.


Conclusion

Paste Special is a great tool to multiply a number by a range of cells. In this article, I have shown 5 simple methods to use Paste Special to multiply numbers in Excel. If you have any queries about the article, please leave a comment below.


Related Articles


<< Go Back to Paste Special | Paste | Copy Paste in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mehedi Hasan Shimul
Mehedi Hasan Shimul

Md. Mehedi Hasan, with a BSc in Electrical & Electronic Engineering from Bangladesh University of Engineering and Technology, holds a crucial position as an Excel & VBA Content Developer at ExcelDemy. Driven by a deep passion for research and innovation, he actively immerses himself in Excel. In his role, Mehedi not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently deliver exceptional and quality content.... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo