| title | api_name | ms.assetid | ms.date | ms.localizationpriority | |
|---|---|---|---|---|---|
XlPTSelectionMode enumeration (Excel) |
|
28f4b6ba-a37e-16e7-2dd5-543d5ca2751c |
06/08/2017 |
medium |
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 |
[!includeSupport and feedback]