In Excel groups and subtotals let you can hide data and summarize groups. Use groups and subtotals in Excel to better read data too.
When you create subtotals, your worksheet it is divided into different levels. You can switch between these levels to quickly control how much information is displayed in the worksheet by clicking the Level buttons to the left of the worksheet. In our example, we'll switch between all three levels in our outline. While this example contains only three levels, Excel can accommodate up to eight.
You can also use the Show and Hide Detail buttons to show and hide the groups within the outline.
Sometimes you may not want to keep subtotals in your worksheet, especially if you want to reorganize data in different ways. If you no longer want to use subtotaling, you'll need remove it from your worksheet.
To remove all groups without deleting the subtotals, click the Ungroup command drop-down arrow, then choose Clear Outline.