How to Find Percentage in Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to calculate and format percentages in Microsoft Excel.

Quick summary

To find a percentage in Microsoft Excel, you divide one value by another using a simple formula, then format the cell as a percentage using the Format Cells dialog. This method works for any dataset and lets you apply the result across multiple rows instantly.

Steps

Input the values you want to use for your percentage calculation into your spreadsheet.
In a new cell, type the division formula =Value1 / Value2 to calculate the ratio.
Press Enter to apply the formula and see the raw decimal result.
Right-click the result cell and select Format Cells from the context menu.
Go to Custom, enter 0% as the format code, then click OK to display the value as a percentage.
Drag the cell down to apply the same formula and formatting to all rows in your dataset.
The result will now display as a percentage across all selected cells.

📌 Why this matters

Knowing how to calculate and display percentages in Microsoft Excel is a foundational skill for anyone working with data, budgets, or performance metrics. Excel's built-in division formula combined with custom cell formatting makes it fast and accurate to convert raw numbers into meaningful percentage values. Whether you're tracking sales growth, grading scores, or analyzing survey results, mastering percentage formulas in Excel saves time and reduces manual errors. This step-by-step approach works across all modern versions of Excel and scales easily to large datasets.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel