How to Multiply in Excel

Open Excel., Click a cell., Type = into the cell., Enter the first number., Type * after the first number., Enter the second number., Press ↵ Enter.

7 Steps 1 min read Medium

Step-by-Step Guide

  1. Step 1: Open Excel.

    It's a green app with a white "X" on it.

    You'll need to click Blank workbook (PC) or New and then Blank Workbook (Mac) to continue.

    If you have an existing presentation you'd like to open, double-click it to open it in Excel.
  2. Step 2: Click a cell.

    Doing so will select it, allowing you to type into it., All formulas in Excel start with the equals sign., This should go directly after the "=" symbol with no space., The asterisk symbol indicates that you wish to multiply the number before the asterisk with the number that comes after it., For example, if you first entered a 6, and wanted to multiply it by 6, your formula would now look like =6*6.

    You can repeat this process with as many numbers as you like, as long as the "*" symbol is between each of the numbers you want to multiply. , This will run your formula.

    The cell will display the product of the formula, though clicking the cell will display the formula itself in the Excel address bar.
  3. Step 3: Type = into the cell.

  4. Step 4: Enter the first number.

  5. Step 5: Type * after the first number.

  6. Step 6: Enter the second number.

  7. Step 7: Press ↵ Enter.

Detailed Guide

It's a green app with a white "X" on it.

You'll need to click Blank workbook (PC) or New and then Blank Workbook (Mac) to continue.

If you have an existing presentation you'd like to open, double-click it to open it in Excel.

Doing so will select it, allowing you to type into it., All formulas in Excel start with the equals sign., This should go directly after the "=" symbol with no space., The asterisk symbol indicates that you wish to multiply the number before the asterisk with the number that comes after it., For example, if you first entered a 6, and wanted to multiply it by 6, your formula would now look like =6*6.

You can repeat this process with as many numbers as you like, as long as the "*" symbol is between each of the numbers you want to multiply. , This will run your formula.

The cell will display the product of the formula, though clicking the cell will display the formula itself in the Excel address bar.

About the Author

T

Thomas Stone

Professional writer focused on creating easy-to-follow lifestyle tutorials.

105 articles
View all articles

Rate This Guide

--
Loading...
5
0
4
0
3
0
2
0
1
0

How helpful was this guide? Click to rate: