Multiplication and division are very common in mathematics as well as in Excel calculations. To multiply numbers in Excel, there’re 2 simple ways you can try. I’ll share the detailed steps in this post.

## Method 1: Using Formula to Multiply

1. Click the cell for outputting the calculation result.

2. Input the formula directly:

**=A2*B2**3. Press

**[Enter]**key to work it out.4. Drag the fill handle, which looks like a small black cross at the bottom-right corner of C2, to apply the formula to cells below. It will multiply the data of Value 1 and Value 2 in each row accordingly.

**Method 2: Using Excel Functions to Multiply**

In addition to type the formula directly, you can also insert a ** PRODUCT** function to multiply numbers in Excel.

1. Select the cell C2, click Insert

**button above the table.***Function*2. Or you can switch to

**tab and click***Formulas***.***Insert Function*3. Input “product” in the search box and hit

**to search it. Then you can select***Go***from the list and click***PRODUCT***to confirm it.***OK*4. Make sure the cells range is right in

**. Click***Function Arguments***to implement the function.***OK*5. Then, similarly, you can use fill handle to apply this formula to multiple cells.

6. In this way, you can also multiply the numbers in an entire column.