Excel has a feature that allows you to outline your data. When you use this tool Excel analyzes your data and assigns different rows to different "levels". These levels can then be hidden or displayed, according to your requirements. An outline allows you to get a quick understanding of large amounts of data.
There are several ways to create an outline:
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.
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.
RSS Feed