WPS merge and split cells helps you adjust cell structure and content layout in spreadsheets; this guide covers 4 core tasks, with 2 available without membership and 2 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 4 | 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 | 2 | Matches the number of membership-related rows in the index |
| Version limits | None specified | Available in supported WPS Spreadsheets environments on macOS |
About This Feature
Overview
Merge and split cells is a spreadsheet editing feature in WPS Office for Mac that lets you combine multiple cells into one cell or restore a merged cell back into multiple cells. It is useful for organizing title areas, grouped headers, and content sections.
Core tasks include:
- Merge & Center: merges selected cells and centers the content, which is useful for table headers.
- Merge Cells: merges multiple cells into one while keeping the original alignment style.
- Merge Same Cells: merges cells with the same content, which is useful for repeated labels.
- Split and Fill Content: splits a merged cell and fills content back into the restored area for continued editing.
This feature is useful for report titles, grouped headers, display sections, and spreadsheet structure adjustments before or after data entry.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | Use on a macOS device that can run WPS Office for Mac normally |
| App version | It is recommended to use the latest version of WPS Office for Mac |
| Network | No mandatory network connection is required for local spreadsheet editing; network access is needed for account sign-in or membership services |
| Other | Open a WPS spreadsheet file and make sure the worksheet is editable |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Launch WPS Office for Mac, open a spreadsheet, and look for merge-related options on the Home tab |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports Merge & Center, Merge Cells, Merge Same Cells, unmerge, and Split and Fill Content. The options to merge row or column content into one cell and to split and fill content are membership-related. | Word supports merging table cells and splitting cells into a specified number of rows or columns for document table layout. | Google Docs supports merging cells, unmerging cells, and splitting a cell by rows and columns in document tables. | Notion simple tables support merging and unmerging cells for spanning headers and grouped sections, and restored cells return as empty individual cells. | Adobe help content in the allowed official sources focuses on PDF and document structure workflows, and does not present a directly equivalent spreadsheet cell merge-and-split workflow. |
| WPS Advantages | Advantage: WPS brings several merge options together in one menu and includes Merge Same Cells and Split and Fill Content for spreadsheet cleanup scenarios. | Compared with WPS: official guidance focuses on basic merge and split actions and does not show an equivalent option for merging same-content cells or filling content back after splitting. | Compared with WPS: official guidance covers core merge, unmerge, and split actions, but does not show the same spreadsheet-focused merge variations in one entry point. | Compared with WPS: suitable for lightweight page layout, but the anchor cell keeps the content and restored cells are empty after unmerge. | Compared with WPS: the official help pages in the allowed source set do not show a directly matching spreadsheet cell merge-and-split path. |
| Official Source | — | Merge and split table cells in Word | Add and edit tables | Format your page | Adobe Acrobat Help |
Overall Conclusion: If you need to adjust title areas, grouped sections, and content layout directly in a spreadsheet, WPS provides a more concentrated set of merge options in one place. Google Docs and Notion can handle basic merge and unmerge scenarios, but their official workflows focus on document or page layout rather than the same spreadsheet-oriented structure editing path.
Use Cases
| No. | Scenario | Suitable Users | Main Need | Recommended Approach |
|---|---|---|---|---|
| 1 | Create a report title area | Finance, admin, and operations users | A title needs to span multiple columns clearly | Use Merge & Center to unify the title area |
| 2 | Clean up repeated category labels | Data entry users | Repeated labels reduce readability | Use Merge Same Cells to combine repeated labels |
| 3 | Restore a merged area for editing | Spreadsheet maintainers | A merged area needs to be split and reused | Use Split and Fill Content to restore the structure |
| 4 | Adjust a display section quickly | Students, teachers, and office users | Cells need temporary merge or unmerge changes | Use Merge Cells or Unmerge Cells as needed |
Membership & Benefits
Free vs WPS Premium
| Feature | Free | WPS Premium |
|---|---|---|
| Merge & Center | ✅ | ✅ |
| Merge Cells | ✅ | ✅ |
| Merge row or column content into one cell | ❌ Membership required | ✅ |
| Split and Fill Content | ❌ Membership required | ✅ |
| Other office and cloud benefits | Basic features and basic cloud storage | More advanced features and higher cloud storage allocation |
Source: WPS Office pricing page
Recommendations
| Usage Scenario | Recommended Plan | Why |
|---|---|---|
| Daily header formatting and basic merge or unmerge tasks | Free | Covers common Merge & Center, Merge Cells, and unmerge actions |
| Reorganizing content structure or restoring filled content after splitting | WPS Premium | Includes membership-related merge and split options for more advanced table cleanup |
| Frequent work with complex report templates | WPS Premium | Better suited to repeated structure adjustments and advanced spreadsheet formatting |
How to Subscribe
- WPS membership: Subscribe now
Source: WPS Office pricing page