How to Multiply in Google Sheets: A Step-by-Step Guide

Multiplying in Google Sheets is a cinch! All you need to do is use the multiplication formula, which is simply an equals sign followed by the numbers you want to multiply, separated by an asterisk (e.g., =2*3). This formula can be entered into any cell, and voila! You have your product.

Step by Step Tutorial: How to Multiply in Google Sheets

Before we dive into the steps, let’s understand what we’re aiming to achieve here. Multiplying in Google Sheets involves using a formula that tells the program to take the numbers you provide and multiply them together. It’s a simple process once you get the hang of it!

Step 1: Click on the cell where you want the result to appear

Click on the cell where you want your multiplication result to show up. This is where the magic happens!

When you click on a cell, it becomes active, indicated by a blue box around it. This tells Google Sheets that this is where you want your formula and result to be.

Step 2: Type the multiplication formula

Type the multiplication formula into the selected cell. The formula begins with an equals sign, followed by the numbers you’re multiplying, separated by an asterisk.

The equals sign is crucial as it tells Google Sheets that you are entering a formula, not just data. The asterisk (*) is the symbol for multiplication in most computer programs, including Google Sheets.

Step 3: Press Enter

After typing in your formula, press the Enter key on your keyboard to execute the formula.

As soon as you press Enter, Google Sheets performs the calculation using the numbers you provided and displays the result in the cell you selected in step 1.

After completing these steps, you’ll see the result of your multiplication in the cell you chose. That’s it—you’ve successfully multiplied in Google Sheets!

Tips for Multiplying in Google Sheets

  • Use parentheses to control the order of operations in your multiplication formula.
  • Remember that you can multiply cells together, not just numbers. For example, =A1*B1 would multiply the values in cells A1 and B1.
  • If you’re multiplying many numbers, consider using the PRODUCT function, which can make your formula shorter and cleaner.
  • You can copy and paste your multiplication formula to other cells if you need to perform the same calculation multiple times.
  • Double-check your formulas for any errors to ensure accurate results.

Frequently Asked Questions

How do I multiply a column of numbers by a constant in Google Sheets?

To multiply a column of numbers by a constant, you can use the fill handle to copy your formula down the entire column.

Can I multiply more than two numbers in Google Sheets?

Yes, you can multiply as many numbers as you like by stringing them together in the formula with asterisks.

What if I want to multiply two columns of numbers together?

You can multiply two columns of numbers together by using a formula like =A1*B1 and then using the fill handle to apply it to the entire column.

Why is my multiplication formula not working?

If your multiplication formula isn’t working, check for any typos, especially with the asterisk symbol, and ensure that you’re using numbers and not text.

Can I use the PRODUCT function for multiplication?

Yes, the PRODUCT function is specifically designed for multiplying numbers and can make your formulas cleaner, especially when dealing with many numbers.


  1. Click on the cell for the result.
  2. Type the multiplication formula.
  3. Press Enter.


Congratulations, you’ve just mastered how to multiply in Google Sheets! It’s a fundamental skill that can help you in various tasks, whether you’re managing finances, analyzing data, or just doing some quick math. Remember, practice makes perfect, so don’t hesitate to experiment with different formulas and functions. The more comfortable you become with Google Sheets, the more efficient and effective your data management will be. So go ahead, give it a try, and watch your productivity multiply!

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy