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 certain column, making it easier to manage data by category.

Feature Description

Feature Dimension Description
Membership Restriction Membership required
Version Restriction No version restriction

Steps

Using Smart Toolbox to Split Sheets

Feature Entry
"Member Exclusive" tab → "Smart Toolbox" option → "Smart Toolbox" tab → "Split Sheet" dropdown menu

  1. Click the Member Exclusive tab
  2. Select the Smart Toolbox button to open the Smart Toolbox tab
  3. In the Smart Toolbox tab, click the "Split Sheet" dropdown menu
  4. Select a split method
  • Split worksheet by content (Membership required)
  • Split workbook by worksheet (Membership required)
  • Split workbook (Membership required)
  1. Set split parameters
  2. 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

  1. Click the Home tab
  2. Select the Worksheet dropdown menu
  3. Click the "Split Sheet" dropdown menu
  4. Select a split method
  • Split worksheet by content (Membership required)
  • Split workbook by worksheet (Membership required)
  • Split workbook (Membership required)
  1. Set split parameters
  2. Click OK to start splitting

截图

Splitting Sheets from the Right-Click Menu

Feature Entry
Sheet tab bar → Right-click an existing sheet tab → "Split Sheet" dropdown menu

  1. Right-click an existing sheet tab
  2. Click the "Split Sheet" dropdown menu
  3. Select a split method
  • Split worksheet by content (Membership required)
  • Split workbook by worksheet (Membership required)
  • Split workbook (Membership required)
  1. Set split parameters
  2. 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: Is the original sheet retained after splitting?

  • Solution: The original sheet is retained, and the split results are generated as new worksheets.

Notes

  • Ensure the split column has clear categorical values before splitting
  • Splitting may generate a large number of worksheets
  • You can also quickly find the Split Sheets feature under the Tools tab at the top.