How to Merge and Split Cells in WPS on macOS

Use merge and split cells through 2 how-to topics in WPS Spreadsheet, with 2 available without membership and 0 membership-related items.

How-to Index

How-to Guide

1. Merge Cells

Entry: Home → Merge and Center

1. Select the adjacent cells that you want to merge.
2. Click Merge and Center on the Home tab.
3. If you need a different merge style, click the arrow below the button.
4. Choose one of the following options as needed:
   • Merge and Center: Merges the cells and centers the content.
   • Merge Content: Merges the cells while keeping the original alignment.
   • Merge by Row: Keeps only the upper-left value after the merge.
   • Merge Same Cells: Merges cells that contain the same content.

Success Criteria

• Interface result: The selected cells are combined into one cell.
• Next action available: You can continue typing, change alignment, or adjust worksheet formatting.

Tips While Using

• After merging, only the value in the upper-left cell is typically kept.
• If you plan to sort or filter later, confirm whether merged cells are appropriate for that data range.
• You can also find merge-related options from the right-click menu after selecting cells.

2. Split Cells

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

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

Success Criteria

• Interface result: The merged cell returns to separate cells.
• Next action available: You can continue editing, filling, sorting, or filtering the data range.

Tips While Using

• If you want a structure that works better for data processing, unmerge the cells first.
• After using Split and Fill Content, review how the content is distributed across the restored cells.