WPS Group on macOS: Introduction

WPS Group is a record-grouping feature in WPS multidimensional tables on macOS; 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	All tasks in this guide are available directly

About This Feature

Overview

Group is a view-organizing feature in WPS multidimensional tables on macOS. It groups records automatically by field value so you can review similar items more efficiently.

Core capabilities include:

Group records automatically by field value for faster category-based review.
Build nested grouping levels for multi-field organization.
View summary information inside grouped views for easier comparison.
Collapse or expand groups to switch between overview and detail.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office for Mac normally
App version	It is recommended to use the latest version of WPS Office for Mac
Network	No mandatory network connection is required for local grouping actions; keep a connection for collaboration and sync scenarios
Other	Open a multidimensional table and make sure you have permission to edit the current view

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office for Mac, open a multidimensional table, and confirm that the Group entry is available in the toolbar

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS multidimensional tables can group records by field value, support nested grouping, show summary information, and let you collapse or expand groups.	Microsoft Lists can group a view by column value and supports one or two grouping columns in a view.	Google Sheets can group selected rows or columns for outline display, but it does not create a record view grouped by field value.	Notion databases can group data by property and also support sub-grouping.	Acrobat focuses on PDF documents and table tagging, and the official Adobe materials reviewed do not show a native record-grouping view for this type of data organization.
WPS Advantages	Advantage: WPS combines field-based grouping, nested levels, and grouped summaries in the same multidimensional table view for ongoing record management.	Compared with WPS: grouping is available in list views, but the official page describes up to two grouping columns.	Compared with WPS: grouping is aimed at worksheet structure display rather than database-style record grouping.	Compared with WPS: grouping and sub-grouping are available, but the workflow is centered on database pages.	Compared with WPS: no native equivalent record-grouping view is shown in the official Adobe source used here.
Official Source	—	Use grouping to modify a list or library view	Freeze, group, hide, or merge rows & columns	Views, filters, sorts & groups	How to add rows to an existing table in Acrobat Pro DC

Overall Conclusion
If you need field-based grouping for ongoing business records, WPS multidimensional tables provide a workflow that is closer to database-style view management. Google Sheets is suitable when you only need row or column outlines, while Notion is also an option for database-page organization.

Use Cases

No.	Scenario	Suitable for	Main challenge	How Group helps
1	Reviewing project tasks by category	Project managers and team leads	Large task lists are hard to review by owner or status	Group by owner or status fields
2	Managing sales leads by stage	Sales and operations teams	Lead records are mixed together and hard to compare by stage	Group records by follow-up stage
3	Organizing purchasing and inventory data	Purchasing and warehouse teams	Similar materials are scattered across records	Use multi-level grouping by category or supplier
4	Protecting a shared view	Collaborative teams	View settings may be changed by other collaborators	Lock the current grouped view after setup
5	Switching between overview and detail	Data maintenance staff	You need both category summaries and record details	Collapse or expand groups as needed

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Writer, Spreadsheet, and Presentation core apps	✅	✅
The Group feature in multidimensional tables	✅	✅
Basic PDF features and PDF reading	✅	✅
More PDF conversion, editing, and AI-related features	Some features are limited	More access or fuller availability
Cloud storage	1 GB	Higher-capacity plans are available

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Daily grouping and organization in multidimensional tables	Free	The feature in this guide is available directly and fits lightweight data management
More PDF tools, AI features, or larger cloud storage	WPS Premium	Suitable when you need broader office features and more storage

WPS membership center: Subscribe now