How to merge and split files

Uploaded time: August 17, 2022 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download

How to merge and split files

How to merge and split files

In this lesson, we've learned the following key points:

When we analyze statistical data, it is always inevitable to merge or split worksheets. WPS Spreadsheet provides a very convenient tool to help you merge and split files quickly.

1. How to merge files?

Click the Data> Merge Sheet where the system provides six types of merging methods, from which you can choose the one most meets your needs. Also, it supports both merging multiple worksheets into one worksheet and merging multiple worksheets into one workbook.

 

2. How to split files?

Click the Data> Split Sheet where the system provides three kinds of splitting methods, which are Split Sheet by content, Split book by sheets, and Split book.