Skip to main content

Group rows, columns

You can group rows or columns, collapse and expand groups of rows or columns.

Up to 8 levels of nesting are supported.

Group rows or columns​

  1. Select adjacent rows or columns.
  2. In the context menu of the row or column header, select Group rows or Group columns.

You can also use the Group tool on the Page layout tab.

Collapse or expand a group of rows or columns​

  1. Group rows or columns.
  2. If needed, group rows or columns within an existing group.
  3. Click the – or + button on the grouping bar to the left or above the table.

You can also select the displayed level of nested groups by clicking the button with the desired level number (for example, 1, 2, or 3) in the upper-left corner of the table.

Clear row or column grouping​

  1. Select the grouped rows or columns.
  2. In the context menu of the row or column header, select Clear grouping.

You can also use the Group > Clear grouping tool on the Page layout tab.