Full analysis of WPS table merging techniques

When we use WPS spreadsheets for work, we often need to merge multiple cells into one cell.

The WPS table merging and centering function has multiple merging methods. The following will explain in detail how to use this function.

1. Merge centered cells

How to merge the contents of multiple cells into one cell and display it in the center?

Select the area that needs to be merged, click on the upper menu bar - Merge and Center, its shortcut key is Ctrl+M.

In this way, multiple cells can be merged and displayed in the center.

2. Merge cells

How to merge cells without centering them?

Select the area that needs to be merged, click Merge Center - Merge Cells, so that the selected cells can be merged, but they will not be displayed in the center after merging.

3. Merge cell contents

How to merge the contents of the selected cell range into one cell?

Taking this table as an example, if we want to merge the contents of cells A1:A5, select cells A1:A5.

Click Merge Center-Merge Content to merge the content in the selected cell range into one cell.

4. Merge identical cells

How to merge cells with the same and adjacent content in the same column?

Taking this table as an example, we can see that the same content in the class column is adjacent. Select the cell range and click Merge Center - Merge the same cells.

In this way, cell contents with the same and adjacent content can be quickly merged into one cell.

5. Merge cells by rows

Taking this table as an example, we want to quickly merge the cells in the first four rows.

Select the cell range, click Merge Center - Merge by Row, and the selected range can be merged according to rows.

After briefly understanding the various ways to merge tables, how to cancel the merge?

Taking this table as an example, after selecting the merged cells, we can click the Merge Center button to quickly cancel the merge.

You can also select the merged cells and click Merge Center - Unmerge the cells.

If we want to split the content merged into one cell, select the merged cell and click Merge Center - Split and fill the content.