How to Multiply Cells in Excel

Multiply with Cell References
1. Click on cell A1. Type the number 12 into cell A1. Type the number 6 into cell B1.
2. Click on cell C1. Type the equal sign (=) at the beginning of your equation.
3. Click on cell A1. This action places A1 in cell C1 on the right side of the equal sign.
4. Type an asterisk (*) sign into cell C1.
5. Click on cell B1. This action places B1 into cell C1, after the asterisk.
6. Press the 'Enter' button on the keyboard or click on the check mark on the tool bar to display a result. The number 72 should appear in cell C1.
Multiply Numbers in a Cell
7. Click on a blank cell. Type in the first number you want to multiply, for instance, 6.
8. Type in an asterisk (*).
9. Type the second number, for instance, 3.
10. Press the 'Enter' key or click on the check mark button on the toolbar. The result should appear in the cell.
Multiply a Group of Numbers by One Number
11. Enter the numbers you would like to multiply in a group of cells. For instance, enter the numbers 5, 4 and 8 into cells B1, B2 and B3.
12. Type the number 7 into cell A1.
13. Select cell A1. Open the 'Edit' menu and click on 'Copy.'
14. Select cells B1, B2 and B3.
15. Open the 'Edit' menu and select 'Paste Special.' In the 'Operations' section of the 'Paste Special' box, click on 'Multiply.'
16. Click 'OK' to perform the calculation. The numbers in cells B1, B2 and B3 should now be 35, 28 and 56, respectively.
17. Delete the number in A1.
Multiply Numbers in Different Cells with the PRODUCT Function
18. Enter the numbers you want to multiply. Type 4, 8 and 10 into cells A1, A2 and A3 respectively. Type the number 2 into cell B1.
19. Click on cell A4. Type =PRODUCT(A1:A3).
20. Press the 'Enter' key to perform the calculation. The PRODUCT function will multiply all the numbers in the range. Cell A4 should display 320.
21. Use the PRODUCT function to multiply a group of numbers in a range by a number. To multiply the numbers in cells A1, A2 and A3 by 2, click on cell A4. Type =PRODUCT(A1:A3,2).
22. Press the 'Enter' key to display the result. Cell A4 should show 640.