Multiplying is certainly a frequent and easy task in **Excel**. We often need to **multiply rows in Excel **to get a job done. In this article, I am going to show you how to **multiply rows** in **Excel** in 4 ways. For each way, I will discuss two cases for your convenience.

**Table of Contents**hide

**Download Practice Workbook**

This is a sample workbook that I am going to use to illustrate how to **multiply rows** in **Excel**. Here, I have the Number of** Working Days **for the month of January of three individual persons named

**,**

*James***and**

*Adam,***along with**

*Bob***and**

*Working Hours/Day***. And I am going to calculate**

*Earning/Hour***and**

*Working Hours/Month*

*Salary**.*

**4 Ways to Multiply Rows in Excel**

I am going to describe how to multiply **rows** in **Excel **in four ways. You can easily learn these methods and apply the ones you find useful.

### 1. Basic Way to Multiply Rows in Excel

In this section, I am going to discuss the basic way to multiply **rows **in **Excel.**

#### 1.1. A Row by a Cell

To find the ** Working Hours/Month**, you have to multiply

**and**

*Working Days***. For this,**

*Working Hour /Day*Select the

**C6**cell and type the following formula.

`=C5*$G$5`

**C5**and

**G5**cell values and as a result, you will get the result in cell

**C6**.

You have to put the

**Dollar Sign**to use an

**absolute cell reference**for

**Cell G5**since you need to multiply all the row elements with this

**Cell**.

Then, press **ENTER**. You will get the working hour per month of January for **James**.

Now, use the **Fill Handle **to **Autofill** the formula up to **Cell E6**. As a consequence, you will find the * Working Hours per Month* for

*and*

**Adam***.*

**Bob**#### 1.2. A Row by Another Row

Now, let’s have a look at how to multiply a **row** with **another row**. In this case, I am going to multiply ** Working Hour per Month** with

**to calculate the Salary. For this,**

*Earning per Hour*First, select

**C8**and type the formula.

`=C6*C7`

**cell**

**C6**and

**cell**

**C7**and the result will pop up in

**cell**

**C8**.

Then, press **ENTER**. You will get the **salary** of ** James** for the month of

**January**.

After that, use the **Fill Handle **to **AutoFill** the formula up to **Cell E8 **to complete the multiplication.

**Read More: What is the Formula for Multiplication in Excel for Multiple Cells? (3 Ways)**

### 2. Multiply Rows in ARRAY

You can multiply **rows** in **Excel** using the **ARRAY** formula.

#### 2.1. A Row by a Cell

Here, I am going to multiply multiple cell values of the same **row** by a **certain **cell value. To do so, you need to,

First, select the cell range of your choice.

I selected the cell range **C5:E5**.

Then write the formula in the formula bar or in the selected cell.

`=C5:E5*G5`

**ENTER**,

**. As a result, you will see the**

__press CTRL + SHIFT + ENTER__*for*

**Working Hours per Month***,*

**James***and*

**Adam***at one go.*

**Bob**Here, you will get the multiplication of the cells

➤

**G5**and

**C5**in

**cell**

**C6**.

➣

**G5**and

**D5**in

**cell**

**D6**.

➢ And,

**G5**and

**E5**in

**cell**

**E6**.

You will see the **curly bracket** in the formula bar as a result of multiplication in **ARRAY**.

**Similar Readings**

**How to Multiply One Cell by Multiple Cells in Excel (4 Ways)****Multiply Columns in Excel (9 Useful and Easy Ways)****How to Multiply Two Columns in Excel (5 Easiest Methods)****Use Multiply Sign in Excel (With 3 Alternative Methods)**

#### 2.2. A Row by Another Row

Now, let’s multiply **multiple **cell values of two **rows** by one another. To calculate the ** Salary** by multiplying

**and**

*Working Hours per Month***,**

*Earning per Hour*First, select the cell range

**C8**:

**E8**.

Then type the following formula in the **formula bar**.

`=C6:E6*C7:E7`

__press__as it’s an

**CTRL + SHIFT + ENTER****array**formula. Consequently,

**Excel**will return the

*for*

**Salary***,*

**James***and*

**Adam***.*

**Bob**Here, you will get the multiplication of the cells

➤ Cells

**C6**and

**C7**are in

**cell**

