How to Multiply in Excel

December 2022 · 2 minute read

This wikiHow teaches you how to multiply numbers in Excel. You can multiply two or more numbers within one Excel cell, or you can multiply two or more Excel cells against one another. Open Excel. It's a green app with a white 'X' on it.

Method 3 of 3:

Multiplying a Range of Cells

  • Picture 15 of How to Multiply in Excel

    Open an Excel presentation. Simply double-click an Excel document to open it in Excel.

  • Picture 16 of How to Multiply in Excel

    Click a cell. Doing so will select it, allowing you to type into it.

  • Picture 17 of How to Multiply in Excel

    Type =PRODUCT( into your cell. This command indicates that you want to multiply items together.

  • Picture 18 of How to Multiply in Excel Type in the first cell's name. This should be the cell at the top of the range of data.
  • For example, you might type "A1" here.
  • Picture 19 of How to Multiply in Excel

    Type : . The colon symbol (":") indicates to Excel that you want to multiply everything from the first cell through the next cell you enter.

  • Picture 20 of How to Multiply in Excel Type in another cell's name. This cell must be in the same column or row as the first cell in the formula if you want to multiply all the cells from the first cell to this one.
  • In the example, typing "A5" would set up the formula to multiply the contents of A1, A2, A3, A4, and A5 together.
  • Picture 21 of How to Multiply in Excel Type ), then press ↵ Enter. This last parenthesis closes the formula, and hitting enter runs the command and multiplies your range of cells together, displaying the result instantly in your selected cell.
  • If you change the contents of a cell within the multiplication range, the value in your selected cell will also change.
    • Jessica Tanner Jessica Tanner

    Update 05 March 2020

    ncG1vNJzZmismaXArq3KnmWcp51ktbDDjK2mZqWlocGqvMuyZKKmXZrFpLHL