In the Style name box, type a name for the new style.Ĭlick each tab, select the formatting that you want, and then click OK.
On the Home tab, click Cell Styles, and then click New 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.
On the Home tab, click Cell Styles, and then select the style that you want. Select the cells that you want to format.