PivotTable.MergeLabels Property (Excel)
True if the specified PivotTable report’s outer-row item, column item, subtotal, and grand total labels use merged cells. Read/write Boolean.
Syntax
expression .MergeLabels
expression A variable that represents a PivotTable object.
Example
This example causes the first PivotTable report on worksheet one to use merged-cell outer-row item, column item, subtotal, and grand total labels.
Worksheets(1).PivotTables(1).MergeLabels = True