WPS merge and split cells on Android is a table editing feature for adjusting table structure; 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 table |
| Membership-related items | 0 | These tasks do not require WPS membership |
About This Feature
Overview
Merge and split cells is a common table editing feature in WPS Office for Android. It helps you adjust table layout, organize header areas, and restore the original cell structure when needed.
Core tasks include:
- Merge adjacent cells: Combine selected adjacent cells into one cell for headers or grouped content.
- Merge or split from the floating toolbar: Complete table structure changes near the selection for faster mobile editing.
This feature is useful for class schedules, summary tables, report headers, and quick table edits on mobile devices. After cells are merged, only the content in the upper-left cell is kept, so it is a good idea to confirm important data before you merge cells in WPS on Android.
System Requirements
| Item | Requirement |
|---|---|
| OS | Android phone or tablet |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory network connection is required for local cell merge or split actions |
| Other | You need to open a spreadsheet and enter editing mode |
Download & Installation
| Item | Details |
|---|---|
| Official Download | WPS Office Free Download |
| Installation Method | Install WPS Office on your Android device, then sign in or open a local spreadsheet file directly |
| Post-install Check | Launch WPS Office, open a spreadsheet, enter editing mode, and confirm that the related entry appears in Tools or the floating toolbar |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | On Android, you can merge cells from Tools > Home > Merge Cells, or use the floating toolbar to merge or split cells. Tapping the merge option again can cancel the merged state. | Microsoft Word officially supports merging adjacent table cells and splitting cells into specified rows and columns. Its official page notes that some table features may not be available in mobile apps. | Google Docs for Android officially supports selecting cells and turning on Merge cells in table formatting. The same help page also covers adding and deleting rows and columns on Android. | Notion officially describes table view, bulk editing, row and column arrangement, and calculations. Its table experience is centered on database-style tables rather than traditional spreadsheet cell merge and split workflows. | Adobe InDesign officially supports merging, unmerging, and splitting cells horizontally or vertically, but the workflow is designed for desktop publishing rather than mobile spreadsheet editing. |
| WPS Advantages | Advantage: Android entry points fit mobile spreadsheet editing well. Distinct: both the Tools panel and the floating toolbar are available for quick table structure changes. | Compared with WPS: Microsoft documents full merge and split behavior, but the cited page is focused on desktop Word and notes limited availability for web or mobile apps. | Compared with WPS: Google clearly documents Android cell merging, but the cited Android page does not describe splitting previously merged cells on Android. | Compared with WPS: Notion tables are more suitable for structured information management and database records than for traditional spreadsheet cell structure changes. | Compared with WPS: Adobe provides complete table structure controls, but the workflow is aimed at page layout work instead of quick Android spreadsheet edits. |
| Official Source | — | Merge or split cells in a table | Add and edit tables - Android | Table view | Format tables |
Overall Conclusion
If you mainly need to adjust table structure on an Android device, WPS offers a workflow that is more direct for mobile editing. Microsoft and Adobe both document related table structure features, while Google documents Android merging clearly. Notion is more suitable for database-style organization than for traditional spreadsheet cell structure editing.
Use Cases
| # | Scenario | Target Users | Core Pain Point | Solution |
|---|---|---|---|---|
| 1 | Create table headers | Students, teachers, and administrative staff | A title needs to span multiple columns | Select adjacent cells and merge them |
| 2 | Organize report structure | Finance, operations, and store staff | Table sections are not visually clear | Use merged cells to highlight grouped areas |
| 3 | Restore the original layout | Mobile editing users | A merged area needs to be separated again | Use the floating toolbar to split the merged cell |
| 4 | Make quick table edits | Field staff and sales teams | Table edits on a phone should take fewer steps | Use the floating toolbar to merge or split directly |
| 5 | Check retained data | All spreadsheet editors | Users worry that content may be overwritten after merging | Confirm in advance that only the upper-left cell content is kept |
Membership & Benefits
Free vs WPS Premium
| Feature | Free User | WPS Member |
|---|---|---|
| Merge and split cells on Android | ✅ Available | ✅ Available |
| Basic spreadsheet editing | ✅ Available | ✅ Available |
| Additional PDF, template, and cloud storage benefits | Some features are limited | More extended benefits are available |
Source: WPS Office pricing page
Recommendations
| Use Case | Recommended Plan | Reason |
|---|---|---|
| Everyday table structure edits | Free version | Merge and split cells are available directly and fit light editing needs |
| Users who also need more cloud storage, templates, or other extended features | WPS membership | Suitable for people who often handle multiple office tasks on mobile |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page