Group and ungroup rows or columns

Group and ungroup rows or columns

Grouping rows or columns and expanding them when needed helps keep your spreadsheets organized. Here's how you can do it:

How to group columns/rows

  1. Select the rows/columns you wish to group.
  2. Go to Data > Group  
  3. From the drop-down, select Group columns/rows.
  4. Alternatively, you can select the rows/columns you wish to group and right-click on the row/column headers. From the contextual menu, select Group Columns/Rows.
Notes
If you group a range that already includes a grouped section, the new group will be created as a subgroup, and the existing group will become its parent.


How to ungroup columns/rows

  1. Select the grouped columns/rows you wish to ungroup.
  2. Go to Data > Ungroup 
  3. Select Ungroup Rows/Columns from the dropdown. 
Alternatively, you can
  1. Select the rows/columns you wish to group and right-click on the row/column headers. From the contextual menu, select Ungroup Columns/Rows.
  2. Go to Data > Clear Group

Managing Grouped rows/columns  

To expand or collapse a group, click on the +/- button next to it.

By right-clicking the +/- button, you can:

  1. Expand/Collapse that particular group
  2. Remove that group
  3. Expand all groups
  4. Collapse all groups
  5. Move the +/- button