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 in Excel 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

## Download Practice Workbook

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

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

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

**Read More:** **Division formula in Excel for multiple 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 divide columns in Excel (Top 8 easy & quick ways)**

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

** **

**Read More:** **How to Add and Then Divide in Excel (5 Suitable Examples)**

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

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

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

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

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

Donâ€™t forget to check our website **Exceldemy.com** for various Excel-related problems and solutions. Keep learning new methods and keep growing!

## Related Articles

**How to Divide Without Using a Function in Excel (with Quick Steps)****Divide for Entire Row in Excel (6 Simple Methods)****How to Divide with Decimals in Excel (5 Suitable Examples)****[Fixed] Division Formula Not Working in Excel (6 Possible Solutions)****How to Divide a Number by a Percentage in Excel (3 Suitable Examples)**