How to Use WPS Split Table on Windows

Use Split Table with 3 how-to topics, including the Split Table entry, Split by Content, and Split by Worksheet; 3 items are available without membership and 0 items are membership-related.

How-to Index

How-to Guide

1. Split Table Entry

Entry: Data tab → Split Table

1. Open a smart spreadsheet file.
2. Click the Data tab at the top of the window.
3. Find the Split Table button on the toolbar.
4. Click it to open the dialog box.
5. Confirm that the Split by Content and Split by Worksheet tabs are available at the top of the dialog box.

Success Criteria

• Interface result: the Split Table dialog box opens.
• Next action available: you can continue with Split by Content or Split by Worksheet.

Tips While Using

• Common mistake: if a smart spreadsheet is not open first, the related interface may not be available.
• Environment note: keep your network connection available if you plan to save results to cloud documents.

2. Split by Content

Entry: Data tab → Split Table → Split by Content

1. Open Split Table and stay on, or switch to, the Split by Content tab.
2. Click the Split range box, then drag to select the data range in the sheet, or enter the cell range directly.
3. Turn Data contains header on or off as needed.
4. Open the Split basis drop-down list and choose the column used for splitting.
5. Choose how to save the results: different new worksheets or different new documents.
6. If you choose new documents, click Change to adjust the save path if needed.
7. Click Split Now to run the split.

Success Criteria

• Interface result: after the split, you can see new worksheets or new files in the target location.
• Next action available: you can open any split result and continue editing, saving, or sharing it.
• No unwanted change: the original source data remains in the current source sheet.

Tips While Using

• Common mistake: if the selected range does not include the actual data columns, the split basis may not be available correctly.
• Environment note: saving as different new documents requires an available target path or cloud document location.
• Usage tip: if the first row contains field names, keep Data contains header turned on so each result is easier to identify.

3. Split by Worksheet

Entry: Data tab → Split Table → Split by Worksheet

1. Open the Split Table dialog box and switch to the Split by Worksheet tab.
2. In the tree area, select the worksheets that you want to split into separate documents.
3. If you want to split hidden worksheets too, turn on Include hidden worksheets.
4. Confirm the path shown for Save split worksheets to.
5. Click Change if you need a different save path.
6. Click Split Now to run the split.

Success Criteria

• Interface result: the selected worksheets are generated as separate documents.
• Next action available: you can open each new document and continue working on it.
• No unwanted change: the worksheet structure in the original workbook stays unchanged.

Tips While Using

• Common mistake: if target worksheets are not selected, no corresponding split result is created.
• Environment note: saving to cloud documents requires a network connection.
• Usage tip: check worksheet names before splitting so the generated files are easier to identify.