WPS Features
Resources
Free AI Tools
Docs Center

How to Use WPS Split Table on Windows

Last updated:July 16, 2026

Use WPS Split Table through 3 how-to topics; all 3 are membership-related, and you can choose the entry point that matches your workflow.

How-to Index

#TopicMembership
11. Split Table from Smart ToolboxWPS Premium required
22. Split Table from the Home tabWPS Premium required
33. Split Table from the right-click menuWPS Premium required

How-to Guide

1. Split Table from Smart Toolbox

Entry point: Premium tab → Smart Toolbox → Smart Toolbox tab → Split Table drop-down menu

  1. Click the Premium tab.
  2. Select Smart Toolbox to open the Smart Toolbox tab.
  3. Click the Split Table drop-down menu.
  4. Select a split method: Split Worksheets by Content, Split Books by Sheet, or Split Workbook.
  5. Set the split parameters as needed.
  6. Click OK to start splitting.

Success Criteria

  • UI state: A split result appears, or new worksheets or output files are created.
  • Next actions: You can review, save, or share the split results.
  • No side effects: The original sheet remains available.

Tips While Using

  • Common mistakes: Confirming before choosing the correct split method may produce an unexpected result.
  • Membership: This topic requires WPS Premium.
  • Environment limits: Keep your network available if account sign-in is needed.

2. Split Table from the Home tab

Entry point: Home tab → Worksheet drop-down menu → Split Table drop-down menu

  1. Click the Home tab.
  2. Open the Worksheet drop-down menu.
  3. Click the Split Table drop-down menu.
  4. Select a split method: Split Worksheets by Content, Split Books by Sheet, or Split Workbook.
  5. Set the split parameters.
  6. Click OK to start splitting.

Success Criteria

  • UI state: New worksheets or output results appear after the split is complete.
  • Next actions: You can check names, content, and save locations.
  • No side effects: The original data remains available for review.

Tips While Using

  • Common mistakes: Running the split in the wrong workbook can affect the result, so confirm the current file first.
  • Membership: This topic requires WPS Premium.

3. Split Table from the right-click menu

Entry point: Sheet tab bar → right-click an existing sheet tab → Split Table drop-down menu

  1. On the sheet tab bar at the bottom, right-click an existing sheet tab.
  2. Click the Split Table drop-down menu.
  3. Select a split method: Split Worksheets by Content, Split Books by Sheet, or Split Workbook.
  4. Set the split parameters.
  5. Click OK to start splitting.

Success Criteria

  • UI state: The right-click entry opens the split settings window normally.
  • Next actions: After splitting, you can review new worksheets directly from the tab bar.
  • No side effects: The original worksheet remains available.

Tips While Using

  • Common mistakes: If you right-click outside the sheet tab, the related menu will not appear.
  • Membership: This topic requires WPS Premium.