Excel > Excel 2007 Foundation > Formatting a worksheet

Cell Styles

Cell Styles contain preset formatting that can be applied to a cell or range of cells on the click of a button. This preset formatting can include the font, cell shading, alignment and more.

Excel comes with several in-built cell styles for you to choose from. It is also possible to create your own or modify the existing styles.

Applying a cell style

  1. Select the cell(s) to format
  2. Click the Cell Styles button in the Styles group of the Home tab
  3. Applying a cell style

  4. Select the cell style of your choice

As you hover over the styles, Live Preview will allow you to see how the cell(s) look before making your selection

Removing a cell style

  1. Select the cell(s) with the style you wish to remove
  2. Click the Cell Styles button in the Styles group of the Home tab
  3. Select Normal from the list of styles

Modify a cell style

  1. Click the Cell Styles button in the Styles group of the Home tab
  2. Right click on the cell style you wish to modify and click Modify
  3. Modifying a cell style

  4. Select the formatting options you want to use for the style
  5. Formatting the cell style
  6. Click Format and change the formatting items as desired and click Ok

Creating a new style

  1. Click the Cell Styles button in the Styles group of the Home tab
  2. Click New Cell Style
  3. Enter a name for the new style and select the formatting options you want to use
  4. Create a new cell style

  5. Click Format and change the formatting items as desired and click Ok

Cell style can be deleted by right clicking on the cell style from the list and clicking Delete.

Follow us on

Facebook  Twitter  You Tube