| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotField.RepeatLabels property (Excel) |
vbaxl10.chm240160 |
|
|
abc7e5f7-4633-38b3-d5a8-41bfa463077d |
05/07/2019 |
medium |
Returns or sets whether item labels are repeated in the PivotTable for the specified PivotField. Read/write.
expression.RepeatLabels
expression A variable that represents a PivotField object.
Boolean
True if item labels are repeated for the specified PivotField; otherwise, False.
The setting of the RepeatLabels property corresponds to the Repeat item labels check box on the Layout & Print tab of the Field Settings dialog box for a field in a PivotTable.
To specify whether to repeat item labels for all PivotFields in a PivotTable in a single operation, use the RepeatAllLabels method.
[!includeSupport and feedback]