How To Percentage In Excel

Whether you’re a student, a business professional, or someone who loves to play with numbers, knowing how to calculate percentages in Excel is a useful skill. This blog post will guide you through the process, making it as simple and straightforward as possible.

Step 1: Understanding the Basics of Percentage

A percentage is a ratio expressed as a fraction of 100. It is often used to compare quantities. In Excel, you can calculate percentages in various ways depending on the context and data available. The most common formula is: (Part/Total)*100.

Step 2: Enter Your Data

Populate your Excel spreadsheet with the data you want to use. Let’s assume that you have a list of students and their scores in a test. We’ll find out the percentage score of each student. Create two columns: one for the students’ names and the other for their scores.

Step 3: Calculate the Percentage

Let’s assume the total score is 50 points. To find the percentage score of each student, divide the score of each student by the total score and multiply by 100.

Using the formula:

(Score/Total Score)*100

Now, to implement this in Excel, you need to translate it to Excel’s language. Here’s how:

    = (B2/50) * 100

Here, B2 points to the cell containing the student’s score. The divisor 50 is the total score. The result will give you the percentage score of the student.

Step 4: Apply the Formula to All Rows

After applying the formula for the first student, you can copy the formula to all other rows. You can do this by clicking on the lower right corner of the cell (where you see a small box) and dragging it down to all other rows.

And voila! You have successfully calculated percentages in Excel.


Calculating percentages in Excel is easy once you understand the basics. It’s one of the many ways Excel helps to simplify numeric calculations, and it’s a technique that comes in handy in many situations. Keep practicing, and soon you’ll be able to perform these kinds of calculations with ease.