Cell Styles in Excel | CustomGuide

Cell Styles in Excel

How to Apply and Remove Cell Styles in Excel

Cell Styles in Excel

Styles contain preset font formatting, cell shading, numbering, borders, and other formatting options that can be applied to a cell or cell range all at once. This is a convenient and easy way to quickly apply complex formatting.

Apply a Cell Style

  1. Select the cell(s) you want to format.
  2. Click the Cell Styles button on the Home tab.

    Hover your mouse over a style to preview how it will look before selecting it.

  3. Select the cell(s) you want to format.
    Apply and Remove Cell Styles

Apply a Cell Style

If you decide you no longer need the style applied to the cells, you can remove it.

  1. Select the cells that have the style applied.
  2. Click the Cell Styles button on the Home tab.
  3. Select Normal.
  4. Apply and Remove Cell Styles