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:

=C5*D5

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:

=D5*C5

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

We have successfully multiplied columns in Excel.

2.2 Utilize Array Formula

Steps:

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

=C5:C13*D5:D13

Press Ctrl+Shift+Enter to get the result.

The columns will be multiplied as we expected.

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:

=C5*C6

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:

=C5:F5*C6:F6

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

The output will be in our hands, multiplying rows.

4. Multiply with a Fixed Number

Steps:

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

=C7*$C$4

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

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:

=C5*D5

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:

=PRODUCT(C7,D7,2)

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

Method 7 – Perform the SUMPRODUCT Function to Multiply in Excel

Steps:

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

=SUMPRODUCT(C5:C13,D5:D13)

Press Enter.

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.

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.

How to Multiply in Excel (8 Methods)

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