WPS Group is a spreadsheet grouping feature on Android for organizing table records by field values; it includes 2 core tasks, with 2 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 2 | Matches the number of rows in the How-to Index |
| Available without membership | 2 | 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 table grouping feature in WPS Office for Android. It helps you organize records by field values and display them in a grouped hierarchy that is easier to browse on a phone or tablet.
Core tasks include:
- Add a group: create a grouping condition based on a selected field and sorting order.
- Remove a group: delete an existing grouping condition and return to a regular table view.
This feature is useful when you need mobile spreadsheet grouping for department lists, task status tracking, or other categorized table data. Group changes the current table view structure and does not directly rewrite the original record content.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | Android phone or tablet |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory network connection for local grouping actions; keep a connection for collaborative sync when needed |
| Other | Open a smart spreadsheet table that contains usable fields |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Office, open a smart spreadsheet, and confirm that the Tools and Group entries are available |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | On Android, WPS lets you open Tools > Group, add a grouping condition for a field, choose the sorting order after grouping, and remove grouping conditions when needed. | Excel officially documents worksheet outline grouping for rows and columns on desktop and web. Public Microsoft results also indicate that equivalent expand or collapse grouping controls are not available in Excel for Android. | Google Sheets officially supports grouping and ungrouping rows or columns on Android, with expand and collapse controls for grouped content. | Notion supports grouping database items by property and also supports sub-groups, but this is a database view workflow rather than spreadsheet row grouping. | Acrobat for Android focuses on PDF viewing, editing, and file actions, and does not provide an equivalent spreadsheet grouping feature. |
| WPS Advantages | Advantage: field-based grouping is available directly in the Android table workflow. Distinct: WPS combines field selection and post-group sorting in one mobile flow. | Compared with WPS: official grouping guidance is centered on desktop or web worksheet outlines, and Android support for the same interaction is limited. | Compared with WPS: Android grouping is supported, but the official flow is row or column grouping; WPS is closer to field-based table grouping. | Compared with WPS: grouping depends on database properties and views instead of a traditional spreadsheet table grouping flow. | Compared with WPS: Acrobat for Android has no equivalent spreadsheet component for grouping table data. |
| Official Source | — | Outline group data in Excel | Freeze, group, hide, or merge rows and columns on Android | Views, filters, sorts and groups in Notion | Work with PDFs in Acrobat for Android |
Overall Conclusion
WPS Group fits Android spreadsheet work that needs quick table organization by field values. Google Sheets also supports grouping on Android, while Microsoft and Adobe are less aligned with this mobile table scenario. Notion is better suited to database views than traditional spreadsheet grouping.
Use Cases
| No. | Scenario | Suitable users | Main issue | How Group helps |
|---|---|---|---|---|
| 1 | Review records by department | Team managers | Mixed records are hard to scan quickly | Group the table by the department field |
| 2 | Organize tasks by status | Project members | Mobile task lists can look flat and crowded | Group by status and expand or collapse sections |
| 3 | Browse categorized data in order | Operations staff | Records in the same category are not easy to compare | Add a group and choose the sorting order |
| 4 | Switch collaboration views quickly | Shared table collaborators | A temporary view change is needed without editing raw data | Add or remove grouping conditions as needed |
| 5 | Check grouped results on a small screen | Mobile office users | Long tables are difficult to review on a phone | Use grouped sections to narrow the visible range |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Writer, Spreadsheet, and Presentation basics | ✅ Available | ✅ Available |
| Group feature | ✅ Available | ✅ Available |
| Basic PDF features | ✅ Partly available | ✅ Available |
| Advanced PDF editing and conversion | ❌ Limited or unavailable | ✅ Available |
| Cloud storage | 1 GB | 20 GB in listed plans |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| You mainly need Android spreadsheet grouping, viewing, and basic editing | Free | Group is available without membership and works for everyday table organization |
| You also need PDF editing, file conversion, or more cloud storage | WPS Premium | A paid plan is more suitable for broader document, spreadsheet, and PDF workflows |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page