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.
