WPS Merge and Split Cells on macOS FAQ

Last updated:July 20, 2026

When using Merge and Split Cells, the most common questions focus on data retention, sorting impact, and where to find the command, with 3 FAQ items below.

FAQ

Will data be lost after I merge cells in WPS on macOS?

  1. Check whether multiple selected cells already contain content.
  2. Copy or back up the range first if you need to keep the original data.
  3. After merging, only the value in the top-left cell usually remains.

Does merging cells affect sorting and filtering?

  1. Check whether the target area will be used for sorting or filtering later.
  2. Avoid merging key data areas if the table needs frequent data processing.
  3. Use merged cells more often in title or note areas to reduce the impact on data operations.

Where else can I find merge or unmerge commands besides the ribbon?

  1. Select the target cell or cell range.
  2. Right-click to open the context menu.
  3. Find the merge or unmerge command in the menu and apply it.

Glossary

TermDefinition
Merge & CenterCombines multiple cells into one cell and centers the content in the merged area.
Merge ContentCombines multiple cells into one cell while keeping a content-oriented merge behavior.
Split and Fill ContentSplits a merged cell and fills content into the resulting cells based on the selected command logic.