How to split the merged cells

November 4, 2021
65 Views 0

Graphic skills

In WPS Spreadsheet, we can unmerge the cells that has been merged.

1. Select the cell rage for recovery.

2. Go to the Home tab  Merge and Center dropdown button  choose Unmerge and Fill

How to split the merged cells 1.gif 

Remember to change the cell format after you unmerge the cells.

How to split the merged cells 2.gif 

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.