Feature Summary

The Group/Ungroup feature is used to group data rows/columns, picture/graphic objects, or worksheets for management. It supports collapsing detail data display, uniformly adjusting multiple objects, and batch-synchronizing operations across multiple worksheets, improving spreadsheet data management efficiency.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction
Group Shortcut Shift+Alt+Right
Ungroup Shortcut Shift+Alt+Left

Operation Steps

Group

Feature Entry
"Data" tab → "Group" button

  1. Select the contiguous rows or columns you want to group (select row area for row grouping, column area for column grouping)
  2. Click the "Group" button in the Data tab
  3. In the pop-up dialog, select the grouping type: choose "Rows" to group by rows, choose "Columns" to group by columns
  4. Click OK to complete
  5. To create multiple groups, repeat the steps above

截图

Ungroup Data Rows/Columns

Feature Entry
"Data" tab → "Ungroup" button

  1. Place the cursor in the area you want to ungroup
  2. Click the "Ungroup" button in the Data tab
  3. The ungrouping is completed

截图

Outline Settings

Feature Entry
"Data" → "Outline Settings" arrow

  1. Click the Data tab
  2. Click the "Outline Settings" arrow
  3. In the pop-up pane, check or uncheck "Below detail data" or "To the right of detail data"
  4. Click OK to set the collapse symbol display position

截图

Worksheet Grouping (Group Worksheets)

After worksheets are grouped, operations will be synchronized to all grouped worksheets, suitable for batch processing of worksheets with the same structure

  1. Hold down the Ctrl key, click the worksheet tabs at the bottom that you want to group, and select all target worksheets
  2. Once selected, the grouping is completed

Ungroup Worksheets

Feature Entry
Right-click worksheet tab → "Ungroup Worksheets" option

  1. Right-click any worksheet tab within the group
  2. Select the "Ungroup Worksheets" option
  3. The ungrouping is completed

截图

FAQ

Q1: How to quickly collapse/expand detail data after creating a group?

  • Solution: After creating a group, outline buttons will appear on the left or top of the sheet. Click 1/2/3 or the plus/minus signs to quickly collapse/expand detail data.

Notes

  • When grouping data rows/columns, a separator area must be kept between groups
  • After worksheets are grouped, operations will be synchronized to all grouped worksheets, suitable for batch processing of worksheets with the same structure
  • Data with subtotals will automatically be grouped by rows; you can also manually create groups