Create and Cancel Group in WPS on macOS: Introduction

Create and Cancel Group in WPS Spreadsheet on macOS helps you group or ungroup rows, columns, and worksheets; it includes 5 core tasks, with 5 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	5	Matches the number of rows in the How-to Index
Available without membership	5	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index
Shortcuts	Create Group: `Shift+Option+Right`; Ungroup: `Shift+Option+Left`	Applies to row and column grouping

About This Feature

Overview

Create and Cancel Group is a spreadsheet organization feature in WPS Office for Mac. It helps you group continuous rows, continuous columns, and worksheets, then expand or collapse details through outline controls. This workflow is useful for spreadsheet organization and how to group rows and columns in a spreadsheet.

Core capabilities include:

Create row or column groups: Build a grouping structure for continuous rows or columns to review summaries and details more clearly.
Ungroup data rows and columns: Remove existing groups and return the area to a normal display state.
Adjust outline display position: Set outline symbols below detail data or to the right of detail data.
Group worksheets: Temporarily group multiple worksheets with the same structure for synchronized editing.
Ungroup worksheets: End the grouped worksheet state so later edits no longer apply to multiple sheets at the same time.

This feature fits monthly reports, project tracking sheets, recurring statements, and multi-sheet maintenance tasks.

System Requirements

Item	Requirement
Operating system	A macOS device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office for Mac
Network	Local grouping and ungrouping do not require a constant internet connection; downloading, installation, and account services require network access
Other	Open a WPS Spreadsheet file and make sure the target area is editable

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation method	Download the Mac installer, complete the setup, and launch WPS Office
Post-installation check	Open WPS Spreadsheet, go to the Data tab, and confirm that Create Group, Ungroup, or related outline options are available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports creating groups and removing groups for continuous rows or columns in WPS Spreadsheet, includes outline display settings, and supports grouped worksheet operations.	Excel supports creating outline groups for worksheet rows or columns, expanding or collapsing them, and working with multiple outline levels.	Google Sheets supports grouping or ungrouping rows and columns, with plus and minus controls to expand or collapse grouped areas.	Notion supports grouping database items by property and adding sub-groups, but it does not provide spreadsheet-style row and column outline grouping.	Adobe Acrobat focuses on rearranging and organizing PDF pages rather than row and column grouping in spreadsheets.
WPS Advantages	Advantage: WPS combines row and column grouping, outline display settings, and grouped worksheet editing in one spreadsheet workflow.	Compared with WPS: Microsoft's official page focuses on row and column outline grouping and multi-level outlines, while worksheet grouping is not covered on the same page.	Compared with WPS: Google Sheets supports basic row and column grouping, but the official page does not cover grouped worksheet editing in the same way.	Compared with WPS: Notion grouping is designed for database views, so it is less suitable for collapsing continuous spreadsheet rows and columns.	Compared with WPS: Adobe page organization is built for PDF documents, not spreadsheet outline and worksheet grouping tasks.
Official Source	—	Outline group data in a worksheet	Freeze, group, hide, or merge rows & columns	Views, filters, sorts & groups	Reorder and organize PDF pages

Overall Conclusion: If your work centers on organizing continuous spreadsheet rows and columns, collapsing detail sections, and editing multiple worksheets together, WPS covers these tasks in one spreadsheet workflow. Other products also provide grouping or organization features, but their focus is on outline levels, online sheet grouping, database views, or PDF page arrangement.

Use Cases

No.	Scenario	Suitable Users	Core Pain Point	Solution
1	Collapse details in monthly reports	Finance teams, administrative staff	Too many detail rows make summaries hard to review	Create a row group and collapse details with outline controls
2	Fold wide category columns	Data analysts	Too many columns make horizontal review difficult	Create a column group and expand or collapse the grouped area as needed
3	Adjust outline symbol position	Spreadsheet maintainers	The default outline symbol position does not match reading habits	Change the symbol position in outline settings
4	Edit multiple sheets together	Project managers, operations staff	Repeating the same edits across similar worksheets takes time	Group worksheets first, then apply the same edits together
5	End synchronized sheet editing	All spreadsheet users	Grouped worksheets can cause unintended edits across multiple sheets	Ungroup worksheets after batch editing is complete

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
Basic Writer, Spreadsheet, and Presentation components	✅ Available	✅ Available
Create Group and Ungroup in this guide	✅ Available	✅ Available
Some advanced PDF editing and other advanced tools	Varies by feature, with some limits	✅ Includes access to more advanced capabilities
Cloud storage	1 GB	20 GB (may vary by plan)

Source: WPS Office pricing page; Why do I need to pay for WPS Office?

Recommendations

Usage Scenario	Recommended Plan	Reason
Everyday spreadsheet grouping, ungrouping, and detail review	Free	This feature itself does not require membership and fits routine spreadsheet work
Advanced PDF tools, conversion features, or more cloud storage	WPS Premium	Suitable for users who need more advanced cross-component tools and storage

WPS membership center: Subscribe now

Source: WPS Office pricing page