Skip to content

Latest commit

 

History

History
33 lines (19 loc) · 892 Bytes

Excel.PivotField.LayoutCompactRow.md

File metadata and controls

33 lines (19 loc) · 892 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PivotField.LayoutCompactRow property (Excel)
vbaxl10.chm240144
vbaxl10.chm240144
Excel.PivotField.LayoutCompactRow
f4969f85-9278-517f-f367-b0d58b3daafb
05/04/2019
medium

PivotField.LayoutCompactRow property (Excel)

Specifies whether or not a PivotField is compacted (items of multiple PivotFields are displayed in a single column) when rows are selected. Read/write Boolean.

Syntax

expression.LayoutCompactRow

expression A variable that represents a PivotField object.

Remarks

Setting this property to True (default) will have no immediate visual effect in the PivotTable if the LayoutForm property is set to xlTabular, but it can be set independently.

[!includeSupport and feedback]