1. Computing

Create a Custom Formatting Style in Excel

Save Formatting Options for Future Use

By

Create a Custom Formatting Style in Excel

Create a Custom Formatting Style in Excel

© Ted French

A style in Excel 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 Tutorial: Copy a Formatting Style in Excel .

Steps to Creating a Custom Formatting Style in Excel

  1. Select a single worksheet 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.

©2014 About.com. All rights reserved.