Merge and Split Cells in WPS on Windows FAQ

Q: What is the difference between Unmerge Cells and Split and Fill Content?

Unmerge Cells mainly restores the merged area to a normal cell structure. Split and Fill Content restores the structure and also applies content filling based on the current feature result. Before making a final change, test both options in a copy of the worksheet if needed.

When using Merge and Split Cells, the most common questions focus on data retention, sorting and filtering impact, and the difference between split options; this section includes 3 common answers.

FAQ

Will data be lost after I merge cells?

Check whether multiple cells in the selected range already contain content.
Make sure the content in the upper-left cell is the one you want to keep.
If content from other cells is still needed, copy it elsewhere before merging.

Do merged cells affect sorting and filtering?

If the worksheet will later be sorted or filtered, decide whether merged cells are really necessary.
Keep data regions in separate cells whenever possible, and use merged cells mainly for headers or notes.
If merged cells already affect data handling, unmerge them before sorting or filtering.

What is the difference between Unmerge Cells and Split and Fill Content?

Unmerge Cells mainly restores the merged area to a normal cell structure.
Split and Fill Content restores the structure and also applies content filling based on the current feature result.
Before making a final change, test both options in a copy of the worksheet if needed.

Glossary

Term	Definition
Merge & Center	Combines adjacent cells into one cell and places the content in the middle.
Merge Across Rows	Merges each row separately within a selected range, which is useful for multi-row headers or labels.
Unmerge Cells	Restores a merged cell area back into separate individual cells.
Split and Fill Content	Splits a merged area and fills content according to the current feature behavior.