How to Multiply in Excel (8 Methods)

We have a dataset of product Names, unit prices, and Quantities. We will learn to multiply this information from the dataset to calculate the Total Price.

Method 1 – Use the Asterisk Sign to Multiply Cells in Excel

Steps:

• Select a cell (E5) and enter the following formula:

• Press Enter to get the output.
• Drag the “fill handle” down to fill all the cells.

• We get our multiplied output in a new column.

Method 2 – Multiply the Entire Column in Excel

2.1 Use the Fill Handle

Steps:

• Choose a cell (E5) and enter the formula:

• Press the Enter button to get the result.
• Pull the “fill handle” down to multiple columns.

• We have successfully multiplied columns in Excel.

Read More: How to Multiply a Column by a Number in Excel

2.2 Utilize Array Formula

Steps:

• Select a cell (E5) and enter the following formula:

• Press Ctrl+Shift+Enter to get the result.

• The columns will be multiplied as we expected.

Read More: How to Multiply Two Columns in Excel

Method 3 – Multiply Rows in Excel

We have a dataset of some Product names, Unit Prices, Quantity, and Total Prices arranged row-wise. We will Multiply these rows with some easy tricks.

3.1 Use the Fill Handle

Steps:

• Choose a cell (C7) and apply the following formula:

• Click Enter and drag the “fill handle”.

• You will get the output by multiplying numbers row-wise.

3.2 Utilize the Array Formula

Steps:

• Choose a cell (C7) and enter the following formula:

• Click Ctrl+Shift+Enter to get the desired result.

• The output will be in our hands, multiplying rows.

Read More: How to Round a Multiplication Formula in Excel

4. Multiply with a Fixed Number

Steps:

• Select a cell (D7) and enter the following formula:

• Press  Enter and drag the “fill handle”.
• You will get all the numbers multiplied by the fixed numeric value.

Read More: If Cell Contains Value Then Multiply Using Excel Formula

Method 5 – Multiply Percentages in Excel

We have a dataset of some Product Names, Product Prices, and VAT. We will calculate the Total VAT amount by multiplying.

Steps:

• Choose a cell (E5) and enter the following formula:

• Press Enter and drag down the “fill handle” to fill all the cells.

Read More: Multiplication Formula in Excel

Method 6 – Apply the PRODUCT Function to Multiply

Steps:

• Choose a cell (E7) and enter the following formula:

• Click the Enter button and pull the “fill handle” to get your output.

Read More: How to Multiply a Column in Excel by a Constant

Method 7 – Perform the SUMPRODUCT Function to Multiply in Excel

Steps:

• Choose a cell (C15) and enter the following formula:

• Press Enter.

Read More: How to Multiply Two Columns and Then Sum in Excel

Method 8 – Apply Paste Special to Multiply Without Formula

We have a dataset of some Width and Fixed Length. Utilizing the paste special feature, we will determine the Total Area by multiplying.

Steps:

• Select cells (B7:B13), and holding the Ctrl key, press the C button.

• Paste the value into a new column by pressing Ctrl+V.

• Choose the value by which you want to multiply.
• Click the right button and select “Copy” from the appearing options.

• Select cells (C7:C13).
• Click the right button and choose “Paste Special”.

• From the new dialog box, check the “Multiply” option and press OK.

• Your final multiplied result is below.

Read More: What is the Formula for Multiplication in Excel for Multiple Cells?

Use Keyboard Shortcut to Multiply in Excel

We have a dataset of some Width and Fixed Length. We will multiply using shortcuts.

Steps:

• Select a cell (C4) with which you want to multiply.
• Press Ctrl+C to copy.

• Select cells (B7:B13), and press Alt+E+S+V+M.
• Press OK.

• We have multiplied numbers using quick shortcuts in excel.

Read More: How to Use Multiply Sign in Excel

Things to Remember

• While multiplying with a fixed number, don’t forget to use an absolute reference ($) for the number. By putting absolute reference, the numeric value stays the same.

Download the Practice Workbook

Download this workbook to practice.

Related Articles

<< Go Back to How to Calculate in Excel | Learn Excel