WPS Group on Windows: Introduction

WPS Group is a grouping view feature in WPS on Windows; it includes 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	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 database grouping feature in WPS on Windows for organizing records by field conditions. It supports multi-level grouping and sorting, which is useful when you need to group records in a table view and review similar items more efficiently.

Core capabilities include:

Add grouping conditions to organize records by field.
Set group sorting and switch between collapsed and expanded states.
Lock the current grouped view so filter, sort, and grouping settings stay consistent for collaboration.

System Requirements

Item	Requirement
OS	A Windows computer that can run WPS Office
App version	The latest version of WPS Office is recommended
Network	An internet connection is needed for online database sheets or collaboration scenarios
Other	Access to the target database sheet and permission to edit the current view

Download & Installation

Item	Details
Official Download	WPS Office Free Download
Post-install Check	Open WPS Office, enter a database sheet view, and confirm that the Group button appears on the top toolbar

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Group lets you add grouping conditions, set sorting, and use collapse, expand, and view locking in a database sheet view.	Excel can create row or column outlines in a worksheet and lets users expand or collapse outline levels.	Google Sheets can group rows or columns and expand or collapse them with plus or minus controls.	Notion databases can group items by property and also support sorting and sub-groups.	Acrobat Desktop Help focuses on PDF creation, editing, conversion, and page management rather than spreadsheet-style grouped views.
WPS Advantages	Advantage: grouping, sorting, and view locking are managed in one view panel. Distinct: it fits ongoing record review in a database sheet view.	Compared with WPS: Excel grouping is centered on worksheet outlining, and the official page does not describe view locking for this workflow.	Compared with WPS: Google Sheets provides basic row and column grouping, but the official page does not describe multi-level view locking.	Compared with WPS: Notion is closer to property-based database grouping and is not a traditional cell-based spreadsheet.	Compared with WPS: Adobe does not document an equivalent spreadsheet grouping view in its official desktop help.
Official Source	—	Outline data in Excel	Group rows or columns in Google Sheets	Views, filters, sorts and groups in Notion	Acrobat Desktop Help

Overall Conclusion
WPS Group is a practical fit when you want to organize records, adjust sorting, and keep the current grouped view stable in one place. Excel and Google Sheets are closer to worksheet outlining, while Notion is closer to database-style grouping by property.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Customer record review	Sales teams, operations teams	Records are mixed together and hard to review by owner or status	Add grouping conditions by field
2	Project task review	Project managers, team members	Large task lists are hard to scan by level	Set group sorting and use collapse or expand
3	Shared view control	Collaborators, admins	Shared views can change and affect team review	Lock the current view settings
4	Multi-field analysis	Data coordinators	One field is not enough to show business structure	Add multiple grouping conditions for multi-level grouping
5	Daily status checks	Team leads	Similar records need to be checked together	Use the Group panel to switch sorting and display states

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Member
Group feature	✅ Available	✅ Available
Basic PDF tools	✅ Available	✅ Available with broader coverage
Cloud storage	1 GB	20 GB
Template downloads	Limited	More advanced templates and related benefits
AI and advanced tools	Limited access for some tools	More advanced tools are available depending on the plan

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
Basic grouping and daily record review	Free	The Group feature itself is available without membership
More cloud storage, templates, or advanced tools	WPS Member	Better for users who also need broader document, PDF, template, or extended tool access

Subscribe here: Get WPS Membership