Just like regular formatting, tables can improve the look and feel of your workbook, but theyll also help to organize your content and make your data easier to use.

Excel includes several tools and predefined table styles, allowing you to create tables quickly and easily.

Selecting a cell range to format as a table From the Home tab, click the Format as Table command in the Styles group.

Clicking the Format as Table command Select a table style from the drop-down menu.

Choosing a table style A dialog box will appear, confirming the selected cell range for the table.

If your table has headers, check the box next to My table has headers, then click OK.

Clicking OK The cell range will be formatted in the selected table style.

You can filter your data at any time using the drop-down arrows in the header cells.

The row or column will be included in the table automatically.

Typing a new row below an existing table Click, hold, and drag the bottom-right corner of the table to create additional rows or columns.

Clicking the Design tab Locate the Table Styles group, then click the More drop-down arrow to see all available table styles.

There are several options: Header Row, Total Row, Banded Rows, First Column, Last Column, Banded Columns, and Filter Button.

From the Design tab, check or uncheck the desired options in the Table Style Options group.

Checking the Total Row option The table style will be modified.

In our example, a new row has been added to the table with a formula that will automatically calculate the total value of the cells in column D.

You may need to experiment with a few different options to find the exact style you want.

You can remove a table from the workbook while still preserving the tables formatting elements, like font and cell color.

Clicking Convert to Range A dialog box will appear.

Click Yes. Removing a table The range will no longer be a table, but the cells will retain their data and formatting.

Design Tab In Excel 2013