Merge and Split Cells in WPS on macOS: Introduction

Merge and split cells in WPS on macOS 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 limit	None specified	No version threshold is described for this feature

About This Feature

Overview

Merge and Split Cells is a spreadsheet layout feature in WPS for macOS. It helps you combine multiple adjacent cells into one cell or restore a merged cell back into separate cells when you need to reorganize a worksheet.

Key capabilities include:

Merge cells to create title areas, grouped headers, or cleaner visual sections.
Choose different merge methods, including Merge and Center, Merge Content, Merge by Row, and Merge Same Cells, depending on the layout you need.
Unmerge cells or use Split and Fill Content to continue editing data after a merged layout is no longer needed.

This feature is useful for report headers, grouped table structures, worksheet formatting, and restoring a standard data layout before sorting or filtering.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office for macOS
Network	No mandatory network connection is required for local cell merge or split actions
Other	You need an editable WPS spreadsheet file and permission to edit the worksheet

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Download and install WPS Office for macOS, then open a spreadsheet file to use this feature
Post-install check	Launch WPS Spreadsheet, select cells, and confirm that the Merge and Center entry is available on the Home tab

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports merging cells from the Home tab and offers Merge and Center, Merge Content, Merge by Row, and Merge Same Cells. It also supports unmerging cells and Split and Fill Content.	Word supports merging selected adjacent table cells and splitting selected cells into a specified number of rows or columns in desktop versions.	Google Docs supports merging cells, unmerging cells, and splitting a table cell by entering the number of rows and columns.	Notion simple tables support merging and unmerging cells. The top-left anchor cell keeps the content, while other selected cells are cleared.	Adobe Express mobile supports adding tables, adding or deleting rows and columns, and merging selected cells in a design.
WPS Advantages	Advantage: WPS provides multiple merge methods in one menu and also includes Split and Fill Content for follow-up worksheet cleanup.	Compared with WPS: Microsoft documents standard merge and split actions, but the official page describes fewer merge variations in the same workflow.	Compared with WPS: Google Docs supports merge and split actions, but its official help focuses on general table editing rather than multiple merge styles in one command group.	Compared with WPS: Notion simple tables are useful for lightweight page layout, but they are less focused on spreadsheet-style data restructuring.	Compared with WPS: Adobe Express focuses on design tables and merge actions on mobile, while the official page does not describe a matching split-cell workflow for table data editing.
Official Source	—	Merge or split cells in a table	Add and edit tables	Format your page	Add tables to designs

Overall Conclusion
If your main task is spreadsheet formatting and worksheet structure adjustment, WPS offers a direct merge-and-split workflow for everyday editing. It is especially practical when you need several merge styles, quick unmerge access, and a way to continue organizing content after changing the table layout.

Use Cases

No.	Scenario	Suitable Users	Main Pain Point	How WPS Helps
1	Creating report title areas	Admin, finance, and operations users	A title needs to span multiple columns	Use Merge and Center to create a cross-column title area quickly
2	Organizing grouped headers	Users preparing structured tables	Multi-level headers are hard to read	Use Merge Content or Merge by Row to organize header structure
3	Restoring a standard data range	Users who need sorting or filtering later	Merged layouts can block later data work	Use Unmerge Cells or Split and Fill Content to restore structure
4	Combining repeated content areas	Users maintaining weekly reports or lists	Repeated labels reduce readability	Use Merge Same Cells to reduce repeated display
5	Adjusting layout from the shortcut menu	Frequent spreadsheet editors	Switching between menus slows editing	Right-click selected cells to access merge or unmerge options

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Merge and split cells	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Additional advanced office features	Available within the free scope shown on the product page	Includes more advanced features and extended benefits
Cloud storage	1 GB	20 GB, based on the pricing page

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Why
Everyday spreadsheet formatting and basic cell merge or split tasks	Free	This feature is available without membership, so standard worksheet editing can start right away
Users who also need more advanced office features and more cloud storage	WPS Premium	Suitable for users who want broader office capabilities and additional cloud benefits

WPS membership center: Subscribe to WPS Premium