We often use **multiplication** in Excel. For that, there are a lot of methods. In this article, I’ll show 4 easy methods to **multiply** a column by a number in excel . Just go through the steps and have a sharp look at the screenshots.

**Table of Contents**hide

**Download Practice Book**

Download the Excel workbook that we’ve used to prepare this article.

## 4 Easy Methods to Multiply a Column by a Number in Excel

**Method 1: Apply Manual Method to Multiply a Column by a Number in Excel**

Let’s get introduced to the dataset first. In the following table, I have used **5 columns** and **11 rows** to present some salesperson’s targets for four consecutive years.

**Step 1: **Here I want to fill **Column F** by multiplying **Column E** with the value **3**.

➤ Activate the **cell ** **F5 **then press **=**

➤ Select **cell ** **E5 **and type ***3** then hit the **Enter **button.

**Step 2: **

➤ After that, copy the formula for every cell of that column by double-pressing the right bottom corner of that cell.

**Read More:** **How to Multiply One Cell by Multiple Cells in Excel (4 Ways)**

**Method 2: Using Cell References in Excel to Multiply a Column By a Number**

In this method, I’ll use cell references to multiply a column in an excel sheet. I want to multiply **Column E** with the **Cell G5 **which has the value **3**. Let’s see.

**Step 1: **

➤ Activate the **Cell F5 **and type **=**

➤ Select the **Cell E5**

➤ Type *** **and select the **Cell G5**

➤ Press the **F4 **key to lock the reference **G5. **Because we don’t want to change the value.

➤ Hit the **Enter **button**, **you will get the consequence.

**Step 2:**

➤ Now copy the formula for every cell of that column by double-pressing the Plus (**+**) symbol at the right bottom corner (**Fill Handle**) of that cell or by dragging the mouse with **left-click.**

**Read More:** **How to Multiply Columns in Excel (9 Useful and Easy Ways)**

**Similar Readings**

**How to Multiply from Different Sheets in Excel (5 Methods)****If Cell Contains Value Then Multiply Using Excel Formula (3 Examples)****How to Multiply Multiple Cells in Excel (4 Methods)****Round a Multiplication Formula in Excel (5 Easy Methods)**

**Method 3: Use Paste Special Method to Multiply a Column by a Number in Excel**

According to the Paste Special method, I’ll multiply **Column E** with the number **3**. Follow the steps below.

**Step 1:**

➤ Select **Cell G5 **where the number **3 **is located.

➤ Press **Ctrl+C**

**Step 2:**

➤ Now select the values of **Column E **and right-click your mouse. The options will appear in the **Context Menu**.

➤ Press the **Paste Special** option. A **dialog box** will open up.

**Step 3:**

➤ From the box, mark the **Multiply **option.

➤ Press **OK**

Now see that the full column has been multiplied by the number **3**.

**Read More:** **What is the Formula for Multiplication in Excel for Multiple Cells? (3 Ways)**

**Method 4: Apply Product Function in Excel to Multiply a Column by a Number**

Applying functions is always interesting in Excel. In this method, I’ll do the operation with **the PRODUCT function.** I want to apply the function in **Cell F5. **I have put number **3 **in the **H5 Cell **which will be used to multiply the data of **Column E**.

**Step 1:**

➤ In** Cell F5**, type:

`=PRODUCT(E5,$H$5)`

Now push the **Enter **button and get the result.

After that, copy the formula for every cell of that column by double-pressing the Plus (**+**) symbol at the right bottom corner (**Fill Handle**) of that cell or by dragging the mouse with **left-click.**

**Read More:** **How to Multiply a Column in Excel by a Constant (4 Easy Ways)**

**Conclusion**

I hope all of the methods described above will be effective to multiply a column by a number in excel. Feel free to ask any questions in the comment section and please give me feedback.