How to Use WPS Split Table on Windows

Use WPS Split Table through 3 operation topics in the spreadsheet collaboration interface; 3 items are available without membership and 0 items are membership-related.

How-to Index

How-to Guide

1. Open Split Table

Feature path: Data → Split Table

1. Open a WPS Sheets online collaborative file.
2. Click the Data tab at the top.
3. Find the Split Table button on the toolbar.
4. Click it to open the split panel and view the Split by Content and Split by Worksheet tabs.

Success Criteria

• Interface result: the Split Table dialog is displayed.
• Next action available: you can switch between split methods and configure options.

Tips While Using

• Common mistake: if the file is not opened in an online collaborative scenario, the related workflow may not be available.
• Environment note: a network connection and file editing permission are required.

2. Split Data by Content

Feature path: Data → Split Table → Split by Content

1. Keep the Split by Content tab selected in the split panel.
2. Click the Split Range box, then drag to select the data range in the sheet, or enter the cell range directly.
3. Select or clear Data contains headers based on your data.
4. Open the Split By drop-down list and choose the column used for grouping.
5. Choose how to save the results: to different new worksheets or to different new documents.
6. If you save to new documents, review the default save location and click Change if needed.
7. Click Split Now to run the operation.

Success Criteria

• Interface result: new worksheets appear, or multiple separate cloud documents are created in the selected location.
• Next action available: you can open, edit, or share the split results.

Tips While Using

• Common mistake: if the selected range does not include the target column, the Split By option may not work as expected.
• Environment note: saving as new documents requires a stable network and an available cloud document path.

3. Split a Workbook by Worksheet

Feature path: Data → Split Table → Split by Worksheet

1. Switch to the Split by Worksheet tab in the split panel.
2. In the tree list, select the worksheets that should become separate documents.
3. If needed, turn on Include hidden worksheets.
4. Confirm the save path for the split results and click Change if you want another location.
5. Click Split Now to create separate cloud documents.

Success Criteria

• Interface result: the selected worksheets are created as separate documents.
• Next action available: each document can be opened for continued collaboration or distribution.

Tips While Using

• Common mistake: if you do not review the selected items, some worksheets may be left out.
• Environment note: after separate cloud documents are created, sharing permissions may need to be managed for each file.