WPS Merge and Split Cells is a table layout feature in WPS Spreadsheet on Windows; 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 |
| Version limits | None stated | Available in the current WPS Spreadsheet environment |
About This Feature
Overview
Merge and Split Cells is a built-in editing feature in WPS Spreadsheet for Windows. It helps you combine multiple cells into one cell or restore a merged cell back into separate cells, making table structure and layout adjustments easier.
Core tasks include:
- Merge cells: Combine selected cells and choose different merge methods when needed.
- Split cells: Remove the merged state or split and fill content with the available option.
Common use cases include creating table headers, organizing grouped information, and improving report layout. It helps make title areas clearer and reduces repeated visual content in a worksheet. The main entry is on the Home tab, and related commands are also available from the right-click menu.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No required internet connection for local cell merge or split actions |
| Other | You need an editable WPS Spreadsheet file and permission to edit the current worksheet |
Download & Installation
Install WPS Office for Windows before using Merge and Split Cells.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Spreadsheet and any worksheet, then look for the Merge & Center entry on the Home tab |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports merging multiple cells in a worksheet and provides options such as Merge & Center, Merge Content, Merge by Row, Merge Same Cells, and unmerge-related actions from one menu. | Microsoft Word supports merging adjacent table cells and splitting cells into specified rows and columns. Its official guidance is centered on document table editing. | Google Docs supports merging cells, unmerging cells, and splitting table cells in documents, which fits basic online table editing. | Notion table view is designed mainly for database-style information management, with row and column arrangement, bulk editing, and property management. Its help page does not describe traditional spreadsheet-style cell merge and split behavior. | Adobe Express supports adding rows and columns to a table and merging selected cells in a design workflow. Its table features are presented in a lightweight design context. |
| WPS Advantages | Advantage: WPS places several merge methods in one menu, which is practical for worksheet layout work and header formatting. Distinct: related commands are also easy to reach from the right-click menu. | Compared with WPS: the official page focuses on standard merge and split actions and does not describe multiple merge modes in one menu. | Compared with WPS: it is well suited to online collaboration, but the merge and split workflow is more basic in the official instructions. | Compared with WPS: it is oriented toward database organization rather than traditional worksheet cell layout adjustment. | Compared with WPS: it supports merging cells, but the official page is focused more on design editing than spreadsheet-style data layout work. |
| Official Source | — | Merge or split cells in a table | Add and edit tables | Table view | Add tables to designs |
Overall Conclusion
If your main goal is worksheet layout cleanup and title-area formatting, WPS provides a more concentrated entry for merge-related actions. If you mainly work in online documents, database views, or design canvases, the other products fit different table-editing scenarios.
Use Cases
| No. | Scenario | Suitable for | Main issue | How this feature helps |
|---|---|---|---|---|
| 1 | Creating report title areas | Office staff | Cross-column titles look uneven | Use Merge & Center to unify the title area |
| 2 | Organizing grouped headers | Finance and admin staff | Multi-level headers look scattered | Use Merge Content or Merge by Row to organize the structure |
| 3 | Restoring editable areas | Worksheet maintainers | Merged areas are hard to edit further | Use Unmerge Cells to restore separate cells |
| 4 | Handling repeated labels | Data organizers | Repeated content affects readability | Use Merge Same Cells to reduce repeated display |
| 5 | Adjusting visual layout | Teachers and students | Key information does not stand out | Use merge and split actions to improve visual hierarchy |
Membership & Benefits
Free vs WPS Premium
Based on the current feature scope, Merge and Split Cells itself has no membership requirement. WPS Premium applies to other advanced capabilities and extended services.
| Capability | Free | WPS Premium |
|---|---|---|
| Merge cells | ✅ Available | ✅ Available |
| Split or unmerge cells | ✅ Available | ✅ Available |
| Other advanced office and extended benefits | Available within the visible product scope | Includes broader advanced features and service coverage |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Everyday worksheet layout and basic editing | Free | This feature is available directly without membership |
| Long-term use with broader advanced office needs | WPS Premium | Suitable if you also need more extended features and services |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page