Expanding and Collapsing Grouping Columns and Rows

• Dec 17, 2020

Expand/Collapse Individual Columns/Rows

To toggle the expanded state of a column/row, do one of the following:

• Click the expand/collapse button:

  

• Right-click the corresponding field value and choose Expand (or Collapse) from the context menu:

  

Expand/Collapse Multiple Columns/Rows

To expand or collapse all columns/rows that correspond to the values of a particular field, right-click one of the field values and choose Expand All (or Collapse All) from the context menu.

Note

• Use the control PivotGridOptionsCustomization.AllowExpand property to prevent end-users from expanding or collapsing any columns/rows.
• Use a field PivotGridFieldOptions.AllowExpand property to prevent end-users from expanding or collapsing columns/rows that correspond to a specific column or row field.