Excel Cell Styles

Instead of formatting cells manually, you can use Excel’s predesigned cell styles. Cell styles are a quick way to include professional formatting for different parts of your workbook, such as titles and headers.

To apply a cell style:

In our example, we’ll apply a new cell style to our existing title and header cells.

  1. Select the cell(s) you want to modify.
  • Click the Cell Styles command on the Home tab, then choose the desired style from the drop-down menu.
  • The selected cell style will appear.

Applying a cell style will replace any existing cell formatting except for text alignment. You may not want to use cell styles if you’ve already added a lot of formatting to your workbook.

Start Quiz
Course Quiz Navigation
Complete all questions in quiz to move to the next lesson.