How to Merge and Split Cells in WPS on Windows

Use merge and split cells in WPS through 4 how-to topics, including Merge & Center, Merge Cells, Unmerge Cells, and Merge Row/Column Content into One Cell; 3 topics are available without membership and 1 is membership-related.

How-to Index

How-to Guide

1. Merge & Center

Entry point: Home → Merge & Center

1. Open the spreadsheet you want to edit and select the multiple cells you want to merge.
2. Click the Merge & Center button on the Home tab.
3. Check whether the merged cell content is displayed in the center of the merged area.

Success Criteria

• UI state: Multiple cells are merged into one cell, and the content is centered.
• Next actions: You can continue typing, formatting, or saving the file.

Tips While Using

• Common mistakes: If you do not select multiple adjacent cells first, the result may not match your expectation.
• Environment limits: If the selected area contains multiple pieces of content, confirm which content should be kept before merging.

2. Merge Cells

Entry point: Home → Merge & Center drop-down arrow → Merge Cells

1. Select the multiple cells you want to merge.
2. Click the drop-down arrow next to Merge & Center.
3. Select Merge Cells from the menu.
4. Check whether the merged content keeps its original alignment.

Success Criteria

• UI state: The selected range is merged into one cell.
• Next actions: You can continue setting borders, fill colors, or entering content.

Tips While Using

• Common mistakes: Mixing up Merge & Center and Merge Cells may change the alignment unexpectedly.

3. Unmerge Cells

Entry point: Home → Merge & Center drop-down arrow → Unmerge Cells

1. Select the merged cell.
2. Click the drop-down arrow next to Merge & Center.
3. Select Unmerge Cells.
4. Confirm that the original area has been restored to separate cells.

Success Criteria

• UI state: The merged area is separated into multiple cells.
• Next actions: You can edit the restored cells individually.

Tips While Using

• Common mistakes: If the merged area is not selected first, the unmerge action may not work as expected.

4. Merge Row/Column Content into One Cell

Entry point: Home → Merge & Center drop-down arrow → Merge Row/Column Content into One Cell

1. Select multiple cells that contain text content.
2. Click the drop-down arrow next to Merge & Center.
3. Select Merge Row/Column Content into One Cell.
4. Follow the on-screen prompts to complete the content consolidation.
5. Check whether the content from multiple cells has been combined into one cell in row or column order.

Success Criteria

• UI state: Content from multiple cells has been consolidated into one cell.
• Next actions: You can continue editing the combined text.

Tips While Using

• Common mistakes: If you do not confirm your membership status first, the option may not be available.
• Membership: This feature requires WPS membership.
• Environment limits: Check the original content order first so you do not need to reorganize it after consolidation.