Common questions about WPS Split Table usually focus on split criteria, result syncing, and collaboration impact; this FAQ covers 3 frequent questions and practical answers.
FAQ
Why is the Split By drop-down list empty?
- Check whether the selected Split Range includes actual data columns.
- Confirm that the selected range includes the header row.
- If the first row is a header, turn on Data contains headers.
- Open the Split By drop-down list again and select the target column.
Do split results stay synced with the source sheet?
- Split results work as separate copies.
- Later updates in the source sheet do not sync automatically to existing split results.
- If you need the latest data, run the split again.
Will Split Table affect other collaborators in a shared file?
- The split operation creates actual changes in the current file or in the generated cloud documents.
- If you create new worksheets, collaborators may notice changes in the workbook structure.
- If you create new documents, the original collaborative file is affected less, but the new files need separate sharing management.
Glossary
| Term | Definition |
|---|---|
| Split by Content | A method that divides one data range into multiple result groups based on different values in a selected column. |
| Split by Worksheet | A method that exports multiple worksheets from one workbook as separate documents. |
| Split By | The target column used to determine the grouping rule during content-based splitting. |