How to unmerge cells in WPS Spreadsheet
September 14, 2026
15.1K
Views
52
1. Select the cell that needs to be unmerged.
2. Click the Home tab → and then click the drop-down button of Merge and Center.
3. Now we can see Unmerge Cells and Unmerge and Fill.
· Unmerge Cells
Click Unmerge Cells. Now we can see the cell has been unmerged, but only the first cell has been filled with content.
· Unmerge and Fill
Click Unmerge and Fill. Now we can see the cell has been unmerged and all the cells have been filled with content.
This skill could also be used in Microsoft Office Excel and OpenOffice.
Also Read:
- 1. How to Adjust Excel Cells to Fit Text
- 2. How To Insert Picture In WPS Spreadsheet: A Step-by-Step Guide
- 3. How to shade every other row in WPS Spreadsheet
- 4. How to Copy Visible Cells Only in WPS Spreadsheet [A Step-by-Step Guide]
- 5. How to expand cells to fit text in Excel
- 6. How to Make All Excel Cells Equal Size in WPS Office: Guide for Beginners
15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.
