Table and Cell Styles

Learning Objectives

  • Apply table styles.
  • Apply cell styles.

Like any Microsoft program, Excel will default to certain fonts, texts, and styles when you create a new worksheet. It is also very easy within Excel to format individual cells with cell styles or multiple cells with a table style. Not only can formatting help make your tables more attractive, but it can also help indicate information about the contents, such as whether the data in a cell reaches a target goal.

Table Styles

One very common task in Excel is to format a table with a particular style. The controls for table styles are found in the Styles group of the ribbon under the Home tab.A blank Microsoft Excel sheet is open. There is a large green arrow pointing toward where the different style options are.

There are many default table styles within Excel, as shown in the screenshot below. Among other uses, styles let you apply color schemes to tables that can make them more readable. In order to apply a particular table style:

  1. Select all the cells that belong in your table.
  2. Click on the “Format as Table” button.
  3. Choose which table style to apply.
A Microsoft Excel sheet is open with text in cells A1 through C3. There are three boxes each a different color matched with a number. The first box is green and shows how you can select all the cells that belong in your table that you are creating. The second is a pink box demonstrating where the format as a table button is. The third is from a dropdown menu from the format as a table button and shows which table style to apply.

Select all the cells that belong in your table. Click on the “Format as Table” button. Choose which table style to apply.

In the screenshot example, each column is a particular type of information (Last name, First Name, Address). These are known as headers. When applying the table style, be sure to check the box if your table has headers that you have already entered.

Practice Question

 

A Microsoft Excel sheet is open with text in cells A1 through C3. The format as a table dialog box has been opened. There is a green arrow pointing to the option on the dialog box to ensure that the table that is being create has headers.

Practice Question

 

Your final table would look something like the table below using the options shown in the screenshots.

A Microsoft Excel sheet is open with text in cells A1 through C3. Row 1 from A through C has become the header for a table.

Cell Styles

You can also apply a style to a cell or series of cells. There are many default cell styles within Excel.A blank Microsoft Excel document is open. A green arrow is pointing towards a green box around the styles section on the home tab. The arrow is pointing specifically at the cell styles option.

In order to apply a particular cell style:

  1. Select the cell(s) you wish to format.
  2. Click on the appropriate style for your cell.

Practice Question

In the screenshot below, two cells have a style applied.

  1. “Good” cell indicates the data in that cell is good or correct.
  2. “Check” cell indicates you may need to verify the information in that cell.
A Microsoft Excel sheet is open with text in cells A1 through C3. There is a green arrow pointing at cell C2 where the style of the text in the cell has become green. There is an orange arrow pointing at cell C3 where the cell has been styled with a gray background.

Practice Question