xlTableStyleElementType

Specifies the table style element used.

xlBlankRowBlank row (19)
xlColumnStripe1Column Stripe1 (7)
xlColumnStripe2Column Stripe2 (8)
xlColumnSubheading1Column Subheading1 (20)
xlColumnSubheading2Column Subheading2 (21)
xlColumnSubheading3Column Subheading3 (22)
xlFirstColumnFirst column (3)
xlFirstHeaderCellFirst header cell (9)
xlFirstTotalCellFirst total cell (11)
xlGrandTotalColumnGrand total column (4)
xlGrandTotalRowGrand total row (2)
xlHeaderRowHeader row (1)
xlLastColumnLast column (4)
xlLastHeaderCellLast header cell (10)
xlLastTotalCellLast total cell (12)
xlPageFieldLabelsPage field labels (26)
xlPageFieldValuesPage field values (27)
xlRowStripe1Row Stripe1 (5)
xlRowStripe2Row Stripe2 (6)
xlRowSubheading1Row Subheading1 (23)
xlRowSubheading2Row Subheading2 (24)
xlRowSubheading3Row Subheading3 (25)
xlSlicerHoveredSelectedItemWithData(Added in 2010) (33)
xlSlicerHoveredSelectedItemWithNoData(Added in 2010) (35)
xlSlicerHoveredUnselectedWithData(Added in 2010) (32)
xlSlicerHoveredUnselectedWithNoData(Added in 2010) (34)
xlSlicerSelectedWithData(Added in 2010) (30)
xlSlicerSelectedWithNoData(Added in 2010) (31)
xlSlicerUnselectedItemWithData(Added in 2010) (28)
xlSlicerUnselectedItemWithNoData(Added in 2010) (29)
xlSubtotalColumn1Subtotal Column1 (13)
xlSubtotalColumn2Subtotal Column2 (14)
xlSubtotalColumn3Subtotal Column3 (15)
xlSubtotalRow1Subtotal Row1 (16)
xlSubtotalRow2Subtotal Row2 (17)
xlSubtotalRow3Subtotal Row3 (18)
xlTimelinePeriodLabels1(Added in 2013) (38)
xlTimelinePeriodLabels2(Added in 2013) (39)
xlTimelineSelectedTimeBlock(Added in 2013) (40)
xlTimelineSelectedTimeBlockSpace(Added in 2013) (36)
xlTimelineSelectionLabel(Added in 2013) (37)
xlTimelineTimeLevel(Added in 2013) (41)
xlTimelineUnselectedTimeBlock(Added in 2013) (42)
xlTotalRowTotal Row (2)
xlWholeTableWhole Table (0)

xlBlankRow
Blank row (19)
xlColumnStripe1
Column Stripe1 (7)
xlColumnStripe2
Column Stripe2 (8)
xlColumnSubheading1
Column Subheading1 (20)
xlColumnSubheading2
Column Subheading2 (21)
xlColumnSubheading3
Column Subheading3 (22)
xlFirstColumn
First column (3)
xlFirstHeaderCell
First header cell (9)
xlFirstTotalCell
First total cell (11)
xlGrandTotalColumn
Grand total column (4)
xlGrandTotalRow
Grand total row (2)
xlHeaderRow
Header row (1)
xlLastColumn
Last column (4)
xlLastHeaderCell
Last header cell (10)
xlLastTotalCell
Last total cell (12)
xlPageFieldLabels
Page field labels (26)
xlPageFieldValues
Page field values (27)
xlRowStripe1
Row Stripe1 (5)
xlRowStripe2
Row Stripe2 (6)
xlRowSubheading1
Row Subheading1 (23)
xlRowSubheading2
Row Subheading2 (24)
xlRowSubheading3
Row Subheading3 (25)
xlSlicerHoveredSelectedItemWithData
(Added in 2010) (33)
xlSlicerHoveredSelectedItemWithNoData
(Added in 2010) (35)
xlSlicerHoveredUnselectedWithData
(Added in 2010) (32)
xlSlicerHoveredUnselectedWithNoData
(Added in 2010) (34)
xlSlicerSelectedWithData
(Added in 2010) (30)
xlSlicerSelectedWithNoData
(Added in 2010) (31)
xlSlicerUnselectedItemWithData
(Added in 2010) (28)
xlSlicerUnselectedItemWithNoData
(Added in 2010) (29)
xlSubtotalColumn1
Subtotal Column1 (13)
xlSubtotalColumn2
Subtotal Column2 (14)
xlSubtotalColumn3
Subtotal Column3 (15)
xlSubtotalRow1
Subtotal Row1 (16)
xlSubtotalRow2
Subtotal Row2 (17)
xlSubtotalRow3
Subtotal Row3 (18)
xlTimelinePeriodLabels1
(Added in 2013) (38)
xlTimelinePeriodLabels2
(Added in 2013) (39)
xlTimelineSelectedTimeBlock
(Added in 2013) (40)
xlTimelineSelectedTimeBlockSpace
(Added in 2013) (36)
xlTimelineSelectionLabel
(Added in 2013) (37)
xlTimelineTimeLevel
(Added in 2013) (41)
xlTimelineUnselectedTimeBlock
(Added in 2013) (42)
xlTotalRow
Total Row (2)
xlWholeTable
Whole Table (0)

REMARKS
* Added in 2007.
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top