How to split sheets quickly

Uploaded time: November 16, 2021 Difficulty: Primary

How to split sheets quickly

How to split sheets quickly

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

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 Sheet drop-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.

_1.gif

 

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.

_2.gif

 

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.

_3.gif

 

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.