Export (0) Print
Expand All
Expand Minimize

XlTableStyleElementType Enumeration

Specifies the table style element used.

Version Added: Excel 2007

Name

Value

Description

xlBlankRow

19

Blank row

xlColumnStripe1

7

Column Stripe1

xlColumnStripe2

8

Column Stripe2

xlColumnSubheading1

20

Column Subheading1

xlColumnSubheading2

21

Column Subheading2

xlColumnSubheading3

22

Column Subheading3

xlFirstColumn

3

First column

xlFirstHeaderCell

9

First header cell

xlFirstTotalCell

11

First total cell

xlGrandTotalColumn

4

Grand total column

xlGrandTotalRow

2

Grand total row

xlHeaderRow

1

Header row

xlLastColumn

4

Last column

xlLastHeaderCell

10

Last header cell

xlLastTotalCell

12

Last total cell

xlPageFieldLabels

26

Page field labels

xlPageFieldValues

27

Page field values

xlRowStripe1

5

Row Stripe1

xlRowStripe2

6

Row Stripe2

xlRowSubheading1

23

Row Subheading1

xlRowSubheading2

24

Row Subheading2

xlRowSubheading3

25

Row Subheading3

xlSlicerHoveredSelectedItemWithData

33

A selected item, hovered over by the user, that contains data.

xlSlicerHoveredSelectedItemWithNoData

35

A selected item, hovered over by the user, that does not contain data.

xlSlicerHoveredUnselectedItemWithData

32

An item, hovered over by the user, that is not selected and that contains data.

xlSlicerHoveredUnselectedItemWithNoData

34

A selected item, hovered over by the user, that is not selected and that does not contain data.

xlSlicerSelectedItemWithData

30

A selected item that contains data.

xlSlicerSelectedItemWithNoData

31

A selected item that does not contain data.

xlSlicerUnselectedItemWithData

28

An item that is not selected that contains data.

xlSlicerUnselectedItemWithNoData

29

An item that is not selected that does not contain data.

xlSubtotalColumn1

13

Subtotal Column1

xlSubtotalColumn2

14

Subtotal Column2

xlSubtotalColumn3

15

Subtotal Column3

xlSubtotalRow1

16

Subtotal Row1

xlSubtotalRow2

17

Subtotal Row2

xlSubtotalRow3

18

Subtotal Row3

xlTotalRow

2

Total Row

xlWholeTable

0

Whole Table

Show:
© 2014 Microsoft