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.
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."
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."
Type an equals sign in the formula bar at the top of the screen.
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".
Type an asterisk into the formula bar.
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".
Repeat Steps 5 and 6, if needed, to add more cells to the multiplication equation in the formula bar.
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."
Tips & Warnings
- You can also perform multiplication within a single cell by typing values instead of clicking on cells. For example, to multiply 12 by 6, click on a cell, then type "=12*6" into the address bar and press the "ENTER" key. The product of the equation, 72, displays as the value of the cell.