PivotTable.RepeatAllLabels Method (Excel)
Specifies whether to repeat item labels for all PivotFields in the specified PivotTable.
Version Information
추가된 버전: Excel 2010
Syntax
식 .RepeatAllLabels(Repeat)
식 A variable that represents a PivotTable object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Repeat |
필수 |
Return Value
Nothing
Remarks
Using the RepeatAllLabels method corresponds to the Repeat All Item Labels and Do Not Repeat Item Labels commands on the Report Layout drop-down list of the PivotTable Tools Design tab.
To specify whether to repeat item labels for a single PivotField, use the RepeatLabels property.