Microsoft Office Tutorials and References
In Depth Information
Figure 8-71 Start with a hierarchical worksheet like this one.
buttons Show detail Hide detail
Figure 8-72 The worksheet hierarchies are collapsible using the Excel outlining features.
You’ll find the Team Sales.xlsx file with the other examples on the companion website.
Figure 8-73 shows the outlined worksheet with columns and rows of detail data hidden
simply by clicking all the “minus sign” icons. Without outlining, you would have to hide
each group of columns and rows manually; with outlining, you can collapse the outline to
change the level of detail instantly.