How to split sheets by content

Uploaded time: September 30, 2021 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

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.