Feature Summary
The Split Sheet feature is used to split one worksheet into multiple worksheets based on specified criteria, such as splitting by the values in a column, making it easier to manage data by category.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | Requires a membership subscription |
| Version Restriction | No version restrictions |
Steps
Using the Smart Toolbox to Split Sheets
Feature Entry
"Member Exclusive" tab → "Smart Toolbox" option → "Smart Toolbox" tab → "Split Sheet" dropdown menu
- Click the Member Exclusive tab
- Select the Smart Toolbox button to open the Smart Toolbox tab
- In the Smart Toolbox tab, click the ** "Split Sheet" ** dropdown menu
- Choose a splitting method
- Split worksheet by content (requires membership)
- Split workbook by worksheet (requires membership)
- Split workbook (requires membership)
- Set the splitting parameters
- Click OK to start splitting


Splitting Sheets from the Home Tab on the Ribbon
Feature Entry
"Home" tab → "Worksheet" dropdown menu → "Split Sheet" dropdown menu
- Click the Home tab
- Select the Worksheet dropdown menu
- Click the ** "Split Sheet" ** dropdown menu
- Choose a splitting method
- Split worksheet by content (requires membership)
- Split workbook by worksheet (requires membership)
- Split workbook (requires membership)
- Set the splitting parameters
- Click OK to start splitting

Splitting Sheets from the Right-Click Context Menu
Feature Entry
"Worksheet" tab bar → Right-click an existing worksheet tab → "Split Sheet" dropdown menu
- Right-click an existing worksheet tab
- Click the ** "Split Sheet" ** dropdown menu
- Choose a splitting method
- Split worksheet by content (requires membership)
- Split workbook by worksheet (requires membership)
- Split workbook (requires membership)
- Set the splitting parameters
- Click OK to start splitting

FAQ
Q1: How are the split worksheets named?
- Solution: The Smart Toolbox automatically names the worksheets based on the values in the split column.
Q2: Does the original sheet remain after splitting?
- Solution: The original sheet is retained, and the split results are generated as new worksheets.
Notes
- Before splitting, ensure that the split column contains clear categorical values
- Splitting may generate a large number of worksheets