WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


Split Books by Sheet

Uploaded time: January 25, 2022 Difficulty Beginner

Split Books by Sheet

Split Books by Sheet

Do you know how to split your worksheet?

Take this table as an example. Seeing the sales performance from January to July, we need to split the monthly sales into individual workbooks and send them to the leader. It is too cumbersome to copy and paste the data one by one and generate new files. Fortunately, we can use the function of Split Books by Sheet.

In this table, we click the Data tab, then click the Split Sheet drop-down button, and select Split Books By Sheet in the drop-down menu.

In the pop-up dialog box, the system has checked all worksheets for us by default (except those hidden worksheets).

If you don't want to miss those hidden worksheets as well, you can click the option Contains hidden worksheets in the upper right corner.

Finally, decide where we want to save them and click Start.

When we open the folder, wefind that all worksheets are split into separate workbooks.

This is all about Split Books by Sheet, did you get it?

Excel is the most powerful tool to manage and analyze various types of Data. This free WPS Spreadsheet tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process. 

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.