How to Use WPS Duplicates on Windows

Use WPS Duplicates with 2 how-to topics, including Highlight Duplicates and Remove Duplicates; 2 topics are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Highlight Duplicates

Entry: Data → Duplicates → Highlight Duplicates

1. Select the cell range where you want to check repeated values.
2. Click the Duplicates button on the Data tab.
3. Select Highlight Duplicates.
4. Choose a color in the dialog box.
5. Review the cells that are filled with the selected color.

Success Criteria

• On-screen result: Cells with repeated values are marked with the selected color.
• What you can do next: You can continue reviewing the data or move on to Remove Duplicates.

Tips While Using

• Common mistake: If you do not select the target range first, the checked range may not match your expectation.
• Environment note: Duplicate detection uses exact matching, so only fully identical content is treated as duplicate data.

2. Remove Duplicates

Entry: Data → Duplicates → Remove Duplicates

1. Select the data range that contains repeated data, usually including the header row.
2. Click Duplicates, then select Remove Duplicates.
3. In the dialog box, select the columns used to determine duplicates.
4. Click OK to run the cleanup.
5. Review the result message and confirm how many duplicate records were removed.

Success Criteria

• On-screen result: Later duplicate rows are removed and the first record is kept.
• What you can do next: You can continue editing, save the file, or undo the action.

Tips While Using

• Common mistake: If the selected columns are not set correctly, the cleanup scope may be too broad or too narrow.
• Environment note: When many cells are involved, the process may take some time to finish.