## 1) How to Multiply in Excel without Cell References

This is the most basic method; you’re using Excel like you would a calculator. Here you’ll just type the numbers you want to multiply into a blank cell without referencing any other parts of your workbook.

a. Pick a blank cell

b. Type **=**

c. Enter your first number

d. Type ***** (i.e. Shift-8)

e. Enter your second number

f. Hit Enter

This isn’t limited to two numbers – add as many as you want with a ***** separating them.

## 2) How to Multiply in Excel with Cell References

If the values you want to multiply are already in cells, you can simply reference them in the your formula:

a. Pick a blank cell

b. Type **=**

c. Click on the cell with your first number

(or type the cell coordinates, i.e. B1)

d. Type ***** (i.e. Shift-8)

e. Click on the cell with your second number

(or type the cell coordinates, i.e. B2)

f. Hit Enter

** In general, m****ultiplying with cell references is preferable to “hard coding” your numbers for a few reasons:**

- It’s dynamic. In our example, if the values in B1 or B2 change the number in A1 will update accordingly.
- You and others can see how you arrived at your number and trace the logic.

## 3) How to Multiply in Excel using the Product Function

Got a bunch of numbers you want multiplied together? You can use the Product function instead of manually referencing each cell and separating with an *.

a. Pick a blank cell

b. Type **=PRODUCT(**

c. Select the numbers you want multiplied. If they aren’t contiguous, use a comma to separate them

d. Close the formula with **)**

e. Hit Enter

## 4) How to Multiply in Excel using a Constant

Maybe you’ve got an entire column or block of data you want multiplied by a specific number (the constant). Here are two methods for doing that – one keeps the original data intact and the other replaces it.

### Method 1 – Keep the Original Data Intact

a. Select the cell to the right of the first cell you want multiplied

b. Type **=** and click on that first cell

c. Type** *** (i.e. Shift-8)

d. Select the cell with your constant number

(or if you’re not referencing a cell, type the constant number, i.e. 5)

e. Make your cell reference “absolute” (so it won’t change when you copy the formula down) by highlighting the location in the formula bar and hitting F4

f. Hit Enter

g. Copy the formula down (I prefer to use autofill – just double click the little black box at the bottom right of the first formula cell)

### Method 2 – Replace the Original Data with the Multiplied Values

Don’t care to keep your original numbers? Here’s how to multiply in Excel using Paste Special:

a. Select the constant value you want to multiply by:

b. Right click and select “Copy”:

c. Select the data you want multiplied:

d. Right click and select “Paste Special”:

e. Under Operation select “Multiply” and click OK:

Voila! Your data has been replaced with the new values:

There you have it, how to multiply in Excel several different ways. Which one you’ll want to employ will vary depending on your application.

Want more Excel tips? Here you can learn some great shortcut keys to save you time.

## Leave a Comment