WPS merge and split cells is a Sheets feature for adjusting cell layout and content presentation on Windows; it includes 4 core tasks, with 3 available without membership and 1 membership-related item.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 4 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free topics in the index |
| Membership-related items | 1 | Matches the number of membership-related topics in the index |
About This Feature
Overview
Merge and split cells in WPS Office Sheets on Windows is a built-in table editing feature for combining multiple cells, unmerging cells, and organizing cell content in different ways. It is useful for users looking for how to merge cells in WPS Sheets while keeping table layouts clear.
Core tasks include:
- Merge & Center: Combines multiple cells and centers the content, which is useful for table headers.
- Merge Cells: Combines the selected range while keeping the original alignment, which is useful for layout adjustments.
- Unmerge Cells: Restores a merged area to separate cells for continued editing.
- Merge Row/Column Content into One Cell: Combines content from multiple cells into one cell by row or column order, which is useful for text consolidation and requires membership.
Common use cases include creating report titles, organizing grouped headers, restoring mistakenly merged areas, and consolidating text from multiple cells. After merging, only the content in the top-left cell is usually kept.
System Requirements
| Item | Requirement |
|---|---|
| OS | A Windows device that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office |
| Network | Local merge and split actions do not require a network connection; signing in for membership features requires internet access |
| Other | You need to open a WPS Sheets file and have permission to edit it |
Download & Installation
| Item | Notes |
|---|---|
| Official Download | WPS Office Free Download |
| Post-install Check | Launch WPS Office → open a spreadsheet file → check the Home tab for Merge & Center related options |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports Merge & Center, Merge Cells, Unmerge Cells, and Merge Row/Column Content into One Cell; the content-consolidation option is membership-related. | Microsoft Word supports merging table cells, unmerging them, and splitting cells by rows and columns for document table editing. | Google Docs supports merging cells, unmerging cells, and splitting table cells, along with other table structure adjustments. | Notion simple tables support merging and unmerging cells for spanning headers and visually grouped sections. | Adobe Acrobat focuses on PDF table structure and accessibility work, including header scope and span settings for complex tables. |
| WPS Advantages | Advantage: On Windows, common merge and unmerge actions are available directly from the Home tab. Distinct: It also provides Merge Row/Column Content into One Cell for content consolidation. | Compared with WPS: Microsoft documentation highlights merge, unmerge, and split actions in document tables, with less emphasis on content-consolidation style merging. | Compared with WPS: Google Docs supports merge, unmerge, and split actions, but the workflow is centered on right-click menus and table options. | Compared with WPS: Notion is better suited to lightweight page layout, and its table editing depth differs from a traditional spreadsheet workflow. | Compared with WPS: Adobe is oriented more toward PDF post-processing and accessibility tagging than everyday spreadsheet editing. |
| Official Source | — | Merge or split cells in a table | Add and edit tables | Format your page | Complex tables |
Overall Conclusion
If your main scenario is spreadsheet layout and content organization on Windows, WPS keeps merge and split options in a more centralized place for day-to-day work. Other products are also suitable, but they are oriented more toward document tables, collaborative pages, or PDF structure editing.
Use Cases
| # | Scenario | Target Users | Core Pain Point | Solution |
|---|---|---|---|---|
| 1 | Create report titles | Office users | Multi-column headers do not stand out clearly | Use Merge & Center to unify the title area |
| 2 | Organize grouped headers | Data organizers | Header hierarchy is unclear | Use Merge Cells to create cross-column groups |
| 3 | Restore mistakenly merged areas | Spreadsheet editors | A merged area needs to be separated again | Use Unmerge Cells to restore individual cells |
| 4 | Consolidate text from multiple cells | Users organizing notes or descriptions | Content is scattered across several cells | Use Merge Row/Column Content into One Cell to combine the text |
Membership & Benefits
Free vs WPS Premium
| Feature | Free User | WPS Member |
|---|---|---|
| Merge & Center | ✅ | ✅ |
| Merge Cells | ✅ | ✅ |
| Unmerge Cells | ✅ | ✅ |
| Merge Row/Column Content into One Cell | ❌ Requires membership | ✅ |
| Cloud storage and more advanced features | Basic benefits | More advanced benefits and larger cloud storage |
Source: WPS Office pricing page
Recommendations
| Use Case | Recommended Plan | Reason |
|---|---|---|
| Everyday header formatting and basic editing | Free | Common merge and unmerge actions are enough for routine work |
| Ongoing text consolidation and more complex spreadsheet work | WPS Member | You can use the membership-related content consolidation option together with additional advanced benefits |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page