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

  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. Choose a splitting method
  • Split worksheet by content (requires membership)
  • Split workbook by worksheet (requires membership)
  • Split workbook (requires membership)
  1. Set the splitting parameters
  2. Click OK to start splitting

imageimage

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. Choose a splitting method
  • Split worksheet by content (requires membership)
  • Split workbook by worksheet (requires membership)
  • Split workbook (requires membership)
  1. Set the splitting parameters
  2. Click OK to start splitting

image

Splitting Sheets from the Right-Click Context Menu

Feature Entry

"Worksheet" tab bar → Right-click an existing worksheet tab → "Split Sheet" dropdown menu

  1. Right-click an existing worksheet tab
  2. Click the ** "Split Sheet" ** dropdown menu
  3. Choose a splitting method
  • Split worksheet by content (requires membership)
  • Split workbook by worksheet (requires membership)
  • Split workbook (requires membership)
  1. Set the splitting parameters
  2. Click OK to start splitting

image

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