How to Use WPS Split Table on macOS

Use Split Table through 3 indexed topics, with 0 free items and 3 membership-related items; choose an entry point from the index and complete the split settings to run the task.

How-to Index

How-to Guide

1. Use Smart Toolbox to split a table

Feature entry: Member Exclusive tab → Smart Toolbox → Split Table drop-down menu

1. Click the Member Exclusive tab.
2. Click Smart Toolbox to open the related panel.
3. In Smart Toolbox, click the Split Table drop-down menu.
4. Select a split method: Split Worksheet by Content, Split Workbook by Worksheet, or Split Workbook.
5. Set the required split parameters.
6. Click OK to start splitting.

Success Criteria

• The Split Table menu opens successfully and a split method is selected.
• The task starts normally after the parameters are set.
• Split results are generated in the current file or as corresponding output results.

Tips While Using

• The split methods in this entry are membership-related.
• Before splitting, confirm that the category field or worksheet structure is complete.
• If many results may be generated, save the current file first.

2. Split a table from the Home tab

Feature entry: 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 Worksheet by Content, Split Workbook by Worksheet, or Split Workbook.
5. Set the split parameters.
6. Click OK to start splitting.

Success Criteria

• The Split Table feature can be opened from the Home tab.
• The selected split method opens its parameter settings normally.
• The split task starts after confirmation.

Tips While Using

• This topic is membership-related.
• If the current spreadsheet contains a large amount of data, check the split scope and expected results first.
• Back up the original file before running the task if later verification is needed.

3. Split a table from the right-click menu

Feature entry: Worksheet tab bar → right-click an existing worksheet tab → Split Table drop-down menu

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

Success Criteria

• The Split Table entry is visible in the right-click menu.
• After a split method is selected, parameter settings can be continued.
• Clicking OK starts generating split results.

Tips While Using

• This topic is membership-related.
• The right-click entry is useful for quick actions in the current worksheet context.
• After splitting, check whether the names and content of the generated worksheets match your expectations.