WPS Merge and Split Cells on iOS helps you adjust spreadsheet structure on mobile devices; 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 |
| Membership restriction | None for this feature | The related entry points are available directly |
| Version restriction | No specific version gate listed | Open an editable spreadsheet file to use the feature |
About This Feature
Overview
Merge and Split Cells is a spreadsheet editing feature in WPS Office for iOS that lets you combine adjacent cells into one cell or restore a merged cell back into separate cells. It is useful for mobile spreadsheet editing, table formatting, and quick layout cleanup.
Core tasks include:
- Merge adjacent cells for headers, grouped labels, and cleaner layouts.
- Use the Home panel to merge cells or cancel a merge from the main tool area.
- Use the floating toolbar to merge or split selected cells more quickly while editing.
Common use cases include table formatting, section labeling, and mobile spreadsheet updates. This feature helps reduce repeated header text and makes it easier to adjust table structure on iPhone or iPad.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | An iPhone or iPad that can run WPS Office normally |
| App version | The latest version of WPS Office is recommended |
| Network | No mandatory internet connection is required for local merge or split actions |
| Other | Open an editable spreadsheet file and enter editing mode before you start |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation | Install WPS Office on your iOS device, sign in, and open a spreadsheet file |
| Post-install check | Launch WPS Office, open a spreadsheet, enter editing mode, and confirm that the Tools area or floating toolbar is available |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports merging adjacent cells in spreadsheets on iOS and restoring merged cells through available editing entry points in the app. | Microsoft Word supports merging adjacent table cells and splitting selected cells into rows or columns, but Microsoft notes that some table features may not be available in web or mobile apps. | Google Sheets supports merging selected rows, columns, or cells and offers multiple merge options in spreadsheets. | Notion simple tables support merged cells for spanning headers or grouped sections, and covered cells return as empty individual cells after unmerge. | Adobe InDesign supports merging cells in the same row or column and splitting cells horizontally or vertically in tables. |
| WPS Advantages | Advantage: WPS provides both a Home-panel path and a floating-toolbar path on iOS for touch-based spreadsheet editing. Distinct: merged cells can be restored directly from the available in-app controls described in this guide. | Compared with WPS: Microsoft’s official page focuses on desktop Word tables and explicitly notes that some table features may not be available on mobile apps. | Compared with WPS: Google’s official instructions mainly describe desktop spreadsheet steps, with less emphasis on an iOS touch workflow. | Compared with WPS: Notion’s merge behavior is described for simple tables in documents, not for spreadsheet-style mobile data editing. | Compared with WPS: Adobe’s official guidance is centered on layout and publishing tables rather than mobile spreadsheet editing. |
| Official Source | — | Merge or split cells in a table | Freeze, group, hide, or merge rows & columns | Simple tables vs databases | Format tables |
Overall Conclusion
If you need to merge cells or split merged cells during mobile spreadsheet editing, WPS offers a workflow that fits touch interaction on iOS. Other products also provide related table or cell-merge features, but their official guidance is more focused on desktop documents, browser-based spreadsheets, document tables, or publishing layouts.
Use Cases
| No. | Scenario | Suitable For | Main Pain Point | How WPS Helps |
|---|---|---|---|---|
| 1 | Creating table headers | Mobile office users | Multi-column headers look scattered | Merge adjacent cells to create a single header area |
| 2 | Organizing grouped labels | Data organizers | Section titles do not stand out clearly | Merge cells across columns for grouped labels |
| 3 | Restoring the original layout | Spreadsheet editors | Separate cells are needed again after a merge | Split or unmerge a merged cell to restore structure |
| 4 | Fast touch editing | Phone users | Switching through menus takes extra time | Use the floating toolbar for quicker merge or split actions |
| 5 | Quick edits away from a computer | Users working on the go | Table structure needs to be adjusted on mobile | Enter editing mode on iOS and change the cell structure directly |
Membership & Benefits
Free vs WPS Premium
| Feature | Free | WPS Premium |
|---|---|---|
| Merge cells | ✅ Available | ✅ Available |
| Split merged cells | ✅ Available | ✅ Available |
| Basic spreadsheet editing | ✅ Available | ✅ Available |
| Additional PDF, template, and advanced tools | Some capabilities are available as listed on the pricing page | More advanced capabilities and higher cloud storage are available |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended Plan | Why |
|---|---|---|
| Everyday spreadsheet formatting and structure edits | Free | Merge and split cell actions are available without membership |
| Users who also need more advanced office capabilities | WPS Premium | Suitable if you also need more PDF tools, templates, or cloud storage |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page