When using Split Table, common questions usually focus on naming, original-sheet retention, and preparation before splitting; this FAQ includes 3 common questions and a glossary.
FAQ
How are worksheets named after splitting?
- Select a split method such as Split Worksheet by Content and set the required parameters.
- After the split runs, worksheets are named automatically based on the values in the split column.
- If you need a unified naming style, rename the worksheets manually after the split is complete.
Does the original worksheet remain after splitting?
- After the split task is completed, the original worksheet remains in place.
- The split results are generated as new worksheets.
- If further cleanup is needed, review the results first and then remove any unnecessary content.
What should I check before splitting a table?
- Check whether the split column contains clear and distinguishable category values.
- Estimate whether the task will generate a large number of worksheets.
- Save the current file before running the split so you can review the results later.
Glossary
| Term | Definition |
|---|---|
| Split Table | A feature that splits one worksheet or workbook into multiple results based on a selected method. |
| Split Worksheet by Content | A method that splits data into multiple worksheets based on the values in a selected column or content category. |
| Split Workbook by Worksheet | A method that separates one workbook according to its existing worksheet structure. |
| Smart Toolbox | A WPS entry point that groups multiple productivity tools together. |