Table styles are a big part of formatting tables in Excel. In fact, Excel ships with over 50 built-in styles. Table styles apply a lot of formatting, but not all formatting. You can use table styles to apply border, fill, font formatting, and things like zebra striping. However, you can’t use table styles to apply number formatting, alignment, or conditional formatting. Every table has a style applied by default. The applied style will be highlighted in the table styles window. Whenever a table is selected, you’ll see some basic style options on the Design tab of the Table Tools ribbon. The checkboxes here toggle the visibility of table elements only. The look and feel of each element is defined in the currently applied table style. Although Excel comes with a large number of built-in styles, you can also create your own table styles. You can even set a custom style as the default style in a workbook, so that new tables automatically use the style. The videos in this section will cover all these topics in more detail.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.