Multiple methods of merging cells

Uploaded time: August 26, 2021 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download

Multiple methods of merging cells

Multiple methods of merging cells

When we use the WPS Spreadsheet, we often need to merge and combine multiple cells.

Merge and Center in WPS spreadsheet offers multiple merging methods. We will explain in detail how to use this function.

Merge and Center

Select the cell area to be merged, click Home and find the drop-down menu of Merge and Center, and select Merge and Center or press keyboard shortcut Ctrl+M.In this way, the selected cells can be merged into one cell anddisplayed in the center.

Merge Cells

Select the cells to be merged, click on the drop-down menu of Merge and Center, and select Merge Cells. In this way, the contents in the area of the selected cells can be merged into one cell, but the merged cell is not displayed in the center.

Merge Contents

Merge Same Cells

Merge Across

In this example, we want to merge attendance of athletes by row. Select the area, click the drop-down menu of Merge and Center, and select Merge Across. In this way, the selected cell areas can be merged by row according to Merge Across.

Center Across

Click the drop-down menu of Merge and Center, and select Center Across. The data will be shown in the center of the merged cell. But the difference is that Center Across does not merge cells and center them. Instead, the display is centered across columns while preserving the cells.

How can we unmerge cells? 

In this spreadsheet, select the cells to be unmerged, click the drop-down menu of Merge and Center, and then select Unmerge Cells. If we want to fill the same content in every split cell, Select the merged cells, click the drop-down menu of Merge and Center, and select Unmerge and Fill

Easy your work with WPS Spreadsheet like Microsoft Excel. Did you get it?