Merge and Split

Merge and Split helps you combine multiple cells into one or split a merged cell back into multiple cells in WPS Sheets. It provides the tools you need to adjust table layouts, making your work more efficient and helping you accomplish tasks with ease. With Merge and Split, you can merge and center content, merge cells while keeping original alignment, merge identical cells, merge row or column content into one cell, and unmerge cells or split and fill content. Some merge options require a membership subscription. Whether you're reorganizing a table, restoring previously merged cells, or preparing data while avoiding issues with sorting and filtering, Merge and Split helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.