Saturday, March 7, 2026
Facebook Instagram X Youtube
Google search engine
Home How To How to : How to Multiply in Excel

How to : How to Multiply in Excel

By
vulam.kd
-
0
1

[ad_1]

Method 1
Method 1 of 3:

Multiplying in a Cell

  1. Image titled Multiply in Excel Step 1


    1
    Open Excel. It’s a green app with a white “X” on it.

    • You’ll need to click Blank workbook (PC) or New and then Blank Workbook (Mac) to continue.
    • If you have an existing presentation you’d like to open, double-click it to open it in Excel.

  2. Image titled Multiply in Excel Step 2

    2
    Click a cell. Doing so will select it, allowing you to type into it.

  3. Image titled Multiply in Excel Step 3

    3
    Type = into the cell. All formulas in Excel start with the equals sign.

  4. Image titled Multiply in Excel Step 4

    4
    Enter the first number. This should go directly after the “=” symbol with no space.

  5. Image titled Multiply in Excel Step 5

    5
    Type * after the first number. The asterisk symbol indicates that you wish to multiply the number before the asterisk with the number that comes after it.

  6. Image titled Multiply in Excel Step 6

    6
    Enter the second number. For example, if you first entered a 6, and wanted to multiply it by 6, your formula would now look like =6*6.

    • You can repeat this process with as many numbers as you like, as long as the “*” symbol is between each of the numbers you want to multiply.

  7. Image titled Multiply in Excel Step 7

    7
    Press ↵ Enter. This will run your formula. The cell will display the product of the formula, though clicking the cell will display the formula itself in the Excel address bar.

Method 2
Method 2 of 3:

Multiplying Cells

  1. Image titled Multiply in Excel Step 8

    1
    Open an Excel presentation. Simply double-click an Excel document to open it in Excel.

  2. Image titled Multiply in Excel Step 9

    2
    Click a cell. Doing so will select it, allowing you to type into it.

  3. Image titled Multiply in Excel Step 10

    3
    Type = into the cell. All formulas in Excel start with the equals sign.

  4. Image titled Multiply in Excel Step 11

    4
    Type in another cell’s name. This should go directly after the “=” with no space.

    • For example, typing “A1” into the cell sets A1’s value as the first number in your formula.

  5. Image titled Multiply in Excel Step 12

    5
    Type * after the first cell name. The asterisk symbol indicates to Excel that you want to multiply the value before it with the value after it.

  6. Image titled Multiply in Excel Step 13

    6
    Type in a different cell’s name. This will set the second variable in your formula as the second cell’s value.

    • For example, typing “D5” into the cell would make your formula look like this: =A1*D5.
    • You can add more than two cell names to this formula, though you’ll need to type “*” between subsequent cell names.

  7. Image titled Multiply in Excel Step 14

    7
    Press ↵ Enter. This will run your formula and display the result in your selected cell.

    • When you click the cell with the formula result, the formula itself will display in the Excel address bar.

Method 3
Method 3 of 3:

Multiplying a Range of Cells

  1. Image titled Multiply in Excel Step 15

    1
    Open an Excel presentation. Simply double-click an Excel document to open it in Excel.

  2. Image titled Multiply in Excel Step 16

    2
    Click a cell. Doing so will select it, allowing you to type into it.

  3. Image titled Multiply in Excel Step 17

    3
    Type =PRODUCT( into your cell. This command indicates that you want to multiply items together.

  4. Image titled Multiply in Excel Step 18

    4
    Type in the first cell’s name. This should be the cell at the top of the range of data.

    • For example, you might type “A1” here.

  5. Image titled Multiply in Excel Step 19

    5
    Type : . The colon symbol (“:”) indicates to Excel that you want to multiply everything from the first cell through the next cell you enter.

  6. Image titled Multiply in Excel Step 20

    6
    Type in another cell’s name. This cell must be in the same column or row as the first cell in the formula if you want to multiply all the cells from the first cell to this one.

    • In the example, typing “A5” would set up the formula to multiply the contents of A1, A2, A3, A4, and A5 together.

  7. Image titled Multiply in Excel Step 21

    7
    Type ), then press ↵ Enter. This last parenthesis closes the formula, and hitting enter runs the command and multiplies your range of cells together, displaying the result instantly in your selected cell.

    • If you change the contents of a cell within the multiplication range, the value in your selected cell will also change.

Video

By using this service, some information may be shared with YouTube.



Tips

  • When using the PRODUCT formula to calculate the product of a range, you can select more than just one column or row. For example, your range could be =PRODUCT(A1:D8). This will multiply all of the values of the cells in the rectangle defined by the range (A1-A8, B1-B8, C1-C8, D1-D8).

    ⧼thumbs_response⧽

Submit a Tip

All tip submissions are carefully reviewed before being published

Submit

Thanks for submitting a tip for review!

You Might Also Like

Create an Excel Financial Calculator

How to

Create an Excel Financial Calculator

Recover a Corrupt Excel File

How to

Recover a Corrupt Excel File


Calculate the Day of the Week in Excel

How to

Calculate the Day of the Week in Excel

Convert Excel to PDF

How to

Convert Excel to PDF

Make a Spreadsheet in Excel

How to

Make a Spreadsheet in Excel

Unprotect an Excel Sheet

How to

Unprotect an Excel Sheet

Create a Mortgage Calculator With Microsoft Excel

How to

Create a Mortgage Calculator With Microsoft Excel

Create a Graph in Excel

How to

Create a Graph in Excel

Create a Timeline in ExcelHow to Create a Timeline in Excel: SmartArt, Templates, and More

Change from Lowercase to Uppercase in Excel

How to

Change from Lowercase to Uppercase in Excel

How to

Unhide Rows in Excel

Insert Pictures in Excel That Automatically Size to Fit Cells

How to

Insert Pictures in Excel That Automatically Size to Fit Cells

Convert Excel to Word3 Easy Ways to Convert Microsoft Excel Data to Word

Use ExcelNew to Excel? Here’s Super Easy Tricks to Get You Started

[ad_2]

Source link : https://www.wikihow.com/Multiply-in-Excel

RELATED ARTICLESMORE FROM AUTHOR

LEAVE A REPLY

Please enter your comment!
Please enter your name here

EDITOR PICKS

POPULAR POSTS

POPULAR CATEGORY

© Copyright 2017 - Newspaper WordPress Theme by TagDiv