Chapter 7: Make long tables easier to read
Exercise 32: Group the detail rows
Task
Group the sales breakdown (rows 3–5) so it can be collapsed.
Moves 0 (target 1)1 difference(s) from the model
File
Font
Alignment
Number
Styles
Cells
A1Press and release Alt to show KeyTips (Windows). Ctrl + 1 opens Format Cells, Ctrl + Z undoes.
| A | B | C | |
|---|---|---|---|
| 1 | Category | Amount | |
| 2 | Total sales | 5000 | |
| 3 | Breakdown A | 2000 | |
| 4 | Breakdown B | 1800 | |
| 5 | Breakdown C | 1200 | |
| 6 | Total expenses | 3000 | |
| 7 | |||
| 8 |
Group the sales breakdown (rows 3–5) so it can be collapsed.
This drill is for computer screens. On a phone you can review the steps.
- Select A3:B5
- Data > Group (Shift + Alt + →) > Rows, then OK
Key takeaway
Collapse with the "−" on the left to show only the totals.
See how to make a table in Excel for details.