How to Multiply Numbers in Microsoft Excel Quickly

Date:2019-9-26 Author:Cordelia

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.

How to Multiply Numbers in Microsoft Excel Quickly

2. Input the formula directly: =A2*B2

How to Multiply Numbers in Microsoft Excel Quickly

3. Press [Enter] key to work it out.

How to Multiply Numbers in Microsoft Excel Quickly

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.

How to Multiply Numbers in Microsoft Excel Quickly

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 Function button above the table.

How to Multiply Numbers in Microsoft Excel Quickly

2. Or you can switch to Formulas tab and click Insert Function.

How to Multiply Numbers in Microsoft Excel Quickly

3. Input “product” in the search box and hit Go to search it. Then you can select PRODUCT from the list and click OK to confirm it.

How to Multiply Numbers in Microsoft Excel Quickly

4. Make sure the cells range is right in Function Arguments. Click OK to implement the function.

How to Multiply Numbers in Microsoft Excel Quickly

5. Then, similarly, you can use fill handle to apply this formula to multiple cells.

How to Multiply Numbers in Microsoft Excel Quickly

6. In this way, you can also multiply the numbers in an entire column.
multiply numbers in an Excel column
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *