Expand Minimize

XlPivotLineType Enumeration (Excel)

Published: July 16, 2012

Specifies the type of the PivotLine.

Version Added: Excel 2007

Name

Value

Description

xlPivotLineBlank

3

Blank line after each group.

xlPivotLineGrandTotal

2

Grand Total line.

xlPivotLineRegular

0

Regular PivotLine with pivot items.

xlPivotLineSubtotal

1

Subtotal line.

Community Additions

ADD
Show:
© 2014 Microsoft