Merge and Split Cells in WPS on Android: Introduction

WPS Merge and Split Cells on Android helps you adjust spreadsheet structure and layout on mobile; 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	This feature can be used without membership

About This Feature

Overview

Merge and Split Cells is a built-in spreadsheet editing feature in WPS Office for Android. It lets you combine adjacent cells into one cell or restore a merged cell area back to separate cells.

Core capabilities include:

Merge or unmerge cells from the Home tab during regular editing.
Use the floating toolbar to merge or unmerge cells more quickly while reviewing table layout.
Keep only the value in the top-left cell after merging, which is useful for title rows, grouped headers, and cleaner table structure.

This feature is useful for table headers, grouped labels, and mobile spreadsheet formatting.

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 network connection is required for local merge or split actions
Other	You need to open a spreadsheet file and enter editing mode

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Install WPS Office on your Android device, sign in, and open a spreadsheet file
Post-install check	Open a spreadsheet in editing mode and confirm that merge-related options appear in the Home tab or floating toolbar

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	On Android, WPS lets you merge adjacent cells from the Home tab or the floating toolbar, and tap again to unmerge. After merging, only the top-left value is kept.	Microsoft Support explains that Word can merge adjacent cells and split cells, but it also notes that some table features may not be available in Word for the web or mobile apps.	Google Docs Help shows that Android users can select cells, open Table formatting, and turn on Merge cells.	Notion Help explains that simple tables support Merge cells and Unmerge cells, and the top-left anchor cell keeps the content. It also notes that some layout features such as columns are not supported on mobile phones.	Adobe Help content in the reviewed official page is centered on InDesign desktop workflows, and the public help page reviewed here does not provide a matching Android spreadsheet cell merge path.
WPS Advantages	Advantage: WPS provides two direct touch-friendly entry points on Android for merge and unmerge actions, and it clearly states that only the top-left value is kept after merging.	Compared with WPS: the official Microsoft page is focused on desktop Word and explicitly notes that some table features may not be available on mobile apps.	Compared with WPS: Google Docs on Android supports merging cells, but the official page does not show the same two-entry workflow through both a main tab and a floating toolbar.	Compared with WPS: Notion supports merge and unmerge in simple tables, but its mobile experience is more lightweight and not centered on traditional spreadsheet editing.	Compared with WPS: the reviewed Adobe help content is oriented toward desktop publishing rather than Android spreadsheet editing, so the mobile merge path is less direct for this use case.
Official Source	—	Merge or split cells in a table	Add and edit tables - Android	Format your page	Thread text frames in InDesign

Overall Conclusion
For traditional spreadsheet structure changes on Android, WPS offers a more direct touch workflow for merging and unmerging cells. Other products support related table tasks in their own contexts, but WPS is better suited to quick mobile spreadsheet layout adjustments in this scenario.

Use Cases

No.	Scenario	Suitable For	Main Need	How WPS Helps
1	Create title rows	Students, assistants, office staff	Multi-column titles look scattered	Merge adjacent cells into one title area
2	Build grouped headers	Finance and operations users	Category headers need to span multiple columns	Use merged cells for cross-column labels
3	Restore table structure	Mobile office users	A merged area needs to be edited again	Unmerge the selected merged cell area
4	Adjust layout quickly on phone	Mobile spreadsheet editors	Full menus can slow down editing	Use the floating toolbar for faster actions
5	Check content before merging	Spreadsheet organizers	Important values may be overwritten	Confirm the top-left cell content before merging

Membership & Benefits

Free vs WPS Premium

Feature	Free	WPS Premium
Merge or unmerge cells on Android	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Additional office and extended benefits	Some features may be limited	More extended tools and services are available

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Everyday spreadsheet layout and structure edits	Free	This feature is available directly without membership
Broader office workflows across more tools	WPS Premium	Suitable if you also need more extended tools and services

WPS membership: Subscribe now