Cloud Training (Online)




Cell Styles in Excel

In this article, you’ll learn about Cell Styles in Microsoft Excel and How to use them effectively.

What is Cell Styles?

It is just a collection of options to change properties such as the font size and color, font style, data format, tab color, cell borders, and its protection.

Microsoft also allows you to customize the cells on our own i.e, apart from the features provided you can also create your cell style.


How to use Cell Styles in Excel?

  • Select a range of cells or a cell.
Cell Styles in Excel
  • In the Home tab under the Styles group, you’ll find the Cell Styles option. Click on it.
Cell Styles in Excel
  • A drop-down list appears.
Cell Styles in Excel
  • You can choose any one of the styles you want. By clicking on it.
Cell Styles in Excel
  • Else you can create your own cell style by clicking on the New Cell style in the dropdown list of Cell Styles.
Cell Styles in Excel
  • A new dialog box will open up. Here type the cell name of the  Style that you are going to create in the Name field.
Cell Styles in Excel
  • Click on Format.
  • Then check the boxes under the Styles Includes.
Cell Styles in Excel
  • After checking the boxes which represent the features you want. Click on OK.
Cell Styles in Excel

If you again go back to the Cell Styles option in the Home tab, you’ll find the cell style you created. Just click on it to apply it.