Merge and Split Cells in WPS on iOS: Introduction

This guide covers Merge and Split Cells in WPS on iOS for adjusting table structure and layout in AirSheet; 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

Merge and Split Cells is a table editing feature in WPS Office for iOS AirSheet. It lets you combine multiple adjacent cells into one cell and restore a merged cell to its original structure. It is useful for creating headers, organizing grouped information, and improving table layout on mobile devices.

Core capabilities include:

Merge adjacent cells: Select a range and use Merge & Center to combine multiple adjacent cells into one cell.
Unmerge a merged area: Select a merged cell again and use the related command to restore separate cells.

When you merge cells, only the value in the upper-left cell is kept. This makes the feature more suitable for titles, group labels, and layout cleanup.

System Requirements

Item	Requirement
OS	An iPhone or iPad that can install and run WPS Office normally
App version	It is recommended to use the latest version of WPS Office for iOS
Network	No mandatory network connection is required for local merge and split actions; network access is needed for download, installation, and account sync
Other	Open an AirSheet file and enter editing mode before using the feature

Download & Installation

Item	Details
Official Download	WPS Office Free Download
Installation	Install WPS Office on your iOS device, sign in to your account, and open a spreadsheet file
Post-install Check	Open an AirSheet file, enter editing mode, and check whether merge-related options are available under Home or in the floating toolbar

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	On iOS AirSheet, you can merge cells from Home or the floating toolbar, and use the related action again to cancel the merge. Only the upper-left value is kept after merging.	Microsoft Word officially supports merging adjacent cells and splitting cells, but its support page notes that some table features may not be available in Word for the web or mobile apps.	Google Docs officially supports merging table cells on iPhone and iPad, and you can unmerge by turning off Merge cells.	Notion officially focuses on database table views, bulk editing, row and column arrangement, and property management, rather than traditional spreadsheet-style cell merge and split actions.	Adobe InDesign officially supports merging and splitting table cells, including horizontal and vertical splits, but the workflow is mainly designed for desktop publishing.
WPS Advantages	Advantage: WPS provides two direct entry points on iOS for merging and canceling merged cells. Distinct: It fits quick mobile table layout adjustments in AirSheet.	Compared with WPS: Microsoft documents the feature clearly, but the official page is centered on desktop Word and notes limited availability for web or mobile apps.	Compared with WPS: Google Docs on iOS also supports merge and unmerge, but the official workflow depends on the format panel inside document editing.	Compared with WPS: Notion is more focused on database organization and table views than on traditional spreadsheet cell structure editing.	Compared with WPS: Adobe provides richer desktop publishing table controls, while WPS is more direct for lightweight mobile editing.
Official Source	—	Merge or split cells in a table	Add and edit tables - iPhone & iPad	Table view	Format tables

Overall Conclusion
If you need to adjust title areas, grouped sections, or table layout quickly on an iPhone or iPad, WPS offers a workflow that is well suited to mobile editing. Notion is more suitable for database-style information organization, while Adobe and Microsoft more often document this type of table handling in desktop-oriented contexts.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Create table headers	Students, teachers, and office users	Multi-column headers look scattered and are harder to read	Select the header range and use Merge & Center to create one title cell
2	Organize grouped information	Sales staff, admins, and project members	Similar data across multiple columns is not grouped clearly	Merge adjacent cells to highlight the group label
3	Restore the original structure	Spreadsheet editors	A merged area needs to be edited again or rearranged	Cancel the merge on the selected area to restore separate cells
4	Adjust layout quickly on mobile	Users who often work with tables on phones	A small screen makes table structure less intuitive	Use Home or the floating toolbar to adjust the structure quickly
5	Confirm data retention rules	Users organizing existing data	Users want to avoid losing the wrong content after merging	Confirm that the upper-left cell contains the value you want to keep before merging

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Member
Merge and unmerge cells	✅ Available	✅ Available
Basic table editing	✅ Available	✅ Available
Additional premium benefits	Use features currently available to the account	See the pricing page for extended benefits
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
Everyday mobile table cleanup	Free	This feature itself has no membership restriction and is suitable for daily merge and unmerge actions
Need more cloud storage or added benefits	WPS Member	Suitable if you also need cross-device sync, more storage, or other extended features

WPS Membership Center: Subscribe