Grouping

## Grouping Spreadsheets with tons of data can be a headache to read. You can spend a lot of time and effort trying to visualize, manage, and analyze the information that is relevant to you. Document Solutions for Excel lets you summarize large amounts of information in groups so that complex spreadsheets are easier to navigate. After rows of data in a spreadsheet are grouped, users can expand and collapse details with the click of a button in the group header row. You can use the following methods and properties to customize your groupings: - The **Group** method of the range increases the outline level of specific rows - The **Ungroup** method of the range decreases the outline level of specific rows - The **ShowDetail** Boolean property expands or collapses a group - The **ShowLevels** method of the worksheet's Outline instance expands specific level groups