How to Merge and Split Cells in WPS on macOS

Use Merge and Split Cells with 2 how-to topics, including merging cells and splitting cells, with 2 available without membership and 0 membership-related items.

How-to Index

How-to Guide

1. Merge Cells

Entry: Home tab → Merge & Center

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

Success Criteria

• Interface result: The selected cells become one merged cell.
• What you can do next: You can continue typing, adjust alignment, or save the file.

Tips While Using

• Common mistake: After merging, only the value in the top-left cell usually remains visible.
• Environment note: Make sure you select the correct adjacent cell range before merging.

2. Split Cells

Entry: Home tab → arrow below Merge & Center

1. Select a merged cell.
2. Click the drop-down arrow below Merge & Center.
3. Click Unmerge Cells, or choose Split and Fill Content if needed.

Success Criteria

• Interface result: The merged cell returns to multiple cells, or the content is split and filled based on the selected command.
• What you can do next: You can continue entering data, adjust formatting, or merge cells again.

Tips While Using

• Common mistake: If the selected cell is not a merged cell, the split-related action may not produce the expected result.
• Environment note: If you want to preserve content distribution after splitting, try Split and Fill Content first.