Excel Tutorials: How to Create a Formatting Style in Excel 2007

For more Excel tips and tricks go to my static page:  Excel Tutorials and Tricks Series.

A style in Excel 2007 is a combination of formatting options that is named and saved as part of your current spreadsheet file. The new style can then quickly be applied to data and cells in the spreadsheet.
Related article: Copy a Formatting Style in Excel 2007.

Steps to Create a Custom Formatting Style in Excel 2007

1. Select a single spreadsheet cell.
   
   
2. Apply all desired formatting options to this cell.
   
   
3. Click the Home tab on the ribbon.
   
   
4. Click on the Cell Styles option on the ribbon to open the Cell Styles gallery.
   
   
5. Click on the New cell styles option at the bottom of the gallery to open the Style dialog box.
   
   
6. Type a name for the new style in the Style name box.
   
   
7. The formatting options already applied to the selected cell will be listed in the dialog box.

To make additional formatting options or modify the current choices:

1. Click on the Format button in the Style dialog box to open the Format Cells dialog box.
   
   
2. Click on the appropriate tab in the dialog box.
   
   
3. Make the desired changes.
   
   
4. Click OK to close the Format Cells dialog box.
   
   
5. Click OK to close the Style dialog box.
   
   
6. The new style is added to the top of the Cell Styles gallery

To apply the new style to cells in your spreadsheet

1. Select the desired cells.
   
   
2. Click the Home tab on the ribbon.
   
   
3. Click on the Cell Styles option on the ribbon to open the Cell Styles gallery.
   
   
4. Click on the new style name at the top of the gallery.
   
   
5. The style's formatting is immediately applied to the selected cells.