Excel Style Manager - New design for Excel - Online Help

Excel Style Manager - New design, formats, fonts, borders, patterns

Style Manager for Microsoft® Excel®

For Microsoft Excel 2007, Excel 2003, Excel XP (2002), Excel 2000.

How to work with Style Manager for Microsoft Excel

• How show and hide the Style Manager pane
• How to add a new style to the collection
• How to apply a style to the cell(s)
• How to rename a style in styles collection
• How to delete a style from the collection
• How to move a style in your styles tree
• How to create a new folder in your styles collection
• How to adjust the width of the Style Manager pane

Back to Style Manager overview

How show and hide Style Manager pane

You can show / hide the Style Manager pane by doing one of the following:

• Click on its icon .
• Go to Excel menu -> Ablebits.com -> Style Manager for Excel (in Excel 2003 - 2000 only).
• Press the Ctrl+Shift+S hotkey.

How to add a new style to the collection

1. Open the Style Manager pane (see how to show / hide the pane).
2. In your Excel worksheet, select the cell whose format you want to add to your style collection.
3. Click the "Add style" button in the Style Manager toolbar.
4. Enter a new style name that will be added to your style collection.
5. Click the OK button.

How to apply a style to the cell(s)

1. In your Excel worksheet select the cell(s) that you want to format.
2. Open the Style Manager pane if its hidden (see how to show / hide the pane).
3. Double-click on the style that you want to apply or select the style and click the "Apply style" button in the Style Manager toolbar.

How to rename a style in the styles collection

1. Select the style that you want to rename in the style tree.
2. Press F2 or click on the "Rename" button in the Style Manager toolbar.
3. Enter a new style name and press "Enter".

How to delete a style from the collection

1. Select the style that you want to delete from the style tree.
2. Press Shift+Del or click on the "Rename" button in the Style Manager toolbar.
3. Confirm than your really want to delete the style.

How to move a style in your styles tree

Just select the style you need and drag it to the wanted group.

How to create a new folder in your styles collection

1. Open the Style Manager pane (see how to show / hide the pane).
2. Select the location in the style tree where you want to create a new folder.
3. Select the New Folder item in the popup menu or press F7.
4. Enter a new folder name and press "Enter".

How to adjust the width of the Style Manager pane

1. Open the Style Manager pane (see how to show / hide the pane).
2. Move the cursor to the border between the Style Manager pane and the Excel worksheet. The cursor will look like this
3. Press the left mouse button and drag the pane to the needed width.
4. Release the left mouse button.