Merge and Split Cells in WPS on macOS: Introduction

WPS Merge and Split Cells is a spreadsheet layout feature in WPS; 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

About This Feature

Overview

Merge and Split Cells is a built-in editing feature in WPS Spreadsheet for macOS that helps you adjust table structure, organize header areas, and restore cell layouts.

Core capabilities include:

Merge cells: Combine multiple adjacent cells into one cell with different merge options.
Split cells: Unmerge a merged cell or split and fill content for continued editing.
Right-click access: You can also open related commands from the context menu after selecting cells.

This feature is useful for creating headers, organizing grouped information, and improving spreadsheet presentation.

System Requirements

Item	Requirement
Operating system	A macOS device that can run WPS Office 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 merge and split actions
Other	Open an editable spreadsheet file and make sure you have permission to edit cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Verification after installation	Launch WPS Office, open a spreadsheet, and check the Merge & Center entry on the Home tab

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet on macOS, you can use the Merge & Center entry on the Home tab to merge, unmerge, and choose options such as Merge & Center, Merge Content, Merge Across, Merge Same Cells, and Split and Fill Content.	Microsoft Word desktop supports merging adjacent table cells and splitting cells by specified rows and columns.	Google Docs supports merging cells in document tables and also provides a way to split table cells.	Notion simple tables support merging and unmerging cells, and the top-left cell keeps the content after merging.	Adobe InDesign supports merging, unmerging, and splitting table cells horizontally or vertically.
WPS Advantages	Advantage: WPS places multiple merge modes and unmerge actions under one entry point. Distinct: It also includes options such as Split and Fill Content and Merge Same Cells for spreadsheet cleanup scenarios.	Compared with WPS: the Microsoft support page focuses on standard merge and split steps and does not describe multiple spreadsheet-style merge modes in the same workflow.	Compared with WPS: Google Docs documentation focuses on document table structure editing, with feature guidance centered on basic table operations.	Compared with WPS: Notion mainly positions this capability for simple table presentation, and non-anchor cell content is cleared after merging.	Compared with WPS: Adobe documents this capability mainly in publishing-oriented table formatting workflows.
Official Source	—	Merge or split cells in a table	Add and edit tables	Format your page	Format tables

Overall Conclusion
If you mainly work in spreadsheets and need to organize headers, grouped labels, or cell layouts, WPS provides a more centralized entry and several practical merge options in one place. Other products also support related table merge and split actions, but their workflows are oriented more toward document editing, simple knowledge-base tables, or publishing layouts.

Use Cases

No.	Scenario	Suitable for	Core issue	Solution
1	Create cross-column headers	Spreadsheet creators	A title needs to span multiple columns	Use Merge & Center to build a header area
2	Organize grouped labels	Data organizers	Repeated categories are hard to read across rows	Use Merge Same Cells to combine matching content
3	Restore the original layout	Everyday office users	A merged area needs to be separated for editing again	Use Unmerge Cells or Split and Fill Content
4	Improve report presentation	Reporting users	The table structure does not highlight key information clearly	Use different merge modes to adjust headers and content areas
5	Edit quickly from the context menu	Frequent spreadsheet users	You do not want to switch to the ribbon every time	Right-click selected cells to run merge or unmerge commands

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Merge cells	✅ Available	✅ Available
Split cells	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
More advanced office, PDF, and cloud benefits	Available within the free offering shown on the product page	Available according to the selected subscription plan

Source: WPS Office pricing page

Recommendations

Use case	Recommended plan	Reason
Daily cell merging, splitting, and basic layout work	Free	This feature is available without membership
Broader needs across advanced office, PDF, or cloud benefits	WPS Premium	Suitable if you need more benefits beyond this feature

WPS membership center: Subscribe to WPS Premium