Formatting Cells

Basic formatting in Excel can customize the look and feel of your Excel spreadsheet. Learn about formatting cells in Excel here.

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.
    Screenshot of Excel 2013Selecting a cell range
  2. Click the Cell Styles command on the Home tab, then choose the desired style from the drop-down menu. In our example, we'll choose Accent 1.
    Screenshot of Excel 2013Choosing a cell style
  3. The selected cell style will appear.

    Screenshot of Excel 2013The new cell style

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.