WPS Merge and Split Cells on iOS helps you adjust table structure and layout; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | 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 editing feature in WPS Sheets on iOS. It lets you combine multiple adjacent cells into one cell or restore a merged cell back into separate cells.
Core tasks include:
- Merge adjacent cells for headers, grouped labels, and cleaner table layout.
- Use the Home tools to merge cells or cancel a merge while editing a sheet.
- Use the floating toolbar to merge or split cells near the current selection.
This feature is useful for schedules, summary tables, report headers, and quick mobile formatting. After cells are merged, only the content in the upper-left cell is kept.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | An iPhone or iPad that can run iOS normally |
| App version | The latest version of WPS Office is recommended |
| Network | No mandatory network connection is required for local merge or split actions; downloading the app and account-related services require internet access |
| Other | Open a WPS spreadsheet file and enter editing mode before using the feature |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Office, open a spreadsheet, enter editing mode, and confirm that merge-related options appear under Home or in the floating toolbar |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | On iOS, WPS lets you select adjacent cells to merge them, tap again to cancel the merge, and use the floating toolbar for merge and split actions. | Microsoft Word officially supports merging and splitting table cells, but its help page is mainly for desktop versions and notes that some table features may not be available on web or mobile apps. | Google Docs officially supports merging table cells on iPhone and iPad by selecting a table area and turning on Merge cells, then turning it off to unmerge. | Notion officially supports Merge cells and Unmerge cells in simple tables, but its table experience is more document-oriented than spreadsheet-oriented. | Adobe InDesign officially supports Merge Cells, Unmerge Cells, Split Cell Vertically, and Split Cell Horizontally, with a stronger focus on professional layout work. |
| WPS Advantages | Advantage: WPS provides iOS-friendly entry points in both the Home tools and the floating toolbar, which fits quick spreadsheet editing on mobile devices. | Compared with WPS: the official guidance focuses on desktop workflows, with less direct support detail for mobile use. | Compared with WPS: iOS merge and unmerge are supported, but the official page focuses on document tables rather than spreadsheet editing. | Compared with WPS: simple table merge is available, but the product is aimed more at lightweight content organization than spreadsheet structure editing. | Compared with WPS: Adobe offers more detailed vertical and horizontal split options, but the workflow is designed more for desktop publishing than everyday iOS sheet editing. |
| Official Source | — | Merge or split cells in a table | Add and edit tables - iPhone & iPad | Format your page | Format tables in Adobe InDesign |
Overall Conclusion
If you need to merge or split cells quickly on an iPhone or iPad, WPS offers a workflow that fits mobile spreadsheet editing well. Other products also provide related table features, but their primary scenarios and operating paths are different.
Use Cases
| No. | Scenario | Suitable For | Main Pain Point | How WPS Helps |
|---|---|---|---|---|
| 1 | Creating table headers | Students, teachers, and office staff | Multi-column titles look scattered | Merge adjacent cells into one header area |
| 2 | Restoring the original table structure | Data organizers | A merged area needs separate entries again | Split or unmerge the merged cell |
| 3 | Quick mobile formatting | Mobile workers | Adjusting table structure on a phone can be slow | Use the floating toolbar for direct actions |
| 4 | Grouping sections in summary sheets | Operations, finance, and project users | Group labels are not visually clear | Merge cells to highlight grouped sections |
| 5 | Correcting an editing mistake | All spreadsheet users | The merged layout is not suitable after review | Tap again to unmerge or use Split |
Membership & Benefits
Free vs WPS Premium
| Feature | Free Users | WPS Premium |
|---|---|---|
| Merge and split cells in spreadsheets | ✅ Available | ✅ Available |
| Basic spreadsheet editing | ✅ Available | ✅ Available |
| Additional advanced services and extended benefits | Some features may be limited | More advanced services and extended benefits are available |
Source: WPS Office pricing page
Recommendations
| Usage Scenario | Recommended Plan | Why |
|---|---|---|
| Everyday table cleanup, schoolwork, and light mobile editing | Free | Merge and split cells are available for routine table structure changes |
| Frequent work across more scenarios with broader service needs | WPS Premium | Suitable for users who also need more extended benefits and ongoing office support |
How to Subscribe
- Membership page: Subscribe to WPS Premium
Source: WPS Office pricing page