Group

Group helps you organize worksheet data by grouping rows or columns into hierarchical sections that can be collapsed or expanded as needed. It provides the tools you need to manage large sets of data more clearly, making review and comparison more efficient. With Group, you can create groups from consecutive rows or columns, collapse and expand grouped sections, remove a selected group, remove all groups at once, and use multi-level nested grouping for step-by-step detail viewing. You can also sort within each group independently, while formulas continue to calculate normally because grouping only changes the display. Whether you're reviewing large tables, comparing different column areas, or showing and hiding levels of detail for team collaboration, Group helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53