How to Multiply in Excel: A Step-by-Step Guide for Beginners


Michael Collins

Multiplying in Excel is a breeze once you get the hang of it. Whether you’re dealing with budget sheets, school projects, or work reports, knowing how to multiply can save you loads of time. In a nutshell, you can multiply by using a simple formula: type an equals sign (=), click on the first cell you want to multiply, type an asterisk (*), then click on the second cell you want to multiply, and press Enter. Voila! You’re now a multiplication whiz in Excel.

Step by Step Tutorial: How to Multiply in Excel

Before we dive into the nitty-gritty, let’s get one thing straight: multiplying in Excel uses formulas. Formulas are like magic spells for numbers—they make things happen! In the following steps, you’ll learn how to cast these numerical spells and multiply like a pro.

Step 1: Start with an Equals Sign (=)

Type an equals sign (=) into the cell where you want your multiplication result to appear.

The equals sign is the green light signaling Excel to get ready to calculate something. It’s the first thing you need to do when creating any formula.

Step 2: Select the First Cell to Multiply

Click on the first cell you want to be included in your multiplication.

When you click on the cell, its reference (like A1 or B2) will pop up after the equals sign. That’s Excel’s way of knowing which number you’re working with.

Step 3: Type the Multiplication Symbol (*)

After selecting the first cell, type an asterisk (*), which is the symbol for multiplication in Excel.

The asterisk is like the word ‘times’ in math class. It tells Excel to multiply the numbers in the cells you’re choosing.

Step 4: Select the Second Cell to Multiply

Click on the second cell that contains the number you want to multiply with the first.

Just like before, the second cell’s reference will show up in your formula, right after the asterisk.

Step 5: Press Enter

After selecting the second cell, hit Enter on your keyboard, and behold the multiplication magic!

Pressing Enter is like saying "Abracadabra!"—it finalizes the spell and gives you the result of your multiplication.

Once you’ve completed these steps, you’ll see the product of the two numbers you’ve chosen in the cell where you started your formula. If you’ve followed along correctly, you should feel a sense of accomplishment—multiplying in Excel is easy!

Tips for Multiplying in Excel

Here are some additional pointers to keep in mind when you’re multiplying in Excel. These tips will make the process even smoother and make you look like an Excel wizard!

  • Double-check that you’re using the asterisk (*) for multiplication, not the letter x.
  • Remember that you can multiply more than two cells by continuing to type asterisks and selecting more cells.
  • Use parentheses to control the order of operations, just like in regular math.
  • You can copy and paste a multiplication formula to other cells if you need to multiply different numbers by the same amount.
  • If you make a mistake, you can always press the undo button (Ctrl + Z) to try again.

Frequently Asked Questions

What if I need to multiply multiple cells at once?

You can multiply several cells together by continuing to type asterisks and selecting additional cells in your formula.

Can I multiply a whole column or row?

Yes, you can multiply entire columns or rows by selecting the range and using the same formula method.

How do I multiply by a fixed number?

Type the number directly into the formula instead of selecting a cell. For example, to multiply cell A1 by 10, you would type =A1*10.

Can I use the multiplication formula for percentages?

Absolutely! Just remember that percentages in Excel are represented as decimals (e.g., 50% is 0.5).

What happens if I get a #VALUE! error?

This error occurs when one of the cells you’re trying to multiply isn’t a number. Check to make sure there aren’t any letters or symbols in your cells.


  1. Start with an equals sign (=).
  2. Select the first cell to multiply.
  3. Type the multiplication symbol (*).
  4. Select the second cell to multiply.
  5. Press Enter.


Excel is a powerful tool that can handle a ton of number-crunching tasks, including multiplication. By following the simple steps outlined above, you can multiply numbers quickly and accurately. Always remember to start with the equals sign, select your cells carefully, and use the asterisk for multiplication. With these tips and tricks under your belt, you’ll be able to breeze through any Excel multiplication task that comes your way. Keep practicing, and soon you’ll be creating complex formulas and analyzing data like an Excel pro. Happy multiplying!