How to Multiply Rows in Excel (4 Easy Ways)

Method 1 – Basic Ways to Multiply Rows in Excel

Multiply a Row by a Cell

• Select the appropriate cell (C6 in this example) and type the following formula.

• Press ENTER.
• Use the Fill Handle to Autofill the formula for the rest of the row.

Multiply a Row by Another Row

• Select the appropriate cell (C8) and type the following formula.

• Press ENTER.
• Use the Fill Handle to Autofill the formula for the rest of the row.

Read More: How to Create a Multiplication Formula in Excel 

Method 2 – Multiply Rows in ARRAY

Multiply a Row by a Cell

• Select the relevant cell range. (C5:E5 in this example).
• Enter the following formula.

• Press CTRL + SHIFT + ENTER.

Note: You will see a curly bracket in the formula bar as a result of multiplication in ARRAY.

Multiply A Row by Another Row

• Select the relevant cell range. (C8:E8).

• Enter the following formula.

• Press CTRL + SHIFT + ENTER.

Method 3 – Multiply Rows Using the PRODUCT Function

Multiply A Row by a Cell

• Select the relevant cell (C6) and type the following formula.

• Press ENTER.
• Use the Fill Handle to Autofill the formula for the rest of the row.

Multiply A Row by Another Row

• Select the relevant cell (C8) and type the following formula.

• Press ENTER.

• Use the Fill Handle to Autofill the formula for the rest of the row.

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

Method 4 – Multiply Rows Using Paste Special

Multiply a Row by a Cell

• Copy the values from the relevant cell range (C5:E5).
• Paste them to the destination range (C6:E6).

• Copy the cell with the multiplier (G7).

• Select the cell range that will contain the results (C6:E6).
• Right-click the mouse.
• A context menu will appear. Select Paste Special.

• The Paste Special window will appear. Select Multiply.
• Click OK.

The results should look like this.

Multiply a Row by Another Row

• Copy the relevant cells (C6:E6) and paste them into the destination cells (C8:E8).

• Copy the multiplier row (C7:E7).

• Select the cell range that will contain the results (C8:E8).
• Right-click the mouse.
• A context menu will appear. Select Paste Special.

• The Paste Special window will appear. Select Multiply.
• Click OK.

The results should look like this.

Download Practice Workbook

Related Articles

• How to Divide and Multiply in One Excel Formula
  
• How to Do Matrix Multiplication in Excel
• How to Multiply from Different Sheets in Excel
• How to Make Multiplication Table in Excel
• How to Multiply by Percentage in Excel 
• How to Multiply Two Columns and Then Sum in Excel
• How to Multiply Two Columns in Excel

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