How to Divide for Entire Row in Excel (6 Simple Methods)

Method 1 – Using Divide Operator to Divide for Entire Row

➤ Enter the following formula in cell C8.

=C5/C6

It divides cell C5 with cell C6.

➤ Press ENTER.

The result will be displayed in cell C8.

➤ Drag the formula towards the right by using the Fill Handle tool.

The result will show in the row Per Hour Salary.

How to Divide for Entire Row in Excel

Read More: How to Divide in Excel for Entire Column


Method 2 – Using Paste Special Option to Divide for Entire Row

➤ Right-click on cell C8 > select Copy from the context menu.

➤ Select cells C5 to G5 of the Salary column.

➤ Go to Paste click on the down arrow > select Paste Special.

A Paste Special window will open.

➤ Select Divide > click OK.

The Salary row will be divided by 100.

How to Divide for Entire Row in Excel

Read More: Division Formula in Excel for Multiple Cells


Method 3 – Using QUOTIENT Function

➤ Enter the following formula in cell C8.

=QUOTIENT(C5,C6)

C5 is the numerator and C6 is the denominator.

QUOTIENT(C5,C6) → divides C5 with C6.

➤ Press ENTER.

How to Divide for Entire Row in Excel

➤ Drag the formula towards the right with the Fill Handle tool.

It will display the per hour salary for an entire row.

How to Divide for Entire Row in Excel


Method 4 – Dividing a Range of Cells by a Constant Number

Divide the entire Salary row with Weekly Working Hour 25.

➤ Enter the following formula in cell C8.

=C5/$D$6

We want to divide the entire Salary row by 25, so we lock cell D6.

➤Press ENTER.

How to Divide for Entire Row in Excel

The result will be displayed in cell C8.

➤ Drag the formula towards the right with the Fill Handle tool.

The entire Salary row will be divided by 25, and the result will be displayed in the Divide by Constant Number row.

Read More: How to Divide a Group of Cells by a Number in Excel


Method 5 – Divide by Percentage

Divide the entire Salary row by 10%.

➤ Enter the following formula in cell C8.

=C5/10%

➤ Press ENTER.

➤ Drag the formula towards the right using the Fill Handle tool.

The Salary will be divided by 10% and the result displayed in the row Divide by Percentage.

How to Divide for Entire Row in Excel


Method 6 – Divide Using Array Formula

We will use an array formula to divide the entire Salary row by Weekly Working Hour.

➤ Enter the following formula in cell C8.

=C5:G5/C6:G6

➤ Press CTRL+SHIFT+ENTER.

➤ Drag the formula towards the right using the Fill Handle tool.

 

How to Divide for Entire Row in Excel


Download Workbook


Related Articles


<< Go Back to Divide in Excel | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of NAME from Bangladesh University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also interested... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo