Merge and Split Cells in WPS on Windows: Introduction

Merge and Split Cells in WPS is a worksheet layout feature for combining adjacent cells or restoring merged areas; it includes 4 core tasks, with 4 available without membership and 0 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	4	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 gate is described for this feature

About This Feature

Overview

Merge and Split Cells is a built-in spreadsheet formatting feature in WPS Office for Windows. It helps you merge multiple adjacent cells into one cell or restore a merged area back into separate cells, which is useful for table headers, grouped sections, and cleaner worksheet layouts.

Main capabilities include:

Merge & Center: merge selected cells and place the content in the middle for cross-column titles.
Merge Content: merge cells while keeping the existing alignment style.
Merge Across Rows: merge each row in the selected range separately for batch header formatting.
Unmerge Cells and Split and Fill Content: restore merged cells for continued editing and data cleanup.

This feature is useful for report headers, schedules, grouped labels, and temporary worksheet formatting before further editing.

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 mandatory internet connection is required for local merge or split actions; internet access is needed for download and account-related 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	Open WPS Spreadsheet, go to the Home tab, and confirm that the Merge & Center button and its drop-down menu are available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports Merge & Center, Merge Content, Merge Across Rows, Unmerge Cells, and Split and Fill Content from the Home tab for direct worksheet layout editing.	Excel supports merging and unmerging cells, and its official guidance notes that only one cell's content remains after a merge.	Google Sheets supports merging rows, columns, or cells and lets users choose the merge type from the Format menu.	Notion simple tables support merge cells and unmerge cells for spanning headers and grouped sections, but they are not full spreadsheet grids.	Acrobat can merge data from multiple completed PDF forms into a single spreadsheet, but it does not provide worksheet cell merge formatting inside a spreadsheet editor.
WPS Advantages	Advantage: one worksheet entry point covers multiple merge modes plus a restore option for split-and-fill workflows. Distinct: it is designed for spreadsheet header formatting and area cleanup inside the sheet.	Compared with WPS: supports core merge and unmerge actions, but the cited page does not show merge-across-rows or split-and-fill content.	Compared with WPS: supports multiple merge choices, but the cited page focuses on the desktop Format menu workflow.	Compared with WPS: useful for visual grouping in simple tables, but it does not provide a full spreadsheet editing environment for data operations.	Compared with WPS: focuses on PDF form data collection and export rather than worksheet cell layout editing.
Official Source	—	Merge and unmerge cells in Excel	Freeze, group, hide, or merge rows and columns	Format your page	Work with form data

Overall Conclusion

WPS keeps merge and split actions focused on spreadsheet layout work inside the worksheet itself. For users who need title rows, grouped sections, and quick restoration of merged areas during editing, it fits everyday spreadsheet formatting more directly than document-style tables or PDF data workflows.

Use Cases

No.	Scenario	Suitable for	Main issue	How this feature helps
1	Create cross-column headers	Admin staff, finance teams, teachers	A title needs to span multiple columns and stay aligned	Use Merge & Center to build a clear header
2	Merge while keeping alignment	Report editors	The layout should stay close to the original alignment	Use Merge Content to preserve the current style
3	Batch format multi-row areas	Data organizers	Several header rows need consistent row-by-row formatting	Use Merge Across Rows on the selected range
4	Restore merged areas for editing	Worksheet maintainers	Sorting, filtering, or data entry is needed after formatting	Use Unmerge Cells or Split and Fill Content
5	Group repeated labels visually	Project coordinators, operations teams	Repeated labels take space and reduce readability	Combine matching display areas with merge options

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic merge and split cell actions	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Advanced PDF and extended tools	Some features are limited	More complete access
Cloud storage and extra services	Basic quota	Higher quota and more services

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Everyday worksheet formatting and header cleanup	Free	Merge and split cells are part of basic spreadsheet editing for daily work
Broader PDF, cloud, or extended office needs	WPS Premium	Better suited when you also need more advanced tools and added services

WPS membership: Subscribe now