To multiply in Google Sheets, select a cell, go to the **Formula** bar, type the values for the equation with the asterisk symbol between them, and press **Enter**.

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**.