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


How to split sheets quickly

Uploaded time: November 16, 2021 Difficulty Beginner

How to split sheets quickly

How to split sheets quickly

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.

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