To multiply in Google Sheets, select a cell, go to the

Formulabar, type the values for the equation with the asterisk symbol between them, and pressEnter.

In this article, we will look at three strategies for multiplying your values quickly and simply. Keep reading to see which one works best for you.

## Method 1: Using the Asterisk Sign

**Difficulty**: Beginner

**Time Estimate**: 5 Seconds

1. Select the cell where you need to get the result.

2. Go to the **Formula** bar and type the values you wish to multiply with the asterisk symbol between them. In our example, we use **=34*12**.

3. Press the** Enter** key on your keyboard.

Easy as ABC! Let’s move on!

## Method 2: Using Cell References

**Difficulty**: Beginner

**Time Estimate**: 5 Seconds

1. Choose the cell where you want your result.

2. In the** Formula** bar, enter the formula **=A1*B1**, where **A1** and **B1** are cells with your values.

3. Hit the** Enter **key.

Voila! The calculation is complete.

## Method 3: Using Formulas

**Difficulty**: Beginner

**Time Estimate**: 10 Seconds

1. Click on the cell where your answer should be.

2. Navigate to the **Formula** bar and type the formula **=MULTIPLY(34,12**). In our example, the values being multiplied are **34** and **12**. Enter the values you need.

3. Press **Enter**.

And there you go!

## Multiplying in Google Sheets FAQs

Check out some of these FAQs for a greater grasp on this subject!

### How do I multiply one column by another in Google Sheets?

To multiply one column by another, start by selecting the cell where you want your result. Then go to the** Formula** bar, enter the formula **=A:A*B:B**, and press **Enter**. **A:A** and **B:B** are the ranges of the columns you want to multiply. Here is the result:

### How do I multiply cells in different worksheets?

To multiply cells in different worksheets, select the cell where you want your result, go to the **Formula** bar, type the formula **=Sheet2!A1*Sheet1!A1**, and press the** Enter **key. In our case, **A1** is the reference cell in both **Sheet1** and **Sheet2**.