XlPivotCellType XlPivotCellType XlPivotCellType Enum


Specifies the PivotTable entity the cell corresponds to.

public enum class XlPivotCellType
public enum XlPivotCellType
Public Enum XlPivotCellType


xlPivotCellBlankCell xlPivotCellBlankCell xlPivotCellBlankCell 9

A structural blank cell in the PivotTable.

xlPivotCellCustomSubtotal xlPivotCellCustomSubtotal xlPivotCellCustomSubtotal 7

A cell in the row or column area that is a custom subtotal.

xlPivotCellDataField xlPivotCellDataField xlPivotCellDataField 4

A data field label (not the Data button).

xlPivotCellDataPivotField xlPivotCellDataPivotField xlPivotCellDataPivotField 8

The Data button.

xlPivotCellGrandTotal xlPivotCellGrandTotal xlPivotCellGrandTotal 3

A cell in a row or column area which is a grand total.

xlPivotCellPageFieldItem xlPivotCellPageFieldItem xlPivotCellPageFieldItem 6

The cell that shows the selected item of a Page field.

xlPivotCellPivotField xlPivotCellPivotField xlPivotCellPivotField 5

The button for a field (not the Data button).

xlPivotCellPivotItem xlPivotCellPivotItem xlPivotCellPivotItem 1

A cell in the row or column area which is not a subtotal, grand total, custom subtotal, or blank line.

xlPivotCellSubtotal xlPivotCellSubtotal xlPivotCellSubtotal 2

A cell in the row or column area which is a subtotal.

xlPivotCellValue xlPivotCellValue xlPivotCellValue 0

Any cell in the data area (except a blank row).

Applies to