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

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.

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

## Related Articles #### Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts 