Use outlines in Excel to help organize your data into groups and summarize data for easier analysis.
You can also use the or commands on the Data tab in the Outline group. Select a cell in the group you want to show or hide, then click the appropriate command.
The groups in your outline, based on their hierarchy, are placed on different levels. You can quickly display as little or as much information as you want by clicking the level symbols to the left of your worksheet. In this example, we will view levels in descending order, starting with the entire worksheet on display, then finishing with the grand total. While this example contains only three levels, Excel can accommodate up to eight.