How to auto outline data in Excel?
When your data in a worksheet is extremely complicated, sometimes it’s even difficult for you to group them manually. In this case, we can group and summarize the data by creating an outline of rows and columns. This tutorial will introduce to you a quick way to "auto outline data" in Excel.
To auto outline the below data so you can quickly read and analyze the summary rows or columns or display the detailed data for each group, please do as follows:
1. Go to the "Data" tab and click "Group" > "Auto Outline".
2. Now you can see the data is organized into groups and the outline is displayed. 
Now check the "minus (-)" button or the "plus (+)" button to collapse or expand the groups of rows and columns. Or click the appropriate "outline number symbols" to collapse or expand that entire level. 
In the screenshot above, I collapse the rows of sale products in each city and the columns of the specific months in Q1 and Q2.
Notes
- The Auto Outline feature is very handy, but it has its limitations. To use it, make sure there are "no blank rows or columns" in the data.
- There should be a "summary" row or column with formulas for each subset of rows or columns.
- When the auto-outlined groups are not correctly organized, you should change the "style in which the outline is performed".
- On the "Data" tab, click the "dialog box launcher", a small arrow in the lower-right corner of the Outline group.
- The "Settings" dialog box pops up, check the "Automatic styles" box and uncheck the rest of the boxes, then click "OK".
- After the setting, the data will be correctly auto outlined.
- On the "Data" tab, click the "dialog box launcher", a small arrow in the lower-right corner of the Outline group.
Other Operations (Articles)
How To Create A Stacked Clustered Column / Bar Chart In Excel?
This article, I will talk about how to create a stacked clustered column chart in Excel as below screenshot shown.
How To Create A Unique Alphabetically Sorted List From A Column In Excel?
In some cases, you need to extract all unique cells from a list, and locate these cells in a new column in alphabetical order. In this article, we will show two methods to achieve it.
How To Split A Long List Into Equal Groups In Excel?
If you have a long list of data needed to be split into multiple equal groups as following screenshot shown, how could you deal with this task quickly and easily in Excel?
Quickly Generate Random Groups For List Of Data In Excel
Sometimes, you may want to randomly assign data to groups as screenshot 1 shown, or generate groups for a list of names as below screenshot 2 shown, but how can handle these jobs quickly? Actually, in Excel, you can use formulas to solve them easily.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in