If you want to **divide** in Excel for an entire row, this article is for you. Here, we will demonstrate to you 6 effective methods to do the task effortlessly.

**Table of Contents**hide

## Download Workbook

## 6 Methods to Divide for Entire Row in Excel

The following **Employee List** table shows **Name**, **Salary**, and **Weekly Working Hour** rows. We will use 6 easy methods to **divide** for the entire row of this table. Here, we used Excel 365. You can use any available Excel version.

### Method-1: Using Divide Operator to Divide for Entire Row

In this method, we will use the **Divide** operator to calculate the per hour salary for the entire **Per Hour Salary **row. To do so, we have to divide **Salary** by **Weekly Working Hour**.

âž¤ First of all, we will type the following formula in cell** C8**.

`=C5/C6`

Here, it simply divides cell **C5** with cell **C6**.

âž¤ After that, press **ENTER**.

We can see the result in cell **C8**.

âž¤ We will drag the formula towards the right by using the **Fill Handle **tool.

We can see the result in the row **Per Hour Salary**.

**Read More:** **How to Divide One Column by Another in Excel (7 Quick Ways)**

### Method-2: Using Paste Special Option to Divide for Entire Row

In this method, we want to divide the entire row Salary with the **Constant Number** 100. We will use the** Paste Special **option for this case.

âž¤ First of all, we will right-click on cell **C8** > select **Copy** from the context menu.

âž¤ Afterward, we will select from cells **C5** to **G5** of the **Salary** column.

Now, we have to select **Paste Special**.

âž¤ We go to **Paste** click on the down arrow > select **Paste Special**.

A **Paste Special** window will appear.

âž¤ Select **Divide **> click **OK**.

Finally, we can see that the **Salary** row has been divided by 100.

**Read More: ****How to Divide Without Using a Function in Excel (with Quick Steps)**

### Method-3: Using QUOTIENT Function

In this method, we will calculate the per hour salary by using the** QUOTIENT **function.

âž¤ First of all, we have to type the following formula in cell **C8.**

`=QUOTIENT(C5,C6)`

Here, **C5** is the numerator and **C6 **is the denominator.

**QUOTIENT(C5,C6)** â†’ divides **C5** with **C6**.

âž¤ After that, press **ENTER**.

We can see the result in cell **C8**.

âž¤ Drag the formula towards the right with the **Fill Handle** tool.

Finally, we can see the per hour salary for an entire row.

**Read More: ****How to Divide with Decimals in Excel (5 Suitable Examples)**

### Method-4: Dividing a Range of Cells by a Constant Number

Here, we want to divide the entire** Salary **row with **Weekly Working Hour** 25.

âž¤ First of all, we have to write the following formula in cell **C8**.

`=C5/$D$6`

As we want to divide the entire **Salary** row by 25, we lock cell **D6**.

âž¤ Afterward, press **ENTER**.

We can see the result in cell **C8**.

âž¤ After that, we will drag the formula towards the right with the **Fill Handle** tool.

Finally, we can see the entire **Salary **row is divided by 25, and we can see the result in the **Divide by Constant Number** row.

**Read More: ****Division Formula with Absolute Reference in Excel**

### Method-5: Divide by Percentage

Here, we want to divide the entire **Salary** row by 10%. Letâ€™s see the procedure.

âž¤ First of all, we have to write the following formula in cell **C8**.

`=C5/10%`

âž¤ After that, press **ENTER**.

We can see the result in cell** C8**.

âž¤ Drag the formula towards the right using the **Fill Handle** tool.

Finally, we can see the** Salary **divided by 10% in the row **Divide by Percentage**.

**Read More: ****How to divide columns in Excel (Top 8 easy & quick ways)**

### Method-6: Divide Using Array Formula

Here, we will use an array formula to divide the entire **Salary** row by **Weekly Working Hour**.

âž¤ First of all, we will type the following formula in cell** C8**.

`=C5:G5/C6:G6`

âž¤ After that, press **CTRL+SHIFT+ENTER**.

We can see the result in cell **C8**.

âž¤ Drag the formula towards the right using the **Fill Handle** tool.

Finally, for the entire row, we can see the result in row **Using Array Formula**.

**Read More: ****How to Divide in Excel for Entire Column (7 Quick Tricks)**

## Conclusion

Here, we tried to show you 6 methods to divide in Excel for the entire row. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, feel free to know us in the comment section.