Spreadsheet Tips

Collapse Data with Groups

October 29, 2019
A person selects data and clicks "Group" to make it collapsable.
When you group data in Excel, you can easily expand and collapse with the +/- icons. This can be an easier way to collapse data than completely hiding the columns or rows. Excel also supports subgroups allowing for multiple levels of collapsing.