Table Styles

 

Quickly format a range of cells by choosing a table style. You can also create your own table style. Quickly format a cell by choosing a cell style.

1. Click any single cell inside the data set.

Data Set in Excel

2. On the Home tab, in the Styles group, click Format as Table, and choose a table style.

Choose a Table Style

Note: click New Table Style to create your own table style or right click a table style and click Duplicate to create a new table style that is similar to an existing one. Modifying a custom table style affects all tables in a workbook that use that table style. This can save a lot of time.

3. Excel automatically selects the data for you. Check 'My table has headers' and click on OK.

Select Data

Result. This is another way to insert a table.

Table Style

To convert this table back to a normal range of cells (and keep the formatting), execute the following steps.

4. On the Design tab, in the Tools group, click Convert to Range.

Convert to Range

Result. A nicely formatted range of cells.

Formatted Range of Cells

Note: to remove the table style, select the range of cells, on the Home tab, in the Styles group, click Normal.