Group rows and add subtotals

Updated November 13, 2026

Group

  1. Select rows or columns and choose Data › Group (Shift+Alt+Right).
  2. Use the - and + buttons at the side to collapse and expand them.
  3. Data › Ungroup (Shift+Alt+Left) removes a group. Clear outline removes all of them.

Subtotals

  1. Sort the data by the column to group on.
  2. Choose Data › Subtotal.
  3. 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.

Was this article helpful?