On the Home tab, select Cell Styles, and then select Normal. Select a cell that is formatted with the style that you want to remove. Hold down CONTROL, click the style that you want to change, and then click Modify. However, you can change it back to the original formatting. There is no undo command for changing a cell style. In the Modify Cell Style dialog box, under Style Property, select or clear the check boxes to choose the style formatting, and then click OK.Ĭhanging a cell style affects all cells that have that style and are in the workbook where you change the style. Hold down CONTROL, click the style that you want, and then click Duplicate. In the New Cell Style dialog box, under Style Property, select or clear the check boxes to choose the style formatting, and then click OK.Ĭreate a custom cell style based on an existing style 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.
