If you are looking for some special tricks to divide in Excel to get a percentage, youâ€™ve come to the right place. In Microsoft Excel, there are numerous ways to divide to get a percentage. In this article, weâ€™ll discuss five ways to divide in Excel to get a percentage. Letâ€™s follow the complete guide to learn all of this.

**Table of Contents**hide

## How to Divide a Value to Get a Percentage in Excel: 5 Suitable Examples

We will use five effective and tricky ways to divide in Excel to get a percentage in the following section. This section provides extensive details in five ways. You should learn and apply all of these, as they improve your thinking capability and Excel knowledge.

### 1. Divide by Copying a Formula to Get a Percentage in Excel

It is the quickest and simplest way to divide in Excel to get a percentage. Here, we have a dataset containing different student marks. We must follow the following process if we wish to calculate each studentâ€™s percentage of marks.

**ðŸ“Œ Steps:**

- Firstly, we will use the following formula in the cell
**F5:**

`=(C5+D5)/E5`

Here, cells **C5, **and **D5** show the marks of each student. The Total Marks are shown in cell **E5.**

- Press
**Enter**.

- Next, go to the
**Home**tab, and select the**Percentage**symbol under the**Number**group.

- Consequently, we can convert the data into percentage terms.

- After that, drag down or double-click the
**Fill Handle**icon to use Excelâ€™s**AutoFillÂ**feature. - Finally, we will get the percentage values in the corresponding cells.

### 2. Divide Using Array Formula in Excel

Here, we use another effective way to divide in Excel to get a percentage using array formulas. You have to follow the following steps to do this.

**ðŸ“Œ Steps:**

- Firstly, we will use the following formula in the cell
**F5:**

`=(C5:C10+D5:D10)/E5:E10`

Here, the range of cells **C5:C10, **and** D5:D10** show the marks of each student. The total marks are shown in the range of cells **E5:E10.**

- PressÂ
**Enter.**

- Next, go to the
**Home**tab, and select the**Percentage**symbol under the**Number**group.

- Finally, we will get the percentage values in the corresponding cells.

**Read More: **How to Apply Percentage Formula in Excel for Marksheet

### 3. Divide Using a Constant Number to Get a Percentage

Here, we use another effective way to divide in Excel to get a percentage. We are going to divide the columnâ€™s values by a constant number. You have to follow the following steps to do this.

**ðŸ“Œ Steps:**

- Firstly, we will use the following formula in the cell
**F5:**

`=(C5+D5)/200`

Here, cells **C5, **and** D5** show the marks of each student. The Total mark is 200**.**

- PressÂ
**Enter.**

- Next, go to the
**Home**tab, and select the**Percentage**symbol under the**Number**group.

- Consequently, we can convert the data into percentage terms.

- After that, drag down or double-click the
**Fill Handle**to use Excelâ€™s**AutoFillÂ**feature. - Finally, we will get the percentage values in the corresponding cells.

** **

### 4. Using Absolute Cell Reference in Excel

Now, we use another quickest way to divide in Excel to get a percentage. We are going to divide the columnâ€™s values by a constant number using cell absolute reference to get a percentage. You have to follow the following steps to do this.

**ðŸ“Œ Steps:**

- Firstly, we will use the following formula in the cell
**F5:**

`=(C5+D5)/$E$7`

Here, cells **C5, **and** D5** show the marks of each student. The Total marks are shown in cell **E7.**

- Press
**Enter.**

- Next, go to the
**Home**tab, and select the**Percentage**symbol under the**Number**group.

- Consequently, we can convert the data into percentage terms.

- After that, drag down or double-click the
**Fill Handle**icon to use Excelâ€™s**AutoFillÂ**feature. - Finally, we will get the percentage values in the corresponding cells.

### 5. Divide by Utilizing Paste Special Command to Get a Percentage

Now, we use another quickest and most effective way to divide in Excel to get a percentage. We are going to divide the column values by a constant number using the paste special option to get a percentage. You have to follow the following steps to do this.

**ðŸ“Œ Steps:**

- Firstly, select the range of the data
**C5:C10**and press**â€˜Ctrl+Câ€™.**

- Then, on the percentage column press
**â€˜****Ctrl+Vâ€™**or you have to right-click and select the appropriate paste type like the following.

- The percentage column will look like this after pasting the data.

- Copy the cell
**D7**by pressing**â€˜****Ctrl+Câ€™.**

- Next, select the range of the data
**C5:C10**and you have to right-click. Then click on the**Paste SpecialÂ**option.

- When the
**Paste Special**dialog box appears, click on the**Divide**option under the**Operation.**Click on**OK**.

- As a consequence, you will get the following output.

- Next, go to the
**Home**tab, and select the**Percentage**symbol under the**Number**group.

- Finally, we will get the percentage values like the following.

**Download Practice Workbook**

Download this practice workbook to exercise while you are reading this article.

## Conclusion

Thatâ€™s the end of todayâ€™s session. I strongly believe that from now you may be able to divide in Excel to get a percentage. If you have any queries or recommendations, please share them in the comments section below.

## Related Articles

- How to Calculate Percentage of Total in Excel
- How to Convert Number to Percentage in Excel
- How to Calculate Reverse Percentage in Excel
- How to Convert Percentage to Number in Excel
- How to Convert Percentage to Whole Number in Excel
- How to Show One Number as a Percentage of Another in Excel
- How to Add a Percentage to a Number in Excel
- Make an Excel Spreadsheet Automatically Calculate Percentage
- Convert Number to Percentage Without Multiplying by 100 in Excel