How to Use WPS Group on macOS

This how-to guide includes 4 topics: create row groups, create column groups, remove groups, and use outline controls; 4 are free and 0 are membership-related.

How-to Index

How-to Guide

1. Create Row Groups

Entry: Data → Group → Group Selected Rows

1. Select the consecutive rows that you want to place in one group, such as rows 2 through 5.
2. Click the Data tab.
3. Click Group.
4. Choose the command for grouping the selected rows.
5. Use the control on the left side of the sheet to collapse with - or expand with +.

Success Criteria

• Interface result: A grouping control appears on the left side of the worksheet.
• Next action available: You can continue collapsing, expanding, or creating more groups.

Tips While Using

• Common mistake: If the selected rows are not consecutive, the grouping result may not match your expectation.
• Environment note: Make sure the worksheet is editable before you start.

2. Create Column Groups

Entry: Data → Group → Group Selected Columns

1. Select the consecutive columns that you want to group.
2. Click Group on the Data tab.
3. Choose the command for grouping the selected columns.
4. Check the top of the worksheet for the new column grouping control.
5. Collapse or expand the grouped columns as needed.

Success Criteria

• Interface result: A grouping control appears above the grouped columns.
• Next action available: You can continue grouping other columns.

Tips While Using

• Common mistake: Row grouping and column grouping are similar, so confirm that you selected columns before applying the command.

3. Remove Groups

Entry: Data → Group → Ungroup

1. Select the grouped rows or columns.
2. Click Group.
3. Choose the command to remove the current group.
4. If needed, use the option that clears grouping more broadly in the worksheet.

Success Criteria

• Interface result: The related grouping control disappears.
• Next action available: The worksheet returns to a normal view and can be grouped again later.

Tips While Using

• Common mistake: If the target grouped area is not selected first, the result may not match the intended section.

4. Use Outline Controls

Entry: The + and - outline controls beside or above the worksheet

1. Create at least one row group or column group first.
2. Find the outline controls at the edge of the worksheet.
3. Click - to collapse the current grouped section.
4. Click + to expand the current grouped section.
5. If there are nested groups, switch levels step by step to review different layers of detail.

Success Criteria

• Interface result: Grouped sections switch between collapsed and expanded states.
• Next action available: You can continue reviewing other levels or editing visible data.

Tips While Using

• Common mistake: If no group has been created yet, the outline controls will not appear.