Styles in Excel
A convenient method to create a new style is by selecting a cell which has all formatting options in place which you want to incorporate in the new style. Select the cell and choose Format, Style... from the menu (for Excel 2010 (2007, 2013): Click the Home tab, click the Cell Styles button in the Styles group).
The Styles dialog screen.
To create a new style, simply type its name in the box "Style name". By default, all formatting elements are checked. Remove the checkmarks for the formatting elements you want to omit from the style you are creating (The dialog shown above has the Number and Alignment elements turned off).
Use the "Modify..." button to adjust the elements to your needs. Excel will show the standard "Format cells " dialog screen:
The format cells dialog screen, as shown after clicking Modify... on the Style dialog.
Note, that the elements in the Style dialog are identical to the tabs on the Format Cells dialog.
Note: As soon as you change a formatting element on a tab that was not selected on the Style dialog, Excel will automatically check that element for you; it will become part of that style.
In Excel 2003, after modifying all settings you have two options to "save" the modifications to the style:
- By clicking "OK"; The currently selected (or added) style will be modified/created and the currently selected cells will have that style applied.
- By clicking "Add" and subsequently clicking Close: The style will be updated/added, but not applied to the current selection.
In short: If you want to modify a style and apply it to the current selection, click OK. Otherwise, click Add and then Close.
Excel 2010 (and 2013 and 2007) defaults to the second option: the style dialog will update/add the style, but the style will not be applied to the selected cells.