Skip to main content

How to multiply in Excel

Stock photo of woman using laptop at desk
Moose Photos/Pexels

While it's not as easy as tapping a few keys on a calculator, you can use Microsoft Excel to perform simple math, such as multiplying 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.

Recommended Videos

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.

(You can lock cells in Excel to protect the contents, useful if the cells in question display the result of a formula.)

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.

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 entered 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

Microsoft Excel is an incredibly flexible piece of software, capable of everything from basic math to advanced calculations for all manner of purposes from business to science and data analysis. But if you want to keep things simple for now, why not learn how to subtract in Excel?

Anita George
Anita George has been writing for Digital Trends' Computing section since 2018. So for almost six years, Anita has written…
How to create a pivot table in Excel to slice and dice your data

Microsoft Excel is arguably the greatest spreadsheet application from Redmond, and there's a good reason so many number crunchers use it for all of their number crunching needs. While using Microsoft Excel is fine for simple spreadsheets to track expenses or build calendars, it comes into its own when you need to slice and dice and then present complex data. Here, we show you how to create a pivot table in Excel to take advantage of one of the application's most powerful tools.

Before we start, just what exactly are pivot tables good for? Simply put, pivot tables let you look at the same data in different ways and from different angles, to make it easier to perform in-depth analysis and to spot important trends. When you're evaluating sales results, for example, you may want to look at an individual person, a specific product, or a specific timeframe. With a pivot table, you can create one pool of information and then easily change your focus from one thing to another -- an analysis that would be tedious to perform manually.

Read more
How to set an ‘Out of Office’ message in Microsoft Teams
Person using Windows 11 laptop on their lap by the window.

Many people use Microsoft Teams regularly to communicate with colleagues both inside of the office and remotely. It is considered one of the most efficient ways to ensure you can stay in contact with the people on your team, but what if you need to let people know you’re not readily available? Microsoft Teams has a method for you to set up an "Out of Office" status for your profile to let staff members know when you’ll be gone for the afternoon, for several days on vacation, or for an extended period.
Where do I go to set up my ‘Out of Office’ status for Teams?
It is important to note that your Microsoft Teams and Outlook calendars are synced. This includes your out-of-office status and automatic replies. So, whatever you set up in Microsoft Teams will reflect in Outlook. Similarly, you can set up your out-of-office status in Outlook, and it will be reflected in Teams; however, the former has a more straightforward instruction.

The following steps will work whether you use Microsoft Teams online or on the desktop.

Read more
How to delete or hide chats in Microsoft Teams
Running Microsoft Teams on the Galaxy Tab S8.

Microsoft Teams is a terrific workplace platform for keeping the camaraderie strong. Featuring collaborative messaging, video conferencing, and file-sharing tools, it’s your one-stop-shop for in-office, hybrid and at-home workers alike. But anyone with a long history of using Microsoft Teams will tell you how clogged up your message stockpile can get. Fortunately, deleting and hiding these exchanges is relatively easy to do, and we’ve put together this guide to help.

Read more