Group rows and add subtotals
Updated November 13, 2026
Group
- Select rows or columns and choose Data › Group (Shift+Alt+Right).
- Use the - and + buttons at the side to collapse and expand them.
- Data › Ungroup (Shift+Alt+Left) removes a group. Clear outline removes all of them.
Subtotals
- Sort the data by the column to group on.
- Choose Data › Subtotal.
- Pick the column, the function (such as Sum or Count), and the columns to total, then choose OK. The outline buttons show totals only, or every row.