# How to Multiply Multiple Cells in Excel – 4 Methods

The sample dataset showcases product quantity and unit price.

## Method 1 – Using the Asterisk Sign to Multiply Multiple Cells in Excel

Steps

• Select a cell to display the value.

• In the formula bar, enter the equal sign (=). Supply your cell reference. Here, C5 is multiplied by D5. Enter the formula.
`=C5*D5`

• Press Enter.

• Drag down the Fill Handle to apply the formula to the rest of the cells.

Read More: How to Multiply Two Columns in Excel

## Method 2 – Applying the PRODUCT Function to Multiply Multiple Cells

Steps

• Select a cell to display the value.

• Enter the equal sign (=) in the formula box.
• Enter Product.
• Enter number 1 (the first  cell) and number 2 (the second cell). More numbers can be used separated by a comma.

• To multiply C5 by D5, enter the following function.
`=PRODUCT(C5,D5)`

• Press Enter.

• Drag down the Fill Handle to apply the formula to the rest of the cells.

## Method 3 – Multiplying Multiple Cells with a Constant Value in Excel

### 3.1 Using Paste Special Command

Steps

• Set a constant value in a blank cell. Here, ‘5’ .
• Copy it and select the range of cells you want to multiple by the constant value.

• Go to the Home tab and click Paste.

• In Paste, select Paste Special.

• In the Paste Special dialog box, select All in Paste, and Multiply in Operation.
• Click ‘OK’.

This is the output.

### 3.2 Applying a Formula in Excel

Steps

• Enter a constant value in a blank cell.
• Select a column to display the result of the multiplication.

• Enter the Equal Sign (=). Select the cell reference and the constant value cell reference. Use the Asterisk Sign (*) between the two cell references. Enter the following formula:
`=E5*\$H\$5`

• Press Enter to see the result.

• Drag down the Fill Handle to apply the formula to the rest of the cells.

Note: Here, you can see we use a dollar sign (\$) to represent the constant value cell reference. The dollar sign can transform the constant value reference into an absolute cell reference.

Read More: How to Multiply Rows in Excel

## Method 4 – Creating an Excel Array Formula to Multiply Multiple Cells

Steps

• Select a cell to enter the Array formula.

• Enter the Equal sign (= . Enter the following formula.
`=SUM(C5:C9*D5:D9)`

• Press Ctrl+Shift+Enter to apply the formula.

## Things to Remember

For an array function press Ctrl+Shift+Enter to apply the formula.

## Related Articles

<< Go Back to Multiply in Excel

Get FREE Advanced Excel Exercises with Solutions!
Durjoy Paul

Durjoy Kumar, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, is a dedicated contributor to the ExcelDemy project. His substantial contributions include crafting numerous articles and demonstrating expertise in Excel and VBA. Durjoy adeptly automates Excel challenges using VBA macros, offering valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, SPSS, C, C++, C#, JavaScript, Python Web Scraping, Data Entry... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF