Group and ungroup rows or columns (Windows-Online)

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

Select the rows/columns you wish to group.
Go to Data > Group
From the drop-down, select Group columns/rows.
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.

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

Select the grouped columns/rows you wish to ungroup.
Go to Data > Ungroup
Select Ungroup Rows/Columns from the dropdown.

Alternatively, you can

Select the rows/columns you wish to group and right-click on the row/column headers. From the contextual menu, select Ungroup Columns/Rows.
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:

Expand/Collapse that particular group
Remove that group
Expand all groups
Collapse all groups
Move the +/- button