**C8**.

➣ Cells

**D6**and

**D7**are in

**cell**

**D8**.

➢ And, the cells

**E6**and

**E7**in

**cell**

**E8**.

** **Curly brackets will appear again for performing multiplication in **ARRAY**.

**Read More: How to Multiply Multiple Cells in Excel (4 Methods)**

### 3. Multiply Rows Using PRODUCT Function

You can also multiply **rows** using the **PRODUCT **function.

The **PRODUCT** function returns the result of multiplying all the inputs.

If cells **A1** and **A2** both contain numbers, for example, you can multiply them using the formula **=PRODUCT(A1,A2)**.

#### 3.1. A Row by a Cell

Let’s have a look at how to multiply a **row **by a **cell **using the **PRODUCT **function. To find out the ** Working hours per Month**, you should multiply the number of

**and**

*Working Days (Jan)***. For this,**

*Working hours per Day*First, select

**C6**and type the following formula,

`=PRODUCT(C5,$G$5)`

**cell C5**and

**cell G5**in

**cell C6**. Here, I used

**Dollar Sign**which indicates

**Absolute Cell Reference**

**so that I can use**

**AutoFill**later.

Press **ENTER**, it will return **Working Hours/Month** of **James**.

Now, use the **Fill Handle **to **AutoFill **the formula up to **Cell E6**.

#### 3.2. A Row by Another Row

You can also multiply a **row** by another **row** using the **PRODUCT** function. Suppose you want to get the ** Salary** by multiplying

**and**

*Working Hours per Month***. For this,**

*Earning per Hour*First, select

**cell C8**and type the following formula,

`=PRODUCT(C6,C7)`

**cell C6**and

**cell C7**in

**cell C8**.

Then, press **ENTER**. It will return the **Salary **of **James** for the month of **January**.

Now, use the **Fill Handle **to **AutoFill **the formula up to **Cell E8**.

**Read More:** **If Cell Contains Value Then Multiply Using Excel Formula (3 Examples)**

**Similar Readings**

**How to Multiply a Column by a Number in Excel (4 Easy Methods)****Multiply by Percentage in Excel (4 Easy Ways)****How to Multiply a Column in Excel by a Constant (4 Easy Ways)****Multiply Two Columns and then Sum in Excel**

### 4. Multiply Rows Using Paste Special

In this section, I am going to discuss how to multiply **rows **in **Excel **using Paste Special.

**4.1. A Row by a Cell**

Suppose you want to calculate ** Working Hours per Month **by multiplying

**and**

*the number of Working Days***. For this,**

*Working Hour per Day*First,

**copy**the values of

**C5:E5**then

**Paste**them to

**C6:E6**.

Then, **copy G7**.

After that, select the cell range **C6:E6**.

Then **right click the mouse**. A

**context menu**will appear. Select

**Paste Special**from there.

**Paste Special **window will appear. Now select **Multiply**.

Then, click **OK**.

The output will be like this where it shows the total **Working Hours/Month for James**,** Adam**, and **Bob**.

The formatting will be like **cell G7 **as we have pasted **cell G7 **in all **three cells**.

#### 4.2. A Row by Another Row

Now, we will see how to multiply a **row **with another **row **using **Paste Special**. Suppose you want to calculate total ** Salary **by multiplying

**and**

*Working Hours per Month***.**

*Earning per Hour*For this,

First, copy

**C6:E6**then

**Paste**them to

**C8:E8**.

Then, **Copy C7:E7**.

After that, select the cell range **C8:E8**. Then **right click the mouse**. A

**context menu**will appear. Select

**Paste Special**from there.

As a result, **Paste Special **window will pop up. Select **Multiply **from there, then click **OK**.

**Multiplication **will be done. The output will be like this,

**Read More: Multiplication Formula in Excel (6 Quick Approaches)**

## Practice Workbook

Multiplication of **rows** in **Excel **is undoubtedly easy. However, the most significant fact to master the task is to practice. That’s why I have attached a sheet for you to practice.

## Conclusion

In this article, I have tried to explain how to multiply **rows** in **Excel **in four possible simplest ways. I will be immensely delighted if anyone finds it helpful. And lastly, if anyone wants to give any feedback, please let us know your thoughts in the comment section.

Excel with us!