How to: Multiplication in Excel

Microsoft Excel is a spreadsheet program that allows you to perform various mathematical equations using the numerical values of cells. This feature can be used to create interactive spreadsheets so that when the value of one cell changes, the other cells in the equation change accordingly. You can add, subtract, divide and multiply cells using the formula bar at the top of the Excel program window. Use the asterisk symbol as the multiplication sign in the equation.

Step

Launch "Microsoft Excel" and open an existing spreadsheet by clicking "File" and "Open." Click to select a spreadsheet that contains a list of numerical values that you want to multiply, then click "Open."

Step

Click to place your mouse cursor in the cell where you want the product, or the result of the multiplication, to appear. For example, click on cell "A1."

Step

Type an equals sign in the formula bar at the top of the screen.

Step

Click on a cell that contains the first number you want to multiply. The name of the cell, expressed as the row and column where the cell is located, will appear in the formula bar. For example, click on cell "B1" which has a value of "3." In our example, the equation in the formula bar now displays "=B1".

Step

Type an asterisk into the formula bar.

Step

Click the next cell that you want to multiply by the value of the cell chosen in Step 4. The name of this cell will also be added to the formula bar. For example, click on cell "C1" which has a value of "4." In our example, the equation in the formula bar now displays "=B1*C1".

Step

Repeat Steps 5 and 6, if needed, to add more cells to the multiplication equation in the formula bar.

Step

Press the "ENTER" key to display the final product of the equation in the cell chosen in Step 2. In our example, the value of cell "A1," which is cell B1 multiplied by cell C1, is displayed as "12."