How to Use WPS Merge Tables on Windows

Use WPS Merge Tables through 3 how-to topics, and all 3 are membership-related; choose an entry point from the index, then set the merge method and parameters to complete the task.

How-to Index

How-to Guide

1. Merge Tables from Smart Toolbox

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

1. Click the Member Exclusive tab.
2. Click Smart Toolbox to open the Smart Toolbox tab.
3. Click the Merge Tables drop-down menu.
4. Select the merge method you need, including Merge into One Worksheet, Merge Worksheets by Same Sheet Name, Match and Merge Sheet Data by Same Column Content, Consolidate into One Workbook, Consolidate Workbooks by Same Sheet Name, or Merge Workbooks.
5. Set the merge parameters for the current task.
6. Click OK to start merging.

Success Criteria

• Interface result: the merge settings window opens and the available merge methods can be selected.
• Next action available: after you click OK, the merge starts and a result is generated.

Tips While Using

• Membership: all merge methods in this section require WPS Premium.
• Common mistake: starting the task before confirming the correct merge method may produce an unexpected result.
• Environment note: large data sets may take longer to process.

2. Merge Tables from the Home tab

Feature entry: Home tab → 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, including Merge into One Worksheet, Merge Worksheets by Same Sheet Name, Match and Merge Sheet Data by Same Column Content, Consolidate into One Workbook, Consolidate Workbooks by Same Sheet Name, or Merge Workbooks.
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: after the parameters are set, the merge task can start normally.

Tips While Using

• Membership: all merge methods in this section require WPS Premium.
• Common mistake: confusing the Worksheet menu with other data-related menus may lead to the wrong entry point.
• Environment note: merging large amounts of data may take more time.

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, including Merge into One Worksheet, Merge Worksheets by Same Sheet Name, Match and Merge Sheet Data by Same Column Content, Consolidate into One Workbook, Consolidate Workbooks by Same Sheet Name, or Merge Workbooks.
4. Set the merge parameters.
5. Click OK to start merging.

Success Criteria

• Interface result: the Merge Tables entry is visible in the right-click menu.
• Next action available: after entering the parameter settings window, you can continue and complete the merge.

Tips While Using

• Membership: all merge methods in this section require WPS Premium.
• Common mistake: if you right-click outside the worksheet tab bar, the related menu entry will not appear.
• Environment note: before merging, it is helpful to confirm that the sheet structures are consistent so the result is easier to review.