Banded rows and banded columns - alternate row or column shading, respectively.Total row - add the totals row at the end of the table with a list of functions for each total row cell.Header row - display or hide the table headers.You can think of an Excel table style as a formatting template that automatically applies certain formats to table rows and columns, headers and totals row.Īpart from table formatting, you can use the Table Style Options to format the following table elements: It appears under the Table Tools contextual tab, as soon as you click any cell within a table.Īs you can see on the screenshot above, the Table Styles gallery provides a collection of 50+ inbuilt styles grouped into Light, Medium, and Dark categories.

The Design tab is the starting point to work with Excel table styles. If you don't like the default table format, you can easily change it by selecting any of the inbuilt Table Styles on the Design tab.

A newly inserted table comes already formatted with font and background colors, banded rows, borders, and so on. Excel tables make it a lot easier to view and manage data by providing a handful of special features such as integrated filter and sort options, calculated columns, structured references, total row, etc.īy converting data to an Excel table, you also get a head start on the formatting.

Display tabular data without tables