This FAQ focuses on 3 common questions about data retention, unmerging methods, and supported selection ranges when using Merge and Split Cells in WPS on iOS.
FAQ
What should I do if data seems missing after merging cells?
- Check whether the content in the upper-left cell before merging was the value you wanted to keep.
- If other cell content was not kept after merging, go back to the previous step if possible or reorganize the original data before merging again.
- Before merging a range with multiple values, back up important data or move the content you want to keep into the upper-left cell first.
How do I restore a merged cell to multiple cells?
- Select the merged cell.
- Find the related Unmerge option from Home or the floating toolbar.
- Tap it and check whether the cell returns to multiple separate cells.
Can I merge non-adjacent cells directly?
- First confirm that the selected range is a continuous group of adjacent cells.
- If the cells are scattered in different positions, adjust the table structure first or handle each area separately.
- Non-contiguous ranges cannot be merged as one area directly.
Glossary
| Term | Definition |
|---|---|
| Merge & Center | A table command that combines multiple adjacent cells into one cell and is commonly used for titles or grouped labels. |
| Unmerge | The action that restores a merged cell to multiple separate cells. |
| Upper-left value | The content position that is kept after merging; content in other cells is not retained automatically. |