WPS Group on macOS: Introduction

WPS Group is a spreadsheet grouping feature 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	Matches the number of membership-related rows in the index

About This Feature

Overview

Group in WPS Office for Mac is a spreadsheet feature for grouping consecutive rows or columns so you can collapse or expand data by level. It is useful when you need to review summaries and details in the same worksheet.

Core tasks include:

Create row groups to collapse or expand related rows.
Create column groups to manage wide tables more clearly.
Remove groups when you no longer need the grouped structure.
Use outline controls to switch between visible detail levels.

This feature is useful for budget sheets, project trackers, department summaries, and other structured spreadsheet views.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office 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; sign-in and sync features require network access
Other	Open a spreadsheet file and make sure the worksheet is editable

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office for Mac, open a spreadsheet, and look for the Group entry on the Data tab

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports grouping consecutive rows or columns and using outline controls to collapse or expand them.	Excel supports outlining worksheet data by rows and columns, with multiple outline levels for expanding or collapsing details.	Google Sheets supports grouping rows and columns, then expanding or collapsing them with plus and minus controls.	Notion supports grouping database items by property and adding sub-groups in database views.	Acrobat focuses on organizing PDF pages, such as adding, extracting, or rearranging pages, rather than grouping spreadsheet rows or columns.
WPS Advantages	Advantage: Works directly in a spreadsheet editing workflow for row and column grouping, which fits summary-and-detail review in one sheet.	Compared with WPS: Excel provides a more detailed outline model with documented multi-level grouping, but it is centered on Excel worksheet outlines.	Compared with WPS: Google Sheets offers similar row and column grouping, with commands under the View menu.	Compared with WPS: Notion grouping is designed for database properties instead of traditional spreadsheet row and column grouping.	Compared with WPS: Acrobat is designed for PDF page organization, so its workflow serves a different document type.
Official Source	—	Outline group data in a worksheet	Freeze, group, hide, or merge rows & columns	Views, filters, sorts & groups	Organize PDF pages in Acrobat on the web

Overall Conclusion
WPS Group is well suited to spreadsheet users who need to collapse and expand row or column sections inside the same worksheet. If your work is centered on database property grouping or PDF page management, Notion or Adobe Acrobat may fit those specific scenarios better.

Use Cases

No.	Scenario	Suitable For	Main Challenge	How Group Helps
1	Monthly data summaries	Finance and operations teams	Too many detail rows make overview reading difficult	Group monthly detail rows and collapse them when needed
2	Department comparison tables	Managers and analysts	Too many columns make side-by-side review harder	Group related columns and keep key columns visible
3	Project phase breakdowns	Project managers	Task hierarchy is hard to scan	Use grouped levels to separate phases and sub-tasks
4	Grade sheet organization	Teachers and school staff	Class or subject data becomes lengthy	Group rows by class or subject for faster review
5	Reusable report review	Team members	Repeatedly opening local sections takes time	Use collapse controls to show only the current area of focus

Membership & Benefits

Review free access, membership differences, and subscription options for WPS Office while using Group on macOS.

Free vs WPS Premium

Feature Area	Free Users	WPS Premium
Basic spreadsheet grouping	✅	✅
PDF features	✅ Basic features	✅ More complete PDF tools
Cloud storage	1 GB	20 GB or more depending on the plan shown on the pricing page
Templates and advanced tools	Partially available	More advanced templates and tools

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Everyday spreadsheet organization and grouping	Free	Basic Group actions are available for regular spreadsheet work
More cloud storage, PDF tools, or broader office features	WPS Premium	Better suited to users who need more than spreadsheet grouping alone

WPS membership center: Subscribe now