How to Use WPS Duplicate Items on Windows

Use Duplicate Items with 2 how-to topics, including Highlight Duplicates and Remove Duplicates; choose a topic from the How-to Index and follow the feature path and steps.

How-to Index

How-to Guide

1. Highlight Duplicates

Feature path: Data tab → Duplicate Items → Highlight Duplicates

1. Select the cell range that you want to check for repeated content.
2. Click the Data tab at the top of the window.
3. Click the Duplicate Items button.
4. Select Highlight Duplicates.
5. Choose a marking color in the dialog box.
6. Review the cells that are filled with the selected color.

Success Criteria

• Interface result: Cells with duplicate data are marked with the selected color.
• What you can do next: You can continue filtering, editing, or deleting the marked data.

Tips While Using

• Common mistake: If you do not select the target range first, the check may not run on the intended data.
• Environment note: The result depends on the current selection, so confirm whether headers or blank columns are included.

2. Remove Duplicates

Feature path: Data tab → Duplicate Items → Remove Duplicates

1. Select the data range that contains duplicate records, usually including headers.
2. Click Duplicate Items on the Data tab.
3. Select Remove Duplicates.
4. In the dialog box, select the columns used to determine duplicates.
5. Click OK to keep the first retained record and remove later duplicate rows.
6. Review the prompt that shows how many duplicate records were removed.

Success Criteria

• Interface result: Duplicate rows are removed and the remaining records stay in the sheet.
• What you can do next: You can continue saving, filtering, or exporting the cleaned data.

Tips While Using

• Common mistake: If the selected columns are not correct, the cleanup result may differ from what you expect.
• Environment note: It is a good idea to back up the original data before removing duplicates.