Excel.TableStyles.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
TableStyles object (Excel)	vbaxl10.chm840072	vbaxl10.chm840072	Excel.TableStyles	952da370-51cb-b1e0-a413-15cb558099b5	04/02/2019	medium

TableStyles object (Excel)

Represents styles that can be applied to a table.

Remarks

Table styles provide a way to format an entire table or PivotTable. Table styles replace the existing auto format feature for formatting an entire table.

Table styles differ from auto format in the following ways:

• You can create and reuse custom table styles.

• Table styles work with themes.

• Changing the document theme color scheme and/or font scheme will change the look of the built-in table styles.

• Table styles can reapply styles to objects such as PivotTables and tables as the object changes. The tables will remember the style applied to them and will re-display appropriately when cells are added, removed, hidden, and shown.

• Table styles have a visual user interface in the ribbon.

Methods

• Add
• Item

Properties

• Application
• Count
• Creator
• Parent

See also

• Excel Object Model Reference

[!includeSupport and feedback]