Grouping Lists
Grouping sorts the rows of a list into groups with a header row per value, for example all timesheets per project and, below that, per customer. Each header row shows how many rows the group contains.
Group a List
- Open the column menu of a column (the three dots in the column header) and choose Group by followed by the column name. For date columns the entry has a submenu: Group by displayed value, Group by year, Group by month, Group by week or Group by day.
- Or drag a column header into the grouping area above the list.
Every grouping level appears as an entry in the grouping area, in the order of the levels. Group by further columns to add levels below the existing ones. The x of an entry removes that grouping.
Collapse and Expand
| What | How |
|---|---|
| One group | Click the arrow in its header row. |
| All groups of one level | In the grouping area, use the double arrows of the level's entry: Collapse all ... groups shows the groups of that level closed, Expand all ... groups opens them while the levels below stay closed. Levels above stay open. |
| All groups of the level of a header row | Open the menu of a header row (the menu icon in the header row, or a right-click on it) and choose Collapse all group items or Expand all group items. |
The menu of a header row also contains Move group up, Move group down and Remove group to change the order of the grouping levels or to remove one.
The double arrows in the grouping area can also be used with the keyboard: move the focus to them with Tab and press Enter or Space.
Keep the Layout
The grouping and how far the groups are expanded belong to the list's layout. To get them back the next time you open the list, save them in a list profile. See List Profiles.