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 by content

Uploaded time: September 30, 2021 Difficulty Beginner

How to split sheets by content

How to split sheets by content

When you want to split the content based on the specific categories in the sheet, are you still disassembling and reorganizing the content one by one? The Split Sheet feature can help you.

Take this sheet as an example. If we want to split this sheet into three sheets based on class 1, class 2 and class 3, what should we do? We just need to click the Home tab and click Worksheet, then click the Split Sheet option, finally choose Split Sheets By Content.01.gif

In the Split area box, we can choose the areawe need to split in the sheet. We can check Has title according to whether the actual reference area contains titles.

In the Split basis box, we can choose the basis for splitting the sheet. Because we want to split the summary table into three sheets by class, we select Class(Column C) in this box.02.gif

Finally, we can choose Different new file or Different new sheets. When we finish settings, click Start to split the sheet.03.gif

What a practical feature! Did you get it?To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

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