Split Books by Sheet

Uploaded time: January 25, 2022 Difficulty: Beginner

Split Books by Sheet

Split Books by Sheet

Tips: you can turn on the volume by clicking

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.

_1.gif

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

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

_2.gif

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.