In Excel groups and subtotals let you can hide data and summarize groups. Use groups and subtotals in Excel to better read data too.
Worksheets with a lot of content can sometimes feel overwhelming and even become difficult to read. Fortunately, Excel can organize data into groups, allowing you to easily show and hide different sections of your worksheet. You can also summarize different groups using the Subtotal command and create an outline for your worksheet.
Optional: Download our practice workbook.
Watch the video below to learn more about groups and subtotals in Excel.
To ungroup data, select the grouped rows or columns, then click the Ungroup command.