> For the complete documentation index, see [llms.txt](https://docs.mashmatrix.com/mashmatrix-sheet/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.mashmatrix.com/mashmatrix-sheet/functions_about_displaying_data/group_column_headers.md).

# Group Column Headers

By grouping column headers, multiple column headers can be displayed together. Grouped columns display column headers with multiple rows of headers. A column that contains and displays multiple columns is called a group column.

You can also create a subgroup inside a group column. Column headers can have up to three levels, so you can express a hierarchical column structure such as major, middle, and minor categories.

![](https://2214743720-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOYt1c4qdNlLlHO5tcs5o%2Fuploads%2FBBoFc4ZYeG3u9WWcWIk1%2FCleanShot%202026-08-26%20at%2009.13.51%402x.png?alt=media\&token=6e3af2ef-0ac9-413d-bc7a-7936908c8f84)

## Create Group Column <a href="#create-group-column" id="create-group-column"></a>

A group column can be created directly from the column headers on the grid.

1. Shift-click or Ctrl-click (Command-click on macOS) the headers of the columns you want to group to select multiple columns.
2. Right-click a header of the selected columns and select "Group Columns" from the context menu.
3. In the dialog that appears, enter the label to be displayed in the group column header and press the OK button.

If you select columns inside a column that is already a group column and perform the same operation, a nested group column is created inside that group column.

{% hint style="info" %}
"Group Columns" is displayed only when two or more columns are selected. It also cannot be selected when the selected columns are a combination that cannot be put together as a group column.
{% endhint %}

To create a group column from the "Column List Display Setting" dialog, follow these steps:

![](https://2214743720-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOYt1c4qdNlLlHO5tcs5o%2Fuploads%2Fgit-blob-11b4052c420e333cf5fbfcd82a7af705a677a29f%2Fchange-columns-display-menu.png?alt=media)

![](https://2214743720-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOYt1c4qdNlLlHO5tcs5o%2Fuploads%2Fgit-blob-ba7b7880272712b9647e8d73bf10fa751c194da6%2Fcolumn-grouping-dialog.png?alt=media)

1. Click on the header menu at the far right of the sheet header and select "Column List Display Setting".
2. "Column List Display Setting" dialog will appear, listing the columns contained in the sheet **\[A]**
3. Click the checkboxes to select the columns you wish to group.
4. Select "New Group Column" from the top right menu **\[B]**.
5. When a dialog box appears, enter the label to be displayed in the group column header and press the "OK" button.
6. Press the "Apply" button in the Column List Display Setting dialog.
7. The selected columns will appear nested within a group column.

## Add/Move Columns to/from Group Column <a href="#add-move-column-to-from-group-column" id="add-move-column-to-from-group-column"></a>

To add a column to a group column, drag the header of the column you want to add and drop it on the header of the group column or on the header of a column contained in the group column.

With drag and drop, you can reorder columns within a subgroup, move columns in and out of a subgroup, and move a group column itself together with the columns it contains.

To move an already grouped column out of a group column, drag the header of the column you want to move and drop it on a regular column header that is not grouped.

Alternatively, you can add or move columns to or from a group column by going to the "Column List Display Setting" on the header menu at the far right of the sheet header to display the setting dialog and rearrange the order of the columns.

## Ungroup Group Column <a href="#ungroup-group-column" id="ungroup-group-column"></a>

To ungroup a group column, select "Ungroup" from the group column header menu.

{% hint style="warning" %}
Selecting "Delete Column" from the group column header menu will delete all columns in the group column.
{% endhint %}

## Collapse / Expand Group Column <a href="#collapse-and-expand-group-column" id="collapse-and-expand-group-column"></a>

Group columns can be collapsed to show only the first column, or collapsed and expanded again to show all columns.

To collapse/expand a group column, select "Collapse" or "Expand" from the group column header menu.

In nested group columns, you can collapse and expand the group column of each level individually. When you collapse a parent group column, the group columns inside it are also no longer displayed, but the collapsed/expanded state of the inner group columns is retained as it is.

![](https://2214743720-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOYt1c4qdNlLlHO5tcs5o%2Fuploads%2Fgit-blob-cb652fa4030a9ffbed2bcd92ce1302ec7485ffd6%2Fimage%20\(6\).png?alt=media)

![](https://2214743720-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FOYt1c4qdNlLlHO5tcs5o%2Fuploads%2Fgit-blob-858e7046129da38c8ca8a10bf3cd0a7e2a08c2e8%2Fimage%20\(3\)%20\(1\).png?alt=media)

## Format <a href="#format" id="format"></a>

Group columns can be formatted. When formatting a group column, the formatting will be applied to all columns contained within the group column. It is applied to nested group columns in the same way. If formatting is set individually at an inner level, it has precedence.

To format a group column, click "Settings" from the header menu of the group column, and set the format from the "Format" tab of the displayed settings dialog.

{% hint style="warning" %}
Conditional format is currently not available for group columns.
{% endhint %}
