How to unmerge cells in WPS Spreadsheet

September 28, 2021
873 Views 0

Graphic skills

1. Use WPS Office to open the table, select the merged cells, and click the Home tab.

2. Then click the drop-down button of Merge and Center.

3. We can see two ways to split cells in WPS Spreadsheets: Unmerge Cells and Unmerge and Fill.

We can choose one of them according to our needs.

unmerge.gif


This skill could be also used in Microsoft Office Excel and Openoffice.