Back
Percentages in Excel
> ... Math > Excel > Percentages in Excel
Percentages in Excel

There are many ways to format a cell as a percentage in Excel. This lesson goes over the following five ways.

• Number and % symbol
• Format Cell
• % Style Button
• Format Several Cells At Once

## Number and % symbol

Type a number into the cell.

At the end of the number, type the % symbol.

Press Enter.

This will automatically tell Excel that the number you typed is a percentage, and it will format the cell as a percentage cell. Any number you put in the cell thereafter will appear with a % symbol.

## Format Cell

Right click on the cell you want to display as a percentage.

A menu will appear. Select the Format Cell item on the list.

This will bring up the Format Cell window.

Under the Numbers tab, you will see a category list of all the number formats you can assign to a cell. Select the Percentage category.

Notice that you can change the number of decimal places displayed in the Decimal places box. You can use this box to adjust the decimal places no matter what approach you originally used to format the cell as a percentage.

In the Home Toolbar, you will find the number format menu box. The default in the box says General.

Select the arrow to the right of the box to view the other options. Select the Percentage item on the list.

This will automatically format the cell as a percentage with two places after the decimal point. You can adjust the places after the decimal point using the format cell technique explained above.

## % Style Button

Select the cell you want to format by clicking within it.

Select the Percent Style button in the Home Toolbar. It is a button with a % symbol on it.

This will format the cell to display as a percentage.

## Format Several Cells At Once

Highlight all the cells you want to format as a percentage.

Example image:

Once the cells are selected, use either the Format Cell, Number Format Menu, or Percent Style button technique to format the cells as percentages.

## Need More Help?

1. Study other Math Lessons in the Resource Center.
2. Visit the Online Tutoring Resources in the Resource Center.