Apply, create, or remove a cell style in Excel for Mac

A style is a set of formatting characteristics, such as font name, size, color, alignment, and spacing. When you want to apply more than one format at a time to a cell or range of cells, it is easiest to apply a style. Styles also help you keep formatting consistent throughout a workbook.

Excel includes several built-in styles that you can apply or change. You can also create your own custom styles.

Apply a cell style

1. Select the cells that you want to format.
2. On the Home tab, select Cell Styles, and then select the style that you want.
   

Create a custom cell style

The built-in styles in Excel can't cover every formatting need, but it is easy to create a special dramatic style that is appropriate for a total that is past due, or a friendly one for a household chore list.

1. On the Home tab, select Cell Styles, and then select New Cell Style.
   
2. In the Style name box, type a name for the new style.
3. Select Format.
4. Select each tab, select the formatting that you want, and then select OK.
5. In the New Cell Style dialog box, under Style Property, select or clear the check boxes to choose the style formatting, and then select OK.

Create a custom cell style based on an existing style

1. On the Home tab, select Cell Styles.
   
2. Hold down CONTROL , select the style that you want, and then select Duplicate.
3. In the Style name box, type a name for the new style.
4. Select Format.
5. Select each tab, select the formatting that you want, and then select OK.
6. In the Modify Cell Style dialog box, under Style Property, select or clear the check boxes to choose the style formatting, and then select OK.

Change an existing cell style

Changing a cell style affects all cells that have that style and are in the workbook where you change the style. There is no undo command for changing a cell style. However, you can change it back to the original formatting.

1. On the Home tab, select Cell Styles.
   
2. Hold down CONTROL , select the style that you want to change, and then select Modify.
3. Select Format.
4. Select each tab, select the formatting that you want, and then select OK.
5. In the Modify Cell Style dialog box, under Style Property, select or clear the check boxes to choose the style formatting, and then select OK.

Remove a cell style from a cell

1. Select a cell that is formatted with the style that you want to remove.
2. On the Home tab, select Cell Styles, and then select Normal.
   

Delete a cell style

You can delete built-in and custom styles from the list of available styles for a specific workbook.

1. On the Home tab, select Cell Styles.
   

2. Hold down CONTROL , select the style, and then select Delete.

   Note

   You can't remove the Normal style.