How to Use Merge Tables in WPS on macOS

Use Merge Tables through 3 task topics that match 3 feature entry points; all 3 items are membership-related.

How-to Index

How-to Guide

1. Merge tables from Smart Toolbox

Feature entry: Member Exclusive → Smart Toolbox → Smart Toolbox tab → Merge Tables drop-down menu

1. Click the Member Exclusive tab.
2. Select Smart Toolbox to open the Smart Toolbox tab.
3. Click the Merge Tables drop-down menu.
4. Select the merge method you need, such as Merge multiple worksheets into a worksheet or Merge Book.
5. Set the merge parameters as needed.
6. Click OK to start merging.

Success Criteria

• Interface result: The merge settings window opens and available merge methods can be selected.
• Next action available: You can confirm parameters and continue the merge process.
• Final result: A new merged result is generated after processing.

Tips While Using

• The merge methods listed under this entry are membership features.
• Before merging, check whether field order and header rows are consistent across sheets.
• Large datasets may take longer to process.

2. Merge tables from the Home tab

Feature entry: Home → Worksheet drop-down menu → Merge Tables drop-down menu

1. Click the Home tab.
2. Open the Worksheet drop-down menu.
3. Click the Merge Tables drop-down menu.
4. Select the merge method you need.
5. Set the merge parameters.
6. Click OK to start merging.

Success Criteria

• Interface result: You can open the Merge Tables menu from the Home tab.
• Next action available: You can choose a merge method and finish parameter setup.
• Final result: WPS starts the merge process and outputs a result sheet or workbook.

Tips While Using

• This entry is useful when you want to start from the main ribbon area.
• The merge methods in this section are membership features.
• To reduce repeated headers, pay attention to options such as the starting row for merging.

3. Merge tables from the right-click menu

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

1. In the worksheet tab bar at the bottom, right-click an existing worksheet tab.
2. Click the Merge Tables drop-down menu.
3. Select the merge method you need.
4. Set the merge parameters.
5. Click OK to start merging.

Success Criteria

• Interface result: The Merge Tables entry appears in the right-click menu.
• Next action available: You can open merge settings directly and choose a method.
• Final result: A new merged result is created after the process finishes.

Tips While Using

• This entry is useful when you want to start directly from the current workbook.
• The merge methods in this section are membership features.
• Save the current file before merging so you can compare the result later.