- Image and text skills
When we use WPS tables for office work, we often need to merge multiple cells into one cell.
The WPS table merge and center function has multiple merge 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 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 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?
Take 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?
Take 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.
This way, cell contents with the same and adjacent content can be quickly merged into one cell.
5. Merge cells by row
Take this table as an example. We want to quickly merge the cells in the first four rows.
Select the cell area, click Merge Center - Merge by Row, and the selected area can be merged according to rows.
▪After briefly understanding the various ways to merge tables, how to cancel the merge?
Take this table as an example, select the merged cells, We can click the Merge and Center button, Quickly unmerge.
▪You can also select the merged cells, click Merge Center - Unmerge the cells.
▪If we want to split the content merged into one cell, Select the merged Cell, click Merge Center- to split and fill the content.
▪In Merge Center-Default Merge Method, you can set the default method of merging cells according to your own habits.
How about it? Do you know all about this function?
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/WPS-biao-ge-de-duo-zhong-he-bing-fang-shi.html
支付宝扫一扫 
评论列表（196条）
测试