Groups and Subtotals

In Excel groups and subtotals let you can hide data and summarize groups. Use groups and subtotals in Excel to better read data too.


  1. Open an existing Excel workbook. If you want, you can use our practice workbook.
  2. Try grouping a range of rows or columns together. If you are using the example, group columns D and E.
  3. Use the Show and Hide Detail buttons to hide and unhide the group.
  4. Try ungrouping the group. If you are using the example, ungroup columns D and E.
  5. Outline your worksheet using the Subtotal command. If you are using the example, outline by T-shirt size.
  6. Remove subtotaling from your worksheet.