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**.

**Table of Contents**hide

## 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**.

- 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.

- 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**.

### 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.

- 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**.

### 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.

- 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.

- 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**.

- 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.

- 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**.