Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

PivotField.RepeatLabels Property (Excel)

Returns or sets whether item labels are repeated in the PivotTable for the specified PivotField. Read/write

Version Added: Excel 2010

expression .RepeatLabels

expression A variable that represents a PivotField object.

Return Value


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.

© 2015 Microsoft