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.


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.

Apply Manual Method to Multiply a Column by a Number in Excel

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.

Apply Manual Method to Multiply a Column by a Number in Excel

Step 2: 

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

Apply Manual Method to Multiply a Column by a Number in Excel

Read more: How to Multiply in Excel: Columns, Cells, Rows, & Numbers


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.

Using Cell References in Excel to Multiply a Column By a Number

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.

Using Cell References in Excel to Multiply a Column By a Number


Similar Readings:


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

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

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.

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

Step 3:

➤ From the box, mark the Multiply option.

➤ Press OK

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

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

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


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)

Apply Product Function in Excel to Multiply a Column by a Number

Now push the Enter button and get the result.

Apply Product Function in Excel to Multiply a Column by a Number

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.

Apply Product Function in Excel to Multiply a Column by a Number


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

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

Leave a reply

ExcelDemy
Logo