1 Create A Table

Using the locations and data, create a table with headers consisting of the data in row 2.

1. Select cells A2 through E11
2. Click the Insert tab
3. In the Tables group, click Table
4. Ensure the My table has headers check box is selected
5. Click the OK button

2 Apply A Table Style

Apply the Blue, Table Style Medium 20 style to the table on the current worksheet.

1. Click anywhere within the table
2. Click the Design tab under Table Tools
3. In the Table Styles group, click the Table Styles drop-down arrow
4. In the Medium section, click the Blue, Table Style Medium 20 style

3 ​Convert a Table to a Cell Range

Convert the table on this worksheet to a range of cells.

1. Click anywhere within the table
2. Click the Design tab under Table Tools
3. In the Tools group, click Convert to Range