Create a New Style in Excel

If you find that you keep applying the same formatting over and over, create a style with that formatting so you can apply those formatting settings with one click.

Create a New Style

The easiest way to create a style is to do so from a cell that already has the formatting you want to capture.

  1. Select the cell that has the formatting you want to use for the new style.
  2. Click the Cell Styles button on the Home tab.
  3. Select New Cell Style.
    Create and Modify Cell Styles

    The Style dialog box opens and the formatting from the selected cell is captured.

  4. Enter a name in the Style name field.
  5. Click OK.
    Create and Modify Cell Styles

The style is now saved and can be used in any Excel worksheet.

Cell styles are associated with the theme that is being used for the workbook. If you switch to a new theme, the cell styles will update to match it.

Modify a Style

If you decide you need to change an existing style, you can easily make modifications. Any updates you make will automatically be reflected in any cells that have the style applied.

  1. Click the Cell Styles button.
  2. Right-click the cell style you want to modify.
  3. Select Modify.
    Create and Modify Cell Styles

    To duplicate a style before making changes, select Duplicate from the menu instead.

  4. Click the Format button.
    Create and Modify Cell Styles
  5. Select the formatting options you want to use.
  6. Click OK.
    Create and Modify Cell Styles
  7. Click OK again.
    Create and Modify Cell Styles

    The style is updated and any cells with the style applied are automatically updated.

    To remove a cell style from all cells and delete the cell style itself, click the Cell Styles button on the Home tab. Then right-click the style and select Delete.

Excel Cheat Sheet

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.