Group Column Headers
By grouping column headers, multiple column headers can be displayed together. Grouped columns display column headers with two rows of headers. A column that contains and displays multiple columns is called a group column.
Create Group Column
To create a group column, follow these steps:
Click on the header menu at the far right of the sheet header and select "Group Column Headers".
A dialog will appear, listing the columns contained in the sheet [A]
Click the checkboxes to select the columns you wish to group.
Enter the label of the group column header in the Header Display Label of Group Column [B].
Click "Create" to create a group column with the selected column inside.
Add/Move Columns to/from Group Column
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.
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 "Change Columns Display" on the header menu at the far right of the sheet header to display the Change Display Status dialog and rearrange the order of the columns.
Ungroup Group Column
To ungroup a group column, select "Ungroup" from the group column header menu.
Selecting "Delete Column" from the group column header menu will delete all columns in the group column.
Collapse / Expand Group Column
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.
Format
Group columns can be formatted. When formatting a group column, the formatting will be applied to all columns contained within the group column. If a column within the group column is formatted individually, 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.
Conditional format is currently not available for group columns.
Last updated