XlPTSelectionMode Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Specifies what can be selected in a PivotTable during a structured selection. These constants can be combined to select multiple types.

Name

Value

Description

xlBlanks

4

Blanks

xlButton

15

Buttons

xlDataAndLabel

0

Data and labels

xlDataOnly

2

Data

xlFirstRow

256

First row

xlLabelOnly

1

Label

xlOrigin

3

Origin

Show: