WPS merge and split cells on Android helps you adjust table structure during mobile editing; this guide covers 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
Merge and split cells is a built-in table editing feature in WPS on Android for adjusting table structure, organizing headers, and restoring cell layouts. You can merge multiple adjacent cells into one cell, or split a merged cell back into separate cells.
Core capabilities include:
- Merge adjacent cells for headers, grouped labels, and cleaner table layout.
- Use either the Tools path or the floating toolbar for quick table edits.
- Keep the top-left cell content after merging.
This feature is useful for data organization, header formatting, mobile spreadsheet editing, and quick table updates on the go.
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 internet connection is required for local merge or split actions; internet access is needed for download, sign-in, and sync |
| Other | You need to open a spreadsheet file in WPS and enter editing mode |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation method | Install WPS Office on your Android device, then open a spreadsheet and enter editing mode to use merge and split cells |
| Post-install check | Open WPS Office, open a spreadsheet, tap Edit, and check whether merge-related options appear under Tools or the floating toolbar |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | On Android, WPS lets you merge cells from Tools > Home > Merge Cells or from the floating toolbar, and you can split merged cells from the floating toolbar. After merging, only the top-left cell content is kept. | Microsoft Word supports merging and splitting table cells through Table Layout with Merge Cells and Split Cells. | Google Docs on Android supports selecting cells, opening Format > Table, and turning on Merge cells. | Notion simple tables support Merge cells and Unmerge cells for spanning headers and grouped sections, and the top-left anchor cell keeps the content. | Adobe help content for InCopy explains that table cells can be merged and split horizontally or vertically. |
| WPS Advantages | Advantage: WPS provides both a Tools path and a floating toolbar path on Android, which fits touch editing well. Distinct: You can quickly merge during editing and then restore the structure with split actions in the same mobile workflow. | Compared with WPS: the official page focuses on the Table Layout path and mainly describes a desktop-style workflow. | Compared with WPS: Google Docs on Android supports merge cells, but the official page does not highlight a dual-entry editing flow like a floating toolbar plus menu path. | Compared with WPS: Notion focuses on simple tables inside pages rather than spreadsheet-style table editing on Android. | Compared with WPS: Adobe's official guidance here is for a desktop publishing product rather than Android spreadsheet editing. |
| Official Source | — | Merge and split table cells in Word | Add and edit tables - Android | Format your page | Formatting tables |
Overall Conclusion
If you need to adjust table structure quickly on an Android device, WPS offers a mobile-friendly merge and split workflow with more than one entry path. Other products also support related table actions, but their official guidance focuses on different products, layouts, or usage scenarios.
Use Cases
| No. | Scenario | Suitable for | Main pain point | How WPS helps |
|---|---|---|---|---|
| 1 | Create table headers | Students, teachers, office staff | Multi-column titles look scattered | Select adjacent cells and merge them into one header cell |
| 2 | Clean up report layout | Office staff, finance users | Table structure looks uneven | Use merge cells to organize title or note areas |
| 3 | Restore separate cells | Mobile users | A merged area needs individual editing again | Split the merged cell to return to separate cells |
| 4 | Update tables during collaboration | Team members | Mobile edits need faster table actions | Use the floating toolbar for quick merge or split actions |
| 5 | Check content before merging | Data entry users | Important text may be overwritten | Confirm the top-left cell content before merging |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Merge and split cells | ✅ Available | ✅ Available |
| Basic spreadsheet editing | ✅ Available | ✅ Available |
| Cloud storage | 1 GB | 20 GB |
| Template downloads | Limited | More available |
| Advanced PDF tools | Basic access | More advanced tools |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Daily table cleanup and simple formatting | Free | Merge and split cells are available for regular editing needs |
| Frequent cross-device work and broader office features | WPS Premium | Better for users who need more cloud storage and additional office tools |
How to Subscribe
- WPS membership page: Subscribe to WPS Premium
Source: WPS Office pricing page