How to: Control Style Options

Jun 07, 2019
4 minutes to read

A pivot table style consists of a collection of table style elements (TableStyleElement), each of which specifies formatting for a particular element of a pivot table. The TableStyleElementType enumerator lists supported table style element types. The PivotTable object provides specific properties that allow you to configure PivotTable style options by specifying table elements to be formatted as defined by the corresponding elements of the applied pivot table style.

Format Row Headers
Format Column Headers
Apply Banded Row Formatting
Apply Banded Column Formatting