How to Use WPS Split Table on macOS

Use Split Table through 3 how-to topics, with 3 available without membership and 0 membership-related items, then jump from the index to the steps you need.

How-to Index

How-to Guide

1. Open the Split Table entry

Entry path: Data → Split Table

1. Open a smart spreadsheet 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 dialog box.
5. Confirm that the Split by Content and Split by Worksheet tabs are visible at the top.

Success Criteria

• Interface result: the Split Table dialog box opens.
• What you can do next: you can continue with content-based splitting or worksheet-based splitting.

Tips While Using

• Common mistake: if a smart spreadsheet is not open first, you may not be able to continue with the split workflow.

2. Split a table by content

Entry path: Data → Split Table → Split by Content

1. Open Split Table and stay on 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. Click the Split by drop-down arrow and choose the column used as the split condition.
5. Choose how to save the results: to different new worksheets or to different new documents.
6. If you save to new documents, click Change to adjust the save path when needed.
7. Click Split now to run the task.

Success Criteria

• Interface result: multiple split results are created.
• What you can do next: you can review the new worksheets or open the new files in the cloud location.

Tips While Using

• Common mistake: if the selected split range does not include the target column, the Split by field may not work as expected.
• Environment note: saving to different new documents requires network access and account support for cloud saving.

3. Split a workbook by worksheet

Entry path: Data → Split Table → Split by Worksheet

1. Open the Split Table dialog box.
2. Switch to the Split by Worksheet tab.
3. In the tree list, select the worksheets you want to split.
4. If needed, turn on Include hidden worksheets.
5. Confirm the path shown for where the split worksheets will be saved.
6. Click Change if you want to use a different save path.
7. Click Split now to finish.

Success Criteria

• Interface result: the selected worksheets are generated as separate result documents.
• What you can do next: you can open each separate document from the save location for editing or sharing.

Tips While Using

• Common mistake: if the target worksheets are not selected, they will not appear in the split results.
• Environment note: splitting into separate cloud documents requires an available internet connection.