Merge and Split Cells

Merge and Split Cells helps you adjust table structure in WPS Sheets. It provides the tools you need to combine multiple adjacent cells into one cell or restore a merged cell to separate cells, making layout formatting and data organization more efficient. With Merge and Split Cells, you can select a cell range, merge adjacent cells, cancel a merge, and split previously merged cells back to their original state. The feature retains only the upper-left cell value when merging, and other cell data is overwritten, so backing up important information or using Undo is recommended. Whether you're arranging table layouts or organizing data, Merge and Split Cells helps you complete these structural edits efficiently. Choose the documentation below that best matches your needs to learn more.