How to Use Merge and Split Cells in WPS on Windows

Use Merge and Split Cells with 2 how-to topics, both available directly in WPS Spreadsheet; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Merge Cells

Entry: Home tab → Merge & Center

1. Select the cells that you want to merge.
2. Click Merge & Center on the Home tab.
3. If you need a specific merge method, click the arrow below the button.
4. Choose Merge & Center, Merge Content, Merge by Row, or Merge Same Cells as needed.

Success Criteria

• Interface result: the selected cells become one visible merged area.
• What you can do next: you can continue typing, change alignment, or adjust formatting.

Tips While Using

• Common mistake: after merging, only the value in the upper-left cell is usually kept visible.
• Usage tip: use merged cells carefully in areas that need sorting, filtering, or detailed data processing.
• Extra entry: after selecting a cell or range, you can also find merge-related commands in the right-click menu.

2. Split Cells

Entry: Home tab → arrow below Merge & Center → Unmerge Cells or a related split option

1. Select the merged cell.
2. Click the arrow below Merge & Center on the Home tab.
3. Choose Unmerge Cells or Split & Fill Content.
4. Check whether the resulting cell content and layout match your needs.

Success Criteria

• Interface result: the merged area returns to separate cells.
• What you can do next: you can continue entering data, copying, sorting, or adjusting formatting.

Tips While Using

• Common mistake: after splitting, the content distribution may differ from the original input pattern.
• Usage tip: if you plan to continue batch data work, check whether each cell contains the expected content first.