Create and Cancel Group in WPS on Windows: Introduction

Create and Cancel Group in WPS Spreadsheet helps you group rows or columns, adjust outline display, and group worksheets for synchronized editing; this guide covers 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	Group: Shift+Alt+Right; Ungroup: Shift+Alt+Left	Applies to row and column grouping

About This Feature

Overview

Create and Cancel Group is a WPS Spreadsheet feature for organizing worksheet structure. It lets you group contiguous rows or columns, remove existing groups, adjust outline display settings, and group or ungroup worksheets for batch editing.

Core capabilities include:

Group rows or columns to collapse and expand detail data more easily.
Ungroup data rows or columns to return to a normal display state.
Adjust outline settings to place summary controls below detail data or to the right of detail data.
Group worksheets with the same structure for synchronized editing.
Ungroup worksheets to return to single-sheet editing.

This feature is useful for detailed reports, layered data review, and repeated edits across similar worksheets.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	Local grouping and ungrouping actions do not require a mandatory network connection
Other	Open a WPS Spreadsheet file and make sure the worksheet is editable

Download & Installation

Before using Create and Cancel Group, install the WPS Office desktop app for Windows and open the target workbook in WPS Spreadsheet.

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Spreadsheet, go to the Data tab, and confirm that Group, Ungroup, or outline settings are available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports grouping contiguous rows or columns, ungrouping, outline display settings, and grouping or ungrouping worksheets in the spreadsheet workflow.	Excel supports outlining worksheet data by rows or columns, with expand and collapse controls and multiple outline levels.	The Google Docs product page highlights collaborative document editing, tabs, and structured content, but it does not describe spreadsheet row or column grouping or worksheet grouping on this page.	Notion supports nested pages, toggle lists, and block-based content organization, which helps structure information but is not a traditional spreadsheet row or column grouping workflow.	Adobe Acrobat focuses on organizing PDF pages, such as reordering, inserting, deleting, and rotating pages, rather than spreadsheet row or column grouping.
WPS Advantages	Advantage: WPS combines row and column grouping, outline display settings, and worksheet grouping in one spreadsheet workflow. Distinct: The related commands are centered around the Data tab for routine report organization.	Compared with WPS: Microsoft's official page here focuses on worksheet outlines and multi-level grouping, while worksheet grouping is not the focus of this page.	Compared with WPS: Google's official page here emphasizes collaborative document creation instead of spreadsheet grouping management.	Compared with WPS: Notion is better suited to page and block organization, not worksheet grouping commands in a spreadsheet interface.	Compared with WPS: Adobe's organization tools are designed for PDF pages, not for collapsing spreadsheet detail data.
Official Source	—	Outline group data in a worksheet	Google Docs product page	Intro to writing and editing	Organize PDF files

Overall Conclusion: If your main task is grouping spreadsheet rows and columns, collapsing detail data, and editing multiple worksheets together, WPS provides a workflow that stays close to everyday spreadsheet operations. The other products listed here support their own forms of organization, but they focus on worksheet outlines, online documents, knowledge pages, or PDF pages rather than the same spreadsheet grouping workflow.

Use Cases

No.	Scenario	Suitable Users	Main Pain Point	Solution
1	Collapse detailed sales records	Finance teams, sales operations	Too many detail rows make summaries hard to review	Group contiguous rows and switch between outline levels
2	Organize wide metric columns	Data analysts	Too many columns make horizontal review difficult	Group contiguous columns and expand only the needed sections
3	Adjust outline symbol position	Report maintainers	The default outline symbol position does not match reading habits	Use outline settings to place controls below or to the right of detail data
4	Edit multiple similar worksheets together	HR, admin staff, project assistants	The same edits are needed across several worksheets	Group worksheets first, then apply the same edits together
5	End synchronized worksheet editing	All spreadsheet users	Continued grouped editing may affect multiple sheets unintentionally	Ungroup worksheets after batch editing is complete

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
Group and ungroup rows or columns	✅ Available	✅ Available
Outline display settings	✅ Available	✅ Available
Group and ungroup worksheets	✅ Available	✅ Available
Advanced PDF tools	Basic access	More advanced access
Cloud storage and template benefits	Basic quota	More benefits and higher quota

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Everyday spreadsheet grouping, ungrouping, and worksheet grouping	Free	This feature itself can be used without membership
Additional needs for PDF tools, templates, or cloud benefits	WPS Premium	Suitable for users who need broader office benefits on an ongoing basis

Membership page: Subscribe to WPS Premium