- Picture and text skills
WPS provides a variety of modes for intelligently splitting and merging tables.
Before introducing this function, we must first distinguish between worksheets and workbooks.
A workbook is like a booklet, and worksheets are tables displayed in the workbook window, just like the content of the pages in the booklet.
Let me first introduce the split table to you.
The location to split the table is "Data" - "Split Table". Click "Split by content" to select the split area, split basis, and save path.
The split table can be saved as a different document or added as a new worksheet in the current workbook.
Click to start splitting to intelligently split similar content in the table.
"Split by worksheet" can split a workbook containing multiple worksheets into independent documents.
Select the save path, click Start Splitting, and the document will be automatically split into multiple documents.
Next, let me talk about merging tables. Merging tables provide three merging methods.
Merge multiple worksheets into one worksheet, that is, combine all worksheets in different workbooks into one worksheet.
Add the documents you want to merge, select the worksheets you want to merge, and click OK to quickly merge.
Merge worksheets with the same name in multiple workbooks.
This function is very smart. Add the documents to be merged and check the worksheets with the same name to be merged.
WPS will intelligently identify and merge worksheets with the same name into one worksheet.
Merge multiple workbooks into one workbook.
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-chai-fen-gong-neng-quan-jie-xi-zhi-neng-gong-ju-xiang-de-gao-xiao-ying-yong.html
支付宝扫一扫 
评论列表（196条）
测试