How to Multiply in Excel for Office 365

Photo of author

By Matthew Simpson

In Excel for Office 365, multiplying is straightforward. Use the basic formula by typing =number1*number2. For multiplying cells, type =Cell1*Cell2, like =A1*B1. To multiply entire columns, use the same method and drag down to fill the desired cells.

Have you ever found yourself scratching your head, wondering how to multiply numbers in Excel for Office 365? We’ve all been there, trust me! Whether you’re balancing your budget, calculating sales, or analyzing data, multiplication is a fundamental skill in Excel. Let’s get multiplying, shall we?

A Basic Intro to Excel Multiplication

Excel is pretty much the superhero of spreadsheets. But like any superhero, you need to know its special powers. One of its most common powers? Multiplication!

The Basic Formula

Ready to dive into the math pool? Here’s how you do it. In any cell, type =, then the number you want to multiply, an asterisk (*), and then the second number. Press Enter and voila! You’ve got your product.

Multiplying Cells

What if you want to multiply values from two different cells? Easy-peasy! If you have numbers in cells A1 and B1, type =A1*B1 in another cell. Hit Enter, and the magic happens.

Multiplying Columns

Got an entire column of numbers? No sweat! Let’s say you want to multiply values in Column A and Column B and show results in Column C. Click on the cell in Column C where you want the result, type =A1*B1, then drag down to fill the entire column. Excel’s got your back!

The PROs of Multiplying in Excel

Multiplication in Excel is like having a math magician in your computer. Here’s why:

  1. Speed: Faster than you can say “math whiz”!
  2. Accuracy: Minimize human errors.
  3. Flexibility: Change one number and the results update instantly.

The CONs of Multiplying in Excel

But, like anything in life, there are a couple of drawbacks:

  1. Overwhelming for Beginners: It can seem a tad complicated initially.
  2. Errors: If you enter the wrong formula, you’ll get the wrong result.
  3. Dependency: Relying too much on Excel can make you rusty with manual calculations.

Additional Information

Excel is more than just multiplication. It’s a universe of formulas, charts, and functions. For those looking to delve deeper, try exploring functions like SUMPRODUCT for more complex multiplication tasks.


Multiplying in Excel for Office 365 is a piece of cake once you get the hang of it. Whether you’re a seasoned pro or a newbie, Excel is a tool that, with a bit of practice, can become your best friend in the world of calculations. So, ready to multiply and conquer?


  1. Can I multiply multiple cells at once? Yes, using functions like SUMPRODUCT or array formulas.
  2. What if my multiplication isn’t working? Double-check your formula for errors or missing symbols.
  3. Can I multiply across different sheets? Absolutely! Just reference the sheet name: =Sheet1!A1*Sheet2!B1.
  4. How do I multiply a whole column by a single number? Just type =A1*5 (or whatever number) and drag down.
  5. Is there a limit to how many cells I can multiply? Only by how many cells there are in Excel, which is over 17 billion!