WPS Group on Windows: Introduction

WPS Group is a spreadsheet grouping feature in WPS on Windows; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

Group is a built-in grouping feature in WPS Spreadsheet on Windows. It helps you organize consecutive rows or columns into levels so you can collapse details, expand sections, and switch between summary and detailed views more easily.

Core tasks include:

Group rows for structured detail sections.
Group columns for side-by-side data areas.
Remove an existing group when the layout needs to be reset.
Use outline controls to expand or collapse grouped content.

This feature is useful for financial sheets, project schedules, and large data tables that need a cleaner summary view.

System Requirements

Item	Requirement
Operating system	A Windows device
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory internet connection is required for local grouping actions; internet access is needed for download, installation, and account-related services
Other	Open an editable worksheet in WPS Spreadsheet and select consecutive rows or columns

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Spreadsheet, then go to the Data tab and confirm that the Group entry is available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports grouping consecutive rows or columns, then expanding, collapsing, or removing the group with outline controls.	Excel supports outlining worksheet data by rows and columns, with expand, collapse, and ungroup actions.	Google Sheets supports grouping and ungrouping rows or columns, then expanding or collapsing them with plus and minus controls.	Notion supports grouping database items by property and sub-grouping them, but this is a database view workflow rather than worksheet row and column grouping.	Acrobat focuses on converting PDF files to Excel and related document workflows rather than native worksheet row and column grouping.
WPS Advantages	Advantage: You can group rows, group columns, ungroup, and use outline controls directly inside a spreadsheet workflow for everyday data organization.	Compared with WPS: Excel also provides full row and column outline controls and supports deeper outline structures.	Compared with WPS: Google Sheets also supports grouping and collapsing, mainly within the Google Sheets environment.	Compared with WPS: Notion is centered on database property grouping instead of traditional spreadsheet row and column grouping.	Compared with WPS: Acrobat is oriented toward PDF conversion and editing workflows, not native spreadsheet grouping.
Official Source	—	Outline group data in Excel	Group rows and columns in Google Sheets	Views filters sorts and groups in Notion	Convert PDF to Excel in Adobe Acrobat

Overall Conclusion
WPS Group works well for organizing spreadsheet sections and switching between summary and detail views on Windows. If your work centers on traditional spreadsheet outlines, WPS, Excel, and Google Sheets all cover this need, while Notion and Adobe are better suited to database-style organization or file conversion workflows.

Use Cases

No.	Scenario	Suitable Users	Main Challenge	How Group Helps
1	Collapsing financial details	Finance teams, accountants	Too many detail rows make summaries hard to review	Group rows to collapse monthly or project details
2	Structuring project plans	Project managers, team members	Multi-stage plans take too much screen space	Create grouped sections by phase and expand them only when needed
3	Comparing many indicators	Analysts, operations teams	Too many columns make horizontal review difficult	Group columns and collapse secondary indicators
4	Cleaning up old templates	Spreadsheet maintainers	Existing groups make later editing harder	Remove groups and rebuild the structure as needed
5	Switching between summary and detail	Everyday office users	It takes time to move between overview and detail	Use outline controls to expand or collapse sections quickly

Membership & Benefits

Free vs WPS Premium

Feature Area	Free	WPS Premium
Group in spreadsheets	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Advanced PDF conversion and editing	Depends on the specific tool	✅ More tools are available
Cloud storage	1 GB	20 GB or more depending on the plan shown on the pricing page
Templates and some advanced capabilities	Limited access	More items are available

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
You mainly need row and column grouping in spreadsheets	Free	The Group feature itself is available for everyday spreadsheet organization
You also need more PDF tools, cloud storage, or broader office benefits	WPS Premium	A better fit for users who need more cross-component features and added benefits

WPS membership center: Subscribe now