Skip to main content

How to multiply in Excel

While it's not as easy as tapping a few keys on a calculator, you can use Microsoft Excel to multiply numbers. In order to do this, you'll need to learn Excel's language a bit. But don't worry, in this guide, we'll go over what you need to know as we show you how to multiply in Excel.

We'll review four different ways to multiply in Excel: Simple multiplication within a cell, multiplying numbers from different cells, multiplying ranges of numbers, and multiplying each number of a column by a constant.

Difficulty

Easy

Duration

10 minutes

What You Need

  • A PC

  • Microsoft Excel

How to multiply within a cell

If you just want to perform simple multiplication within a cell in an Excel spreadsheet, here's what you do:

Step 1: Click on a cell.

Step 2: Type the following (with no spaces) into that cell: =[any number] * [any number].

For example:

=20*35

how to multiply in excel simple multiplication
screenshot

Step 3: Then hit the Enter key on your keyboard. (Or click anywhere else on the spreadsheet.)

The formula you typed will immediately be replaced with the correct answer.

How to multiply numbers from different cells

If you have a data set and you want to multiply numbers from it together (as in numbers from different cells), here's how to do that:

Step 1: Choose at least two numbers from your data set to multiply. Then click on a blank cell.

Step 2: In the blank cell, type the following: =[cell reference for any number] * [cell reference for any number].

For example:

=A4*A5

A cell reference is a column letter combined with a row number that refers to the cells of each of your desired numbers.

how to multiply in excel multiplying numbers from different cells
screenshot

Step 3: Then hit Enter on your keyboard. The correct answer should immediately replace the formula you typed in.

How to multiply ranges of numbers via the Product function

You can also multiply cell ranges (ranges of numbers in your data set). To do so, you'll use the PRODUCT function. Here's how:

Step 1: Choose where you want your range to begin and end. Then click on a blank cell.

Step 2: In that blank cell, type the following (with no spaces): =PRODUCT([cell reference for beginning of range] : [cell reference for end of range]).

For example:

=PRODUCT(A1:A5).

how to multiply in excel multiplying ranges
screenshot

Step 3: Then hit the Enter key on your keyboard. The correct answer should immediately replace the PRODUCT function you typed in.

How to multiply in Excel: Multiplying each number in a column by a constant

If you have a data set and you need to multiply each value in that set by a constant number, you can do that in Excel. Here's how:

Step 1: At the top of a new column, type in your desired constant number.

(In our example, the new column is B and the constant is 5.)

Step 2: At the top of the next new column, type in the following with no spaces, using the cell references for the first number in your data set and your desired constant number: =[cell reference for the first number in data set] * $[column letter for desired constant number]$[row number for desired constant number].

In our example, the next new column is C and the formula would look like this: =A1*$B$1.

Step 3: Then hit the Enter key on your keyboard. The correct answer should immediately replace the formula you just typed in.

Step 4: In order to get the correct answers for all of the other numbers in your data set, just do the following:

Click on the cell where you typed in your formula and then mouse over it until you see a black cross icon, then click and drag your formula down to the other cells in that column to copy it to them. Once you release the mouse button, the correct answers for each of the values in your data set should immediately appear as they did for the first value.

how to multiply in excel multiplying numbers by a constant
screenshot

Editors' Recommendations

Anita George
Anita has been a technology reporter since 2013 and currently writes for the Computing section at Digital Trends. She began…
How I supercharged my productivity with a free typing app
Alan Truly's standing desk has a MacBook Air, Surface Book 2, and iPhone 13 Pro Max.

As a tech writer, details matter, so I immediately jumped on using Beeftext when I discovered it. It's a typing application for Windows (there are alternatives for other operating systems I'll cover here, as well), and I first loaded it up to ensure that my typing was accurate. I didn't expect how much it would supercharge my productivity in the process.

Beeftext isn't a fancy, AI-enhanced writing tool. It’s a classic text expander, also known as a text substitution app. If you’ve never used one before, you really need to experience this kind of computer magic. I type in a few letters, then hit the space bar. Instantly, a long word, phrase, or even several lines of text will appear.

Read more
How to take a screenshot using a Microsoft Surface
A 2017 Microsoft Surface Pro on a table.

Whether you want to capture friends and relatives making funny faces on Skype or need accessible photos of online resources or programs, screenshots benefit users in many ways. With a simple press of a keyboard’s print screen key, you essentially have the ability to capture anything and everything occurring on your desktop at any time.

Read more
How to recover unsaved Word documents
Microsoft word document.

We’ve all been there. We’re so focused on working on a Word document that we may forget to save it and then exit without thinking — not to mention system errors or Microsoft Word itself crashing. Conveniently, Microsoft provides a useful feature for the program that can recover everything you might have lost.

Here’s how to recover unsaved Word documents.

Read more