Multiple methods of merging cells
Uploaded time: August 26, 2021 Difficulty Beginner
A free Office suite fully compatible with Microsoft Office
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?
Trending Tutorials
Does this video help you?