In WPS Spreadsheets, there are two ways of splitting sheets: Split Sheets By Content and Split Books By Sheet.

First, Split Sheets By Content.

Take this table as an example. We want to split this table into multiple sheets by month. Click the Data tab, click the Split Sheetdrop-down button and select Split Sheets By Content. The default Split area is the whole table. Check My data has headers to make the split sheets have titles.

Since we want to split the table by month, we select Month(Column D) in the Split basis area.

We can choose to split into new files or new sheets.

Here we check Different new sheets and click Start to split up four sheets by month.

Second, Split Books By Sheet.

We can also split all sheets in a spreadsheet into separate files. Click the Split Sheet drop-down button and select Split Books By Sheet. Check the four split sheets in the pop-up dialog, select a desired save position and click Start. Then we get four separate files.

This is the method of splitting sheets quickly. Did you get it?

For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.