Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

XlTableStyleElementType Enumeration

Office 2007
Specifies the table style element used.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlBlankRow19Blank row
xlColumnStripe17Column Stripe1
xlColumnStripe28Column Stripe2
xlColumnSubheading120Column Subheading1
xlColumnSubheading221Column Subheading2
xlColumnSubheading322Column Subheading3
xlFirstColumn3First column
xlFirstHeaderCell9First header cell
xlFirstTotalCell11First total cell
xlGrandTotalColumn4Grand total column
xlGrandTotalRow2Grand total row
xlHeaderRow1Header row
xlLastColumn4Last column
xlLastHeaderCell10Last header cell
xlLastTotalCell12Last total cell
xlPageFieldLabels26Page field labels
xlPageFieldValues27Page field values
xlRowStripe15Row Stripe1
xlRowStripe26Row Stripe2
xlRowSubheading123Row Subheading1
xlRowSubheading224Row Subheading2
xlRowSubheading325Row Subheading3
xlSubtotalColumn113Subtotal Column1
xlSubtotalColumn214Subtotal Column2
xlSubtotalColumn315Subtotal Column3
xlSubtotalRow116Subtotal Row1
xlSubtotalRow217Subtotal Row2
xlSubtotalRow318Subtotal Row3
xlTotalRow2Total Row
xlWholeTable0Whole Table


Community Additions

ADD
Show:
© 2015 Microsoft