An Easy-to-Use Guide to Automatically Multiply Numbers in Excel

This wikiHow teaches you how to multiply numbers in Excel. You can multiply two or more numbers in a single Excel cell, or you can multiply two or more Excel cells against each other.

## [Edit]step

### [Edit]multiply in cell

- Open Excel. It’s a green app with a white “X” on it.
- you have to click
**blank workbook**(PC) or**New**And then**blank workbook**(Mac) To continue. - If you have an existing presentation you want to open, double-click it to open it in Excel.

- you have to click
- Click on the cell. Doing so will select it, allowing you to type in it.
- Type in the cell. All formulas in Excel begin with an equal sign.
- Enter the first number. It should go right after the “=” symbol without any spaces.
- Type after the first number. The asterisk indicates that you want to multiply the number before the asterisk by the number after it.
- Enter another number. For example, if you entered 6 earlier, and wanted to multiply it by 6, your formula would now look like this.
- You can repeat this process with as many numbers as you want, as long as there is a “*” sign between each number you want to multiply.

- Press . This will make your formula work. The cell will display the product of the formula, although clicking on the cell will display the formula itself in the Excel address bar.

### [Edit]multiplication of cells

- Open an Excel presentation. Simply double-click on an Excel document to open it in Excel.
- Click on the cell. Doing so will select it, allowing you to type in it.
- Type in the cell. All formulas in Excel begin with an equal sign.
- Type in the name of the second cell. It should go directly after “=” without any space.
- For example, typing “A1” in a cell sets the value in A1 as the first number in your formula.

- Type after the name of the first cell. The asterisk indicates to Excel that you want to multiply the value before it by the value after it.
- Type in the name of a separate cell. This will set the second variable in your formula as the value of the second cell.
- For example, typing “D5” into cell your formula would look like this:
`=A1*D5`

, - You can add more than two cell names to this formula, although you must type a “*” between subsequent cell names.

- For example, typing “D5” into cell your formula would look like this:
- Press . This will run your formula and display the result in your selected cells.
- When you click on the cell containing the formula result, the formula itself will be displayed in the Excel address bar.

### [Edit]multiply range of cells

- Open an Excel presentation. Simply double-click on an Excel document to open it in Excel.
- Click on the cell. Doing so will select it, allowing you to type in it.
- Type in your cell. This command indicates that you want to multiply the items together.
- Type the name of the first cell. It should be the cell at the top of the range of data.
- For example, you can type “A1” here.

- Type . The colon symbol (“:”) tells Excel that you want to multiply everything from the first cell through the next cell you entered.
- Type in the name of the second cell. If you want to multiply all cells in this cell by the first cell, this cell must be in the same column or row as the first cell in the formula.
- In the example, typing “A5” will create a formula to multiply the contents of A1, A2, A3, A4, and A5 together.

- Type, then press . This last parenthesis closes the formula, and hitting Enter runs the command and multiplies your range of cells together, immediately displaying the result in your selected cell.
- If you change the contents of a cell within the multiplication range, the value in your selected cell will change as well.

## [Edit]Video

## [Edit]Advice

- When using the Product formula to calculate the product of a range, you can select more than just one column or row. For example, your range could be =PRODUCT(A1:D8). This will multiply all the values in the cells in the rectangle defined by the range (A1-A8, B1-B8, C1-C8, D1-D8).

## [Edit]Related wikiHows

- Create an Excel Financial Calculator
- recover a corrupted excel file
- Calculate day of week in excel
- convert excel to pdf