How to Collapse and Expand Data Views in Excel (Video transcript)
We have a huge worksheet. If we want to present this information and we don’t want to bother our audience with the details, we can collapse this and show only some of the data, like we can show only the quarters.
To do that point the selector one of the cells and go to Data and Group and Auto outline. Now the data is ready to be collapsed to show only what we need to show.
If we click we will see only the quarters data. and Here also if we click 2 we can collapse the details of the sales and focus on the results. If we click 1 we will end up only the net profit.
We can return back by simply clicking the + sign or the collapse numbers. We can also clear the outline by going to ungroup and clear groups.