# How to Multiply Rows in Excel (4 Easy Ways)

### Multiply a Row by a Cell

• Select the appropriate cell (C6 in this example) and type the following formula.
`=C5*\$G\$5`

• 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.
`=C6*C7`
• Press ENTER.
• Use the Fill Handle to Autofill the formula for the rest of the row.

### Multiply a Row by a Cell

• Select the relevant cell range. (C5:E5 in this example).
• Enter the following formula.
`=C5:E5*G5`
• 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.
`=C6:E6*C7:E7`
• Press CTRL + SHIFT + ENTER.

### Multiply A Row by a Cell

• Select the relevant cell (C6) and type the following formula.
`=PRODUCT(C5,\$G\$5)`
• 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.
`=PRODUCT(C6,C7)`

• Press ENTER.

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

### 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.

### Related Articles

<< Go Back to Multiply in Excel

Get FREE Advanced Excel Exercises with Solutions!
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF