Show TOC

To create a style setLocate this document in the navigation structure

Context

Based on availabe cell styles, you can define a new style set. You change the cell styles according to your needs using the Microsoft Excel style functionality. You can then save the new defined styles in a style set.

Procedure

  1. On the Home tab, in the Styles group, choose Cell Styles.
    Note In Microsoft Excel 2003, you can find the cell styles by choosing Start of the navigation path Format Next navigation step Styles End of the navigation path in the menu.
    The available cell styles are listed.
  2. Modify the existing cell styles or create new ones according to your needs.
  3. On the Analysis tab, in the Settings group, choose Start of the navigation path Styles Next navigation step Save Style Set... End of the navigation path.
    The Save Style Set dialog box appears.
  4. Enter a Style Set Name.
  5. Select the Set as Default check box if the style set should be applied as default in your workbooks. The default style set is used when you open a new workbook and insert a data source.
  6. Press OK.

Results

The new defined style set is created and availalbe in the list of style sets that can be applied to a workbook.