There are several ways to create an outline:
- Inserting automatic subtotals. To do this select a cell in a data list, then click on the display the Data tab of the ribbon. Select Subtotal in the Outline group.
- Letting Excel automatically outline your data list. Select the list that you want to outline and then select the Data tab of the ribbon. Click on Group from the Outline group, then click on Auto Outline.
- Manually outlining your data list. Highlight the data you consider to be detail information and then display the Data tab of the ribbon. Click on Group from the Outline group and then click Group. Repeat this process for all the other detail information in the data list.
When your data is outlined, outline symbols will appear on the left side of your worksheet. You can display the different levels of data by using the mouse to click on the various symbols.