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.
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.
➤ 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.
➤ 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.
➤ 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.
- 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.
➤ Select Cell G5 where the number 3 is located.
➤ Press Ctrl+C
➤ 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.
➤ 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.
➤ In Cell F5, type:
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.
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.