Multiplication is one of the four basic math operations. It’s easy to do in a spreadsheet (even with large numbers). Let’s learn how to multiply in Microsoft Excel.
How to Multiply in Excel (With New Values)
Quick, what’s 11 times 43? Odds are, you don’t know that one off the top of your head. This is where it helps to multiply in Excel.
Begin by clicking into any empty cell in a new worksheet. Go ahead and type an = sign. This tells Excel that you’re going to be inputting a formula in this cell.
Next, type 11 on your keyboard. Then, you’re going to want to insert Excel’s multiplication symbol. This is *, and you’ll find it on the 8 key on your keyboard. Type *, then 43. Your formula now reads:
=11*43
Press Enter on your keyboard, and Excel will return your solution in the cell: 473. Keep in mind, this process works for multiplying any sequence of numbers. Imagine you want to find 11 times 43 times 2. You’d simply add another *, then type 2:
=11*43*2
Here, your solution would be 946.
How to Multiply in Excel (With Existing Values)
Imagine you have two cells containing numbers, and you want to multiply them together. Thanks to formulas in Excel, there’s no need to retype anything.
To get started, click into any empty cell in your spreadsheet. Type = once again. Now, click on the first cell containing a number that you want to work with. Here, that’s cell B1.
Then, type the multiplication sign, *. Finally, click on the other cell, C1, and hit Enter. You’ll see your solution return in your cell: 150.
Just like before, this works with multiple cells. Simply continue typing *, and clicking each additional cell in turn.
As you can see, it’s easy to multiply in Excel – no tedious calculations needed!