WPS Merge and Split Cells in Spreadsheets on macOS FAQ

This FAQ covers 4 common questions about data retention, sorting and filtering impact, and membership-related differences, plus a glossary of key terms.

FAQ

Will data be lost after I merge cells?

1. Check whether multiple selected cells already contain content before you merge them.
2. If you need to keep content from several cells, copy it to another area first.
3. After a standard merge, only the content in the top-left cell usually remains.
4. If you need to combine content from multiple cells into one cell, use the membership-related option to merge row or column content into one cell.

Does merging cells affect sorting and filtering?

1. Yes. Merged areas can affect sorting, filtering, and some batch data-processing actions.
2. If the sheet still needs sorting or filtering, finish those data tasks before using display-oriented merged cells.
3. Merging is more suitable for title areas or grouped display sections.

Why can’t I see some merge or split options?

1. Make sure you are working in a WPS spreadsheet file.
2. Check whether you have selected an editable cell range.
3. If you need Merge row/column content into one cell or Split and Fill Content, make sure your account has the required membership access.
4. If the option still does not appear, update WPS Office for Mac and try again.

When should I use Split and Fill Content?

1. Use it when you previously merged cells and later need to restore multiple cells for continued editing.
2. It is useful for revising report structures, restoring detail areas, or reorganizing spreadsheet layouts.
3. If you only need a standard restore action, use Unmerge Cells.

Glossary