Use outlines in Excel to help organize your data into groups and summarize data for easier analysis.
The Group command allows you to group any range of cells—either columns or rows. It does not calculate a subtotal or rely on your data being sorted. This gives you the ability to show or hide any part of your worksheet and display only the information you need.
In this example, we will prepare a list of T-shirt colors and sizes that need to be distributed to each homeroom. Some of the data in the worksheet is not relevant to the distribution of T-shirts; however, instead of deleting it, we'll group it, then temporarily hide it from view.
Click to show a hidden group
Click the plus sign—also known as the Show Detail symbol—to show the group again.