Working with Styles
Styles can be applied both to tables and to individual or groups of cells. Styles can also be applied to charts and illustrations, though applying styles to charts and illustrations is not covered in this lesson.
Applying Styles to Tables
Converting Data to a Table
If your data is not already formatted as a table, then convert it to a table:
- Select the cells you wish to convert to a table. If you select just one cell, then Excel will guess which other cells you wish to include and will ask you to verify.
- On the Home tab, in the Styles group, click the Format as Table command:
- Select one of the options from the drop-down list:
- In the Format As Table dialog box, verify which cells contain the data for the table and click OK:
Note: Lists can also be converted to tables using the Table command on the Insert tab. This is covered in the lesson on working with lists.
Changing the Style Applied to Your Table
When you select a cell in a table, the Table Tools Design tab appears:
To change the style applied to your table:
- Select any cell in your table.
- Click the More arrow in the Table Styles group to see all the styles available:
- Move your mouse over the many different styles available in the Table Styles group to see what your table will look like if you select that style:
- Select one of the styles by clicking on it.
Applying Styles to Cells
To apply a style to a cell or group of cells:
- Select the cell or cells to which you wish to apply a style.
- On the Home tab, in the Styles group, click the Cell Styles command:
- Move your mouse over the many different styles available in the drop-down list to see what your cell(s) will look like if you select that style:
- Select one of the options from the drop-down list by clicking on it.
Copy Styles from Template to Template
When you save a style, it is then available in the Custom styles category, appearing on the Cell Styles menu when a worksheet contains relevant cells.