How to Merge and Split Cells in WPS on Windows

Use Merge and Split Cells through 4 how-to topics, including Merge & Center, other merge modes, Unmerge Cells, and Split and Fill Content; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Merge and center cells

Entry point: Home tab → Merge & Center

1. Select the adjacent cells that you want to merge.
2. Click Merge & Center on the Home tab.
3. Check whether the content is now displayed in the middle of the merged area.

Success Criteria

• Interface result: multiple cells become one merged cell.
• What you can do next: continue typing, formatting, or saving the worksheet.

Tips While Using

• Common mistake: after a merge, only the value in the upper-left cell is kept.
• Environment note: make sure the selected cells are adjacent before merging.

2. Choose other merge modes

Entry point: Home tab → arrow under Merge & Center

1. Select the cell range that you want to format.
2. Click the drop-down arrow under Merge & Center.
3. Choose Merge Content, Merge Across Rows, or Merge Same Cells based on your layout.
4. Review the result in the worksheet.

Success Criteria

• Interface result: the selected range is merged according to the chosen mode.
• What you can do next: continue adjusting alignment, borders, and fill styles.

Tips While Using

• Common mistake: merging before checking which content should remain.
• Environment note: different merge modes fit different range structures, so review the selection first.

3. Unmerge cells

Entry point: Home tab → arrow under Merge & Center → Unmerge Cells

1. Select the merged cell.
2. Click the drop-down arrow under Merge & Center.
3. Select Unmerge Cells.
4. Check whether the area has returned to separate cells.

Success Criteria

• Interface result: the merged area returns to individual cells.
• What you can do next: continue sorting, filtering, or editing cells one by one.

Tips While Using

• Common mistake: opening the menu without selecting the merged target cell first.
• Environment note: after unmerging, the original content usually remains in one restored cell.

4. Split and fill content

Entry point: Home tab → arrow under Merge & Center → Split and Fill Content

1. Select the merged cell.
2. Click the drop-down arrow under Merge & Center.
3. Select Split and Fill Content.
4. Check the restored cells and confirm the fill result.

Success Criteria

• Interface result: the merged area is split into multiple cells and the content is filled according to the feature result.
• What you can do next: continue editing each cell or reorganizing the data.

Tips While Using

• Common mistake: confusing Unmerge Cells with Split and Fill Content and getting a different result than expected.
• Environment note: confirm whether the current content should be filled into multiple cells before using this option.