Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Use Paste Special to Multiply Numbers in Excel

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.


Download Practice Workbook

You can download the practice workbook from here.


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

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.
  • Then, select the data range whose value we want to multiply and right-click.
  • Afterward, choose Paste Special from the context menu.

  • Now, a Paste Special window will appear.
  • Select Values from the Paste field and Multiply them from the Operation field.
  • Finally, 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 to 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

  • Firstly, select and copy cell F7.
  • Next, select the range G5:G9 (whose values we want to multiply).
  • Then, right-click and choose Paste Special.

  • Consequently, the Paste Special window will pop up, select Values from the Paste field and Multiply from the Operation field.
  • Now, 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

  • First, select and copy the range of data D5:D9 from the Multiplication Value column.
  • After that, 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 and Multiply from the Operation field.
  • Finally, press 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

  • First, select and copy the cell range D5:D9 (Multiplication Value).
  • Then, select cell range E5:E9 and right-click.
  • Afterward, select Paste Special from the options.

  • Consequently, the Paste Special window will appear, select Values from the Paste field and Multiply from the Operation field.
  • Finally, press OK.

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


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 Method1. Let’s follow the steps given below for the procedures.

Keyboard Shortcut to Apply Paste Special for Multiplication

  • First, select and copy cell D7 which contains the Multiplication Value.
  • Next, 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, select Values from Paste.
  • Finally, press OK.

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


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.

  • First, select and copy cell D7 which contains the Division Value.
  • Then, 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 and Divide from the Operation field.
  • Afterward, press OK.

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


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. If you have any queries about the article, please leave a comment below. Please, visit our ExcelDemy site for similar articles regarding Excel.

Mehedi Hasan Shimul

Mehedi Hasan Shimul

Hi! I am Mehedi Hasan Shimul. As I am an Engineer solving different problems with the help of Excel amuses me. I write Excel related different problem solving articles here. Hope it will help you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo