What you will build
Complete “Group and ungroup rows” using the visible Category, Item, Amount sample so each action and the final state can be checked against the source data.
Learning objectives
Open the practice workbook
Practice in your own copy
Make your own Google Sheets copy with the same data, formulas, formatting, filter and frozen header. The original remains unchanged.
Sign in to Google. If the original is not publicly shared, download the full workbook and import it into Google Sheets, or paste the example data into your own sheet.
Hands-on practice
Step 1: Select row numbers 2 and 3 to select both Office rows completely. Right-click the row headers, open View more row actions, then point to Group rows 2 - 3.
Step 2: Choose Group rows 2 - 3. Confirm that a group bracket and minus control appear at the left while both Office rows remain visible.
Step 3: Click the minus control beside the group bracket to collapse rows 2:3. Confirm that the two Office rows are temporarily hidden and a plus control appears for expanding the group.
Step 4: Click the plus control to expand the group again. Then click the row-group control at the left edge and choose Remove Group.
Step 5: Confirm that the group bracket disappears and all four data rows keep the same values, order, and positions.
Checkpoint
| Category | Item | Amount |
|---|---|---|
| Office | Pen | 15 |
| Office | Notebook | 40 |
| Travel | Taxi | 35 |
| Travel | Train | 60 |
Checkpoint for “Group and ungroup rows”: the Category, Item, Amount columns and sample records must still match this table after the lesson action.
Common mistakes and fixes
Correction: return to rows 2:3, select the row headers correctly, repeat the grouping command, then compare the sheet with the sample data before continuing.
Independent practice
Repeat the workflow with the two Travel rows (4:5): group them, collapse them, expand them again, then Remove Group. Do not change the source values.
Key takeaways
- ✓Select row numbers so the complete rows are selected before grouping.
- ✓Use View more row actions > Group rows 2 - 3 to create the group.
- ✓The minus control collapses the group; the plus control expands it.
- ✓Use the row-group control menu > Remove Group to ungroup the rows.
- ✓Grouping or ungrouping must not change data values or row order.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Hide and unhide rows and columns.