Feature Summary

The grouping feature is used to collapse/expand rows or columns in a collaborative spreadsheet into hierarchical groups, making it easier for team members to show or hide different sections as needed when viewing large amounts of data.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Operation Steps

Create Row Group

Feature Entry
"Data" tab → "Group" button → "Group X Rows"

  1. Select the consecutive rows you want to group together (e.g., Row 2 to Row 5)
  2. Click the "Group" button in the Data tab, and select "Group X Rows"
  3. A group collapse control (- symbol) will appear on the left side of the sheet
  4. Click - to collapse the group, click + to expand the group

截图

Create Column Group

Feature Entry
"Data" tab → "Group" button → "Group X Columns"

  1. Select the consecutive columns you want to group
  2. Click "Group" → "Group X Columns"
  3. Column group controls will appear at the top of the sheet
  4. You can collapse multiple columns into a group for easier comparison of columns in different areas

截图

Ungroup

Feature Entry
"Data" tab → "Group" → "Ungroup"

  1. Select the grouped rows or columns
  2. Click "Group" → "Ungroup" to remove the group
  3. To remove all groups at once, click "Ungroup"

截图

Using Outline View

Feature Entry
Outline controls (- + buttons) on the left/top of the sheet

  1. After creating a group, outline controls appear at the edge of the sheet
  2. Click - to collapse the corresponding group, click + to expand the corresponding group
  3. For multiple nested groups, you can expand level by level to view detailed data

截图

FAQ

Are the groups I set in collaboration mode visible to others?

  • Solution: Yes, group and outline settings are saved in the document. Other collaborators will see the same collapsed/expanded state when they open the document and can perform expand/collapse operations independently.

Notes

  1. Grouping is a document-level operation; once set, it is visible and operable by all collaborators
  2. Grouping does not affect data content, only the display mode
  3. It is recommended to create groups after data organization is complete to avoid group disorder caused by frequent row additions or deletions