WPS Split Table on macOS FAQ

Last updated:July 20, 2026

When using Split Table, the most common questions focus on split conditions, result syncing, collaboration impact, and output format. This FAQ covers 4 common questions.

FAQ

Why is the Split by drop-down list empty when I split by content?

  1. Check whether the Split range has been set correctly.
  2. Make sure the selected range includes the column you want to use as the split condition.
  3. If the first row contains field names, turn on Data contains header.
  4. Open the Split by drop-down list again and choose the target column.

Do the split results stay linked to the source table?

  1. The split results are created as separate copies.
  2. If the source table changes later, the split results do not update automatically.
  3. If you need the latest results, run the split again.

Will other collaborators see changes after I use Split Table in a shared file?

  1. If the split action adds worksheets or creates new documents, it changes the current file structure.
  2. Before running the task in a shared file, it is a good idea to confirm the timing with your team.
  3. If you save to different new documents, the impact on the original shared file is smaller.

Will formatting change after the split?

  1. The new results remain in smart spreadsheet form after the split.
  2. If you need another file format, export the split result after the task is complete.
  3. Before exporting, review the content and structure to make sure they match your needs.

Glossary

TermDefinition
Split by ContentSplits one selected data range into multiple results based on different values in a chosen column.
Split by WorksheetSplits multiple worksheets in the current workbook into separate result documents.
Data contains headerMeans the first row of the selected range is treated as the header row and kept in each split result.
Cloud documentA document saved in a cloud location for later access, sharing, and management.