How to Use WPS Duplicates on Windows

Use WPS Duplicates across 6 task topics, all available without membership; choose a task from the index to review, restrict, or remove duplicate data efficiently.

How-to Index

How-to Guide

1. Highlight Duplicates

Feature path: Data tab → Duplicates → Set Highlight Duplicates

1. Select the cell range you want to check.
2. Click the Duplicates drop-down menu on the Data tab.
3. Select Set Highlight Duplicates.
4. Review the duplicate data shown with a red background.

Success Criteria

• Interface result: Duplicate content in the selected range is visibly marked.
• What you can do next: You can continue reviewing, editing, or removing duplicate data.

Tips While Using

• Common mistake: If you do not select the target range first, the result may not match your expectation.
• Environment note: Highlighting only marks data and does not delete original values.

2. Clear Highlight Duplicates

Feature path: Data tab → Duplicates → Clear Highlight Duplicates

1. Select the range where duplicate highlighting has been applied.
2. Click the Duplicates drop-down menu on the Data tab.
3. Select Clear Highlight Duplicates.
4. Confirm that the duplicate marks are removed from the worksheet.

Success Criteria

• Interface result: The previous red highlight marks are cleared.
• What you can do next: You can apply highlighting again or continue with other duplicate-handling tasks.

Tips While Using

• Common mistake: If the selected range does not include the highlighted area, you may not notice a visible change.

3. Count Duplicate Occurrences

Feature path: Data tab → Duplicates → Count Duplicate Occurrences

1. Select the cell range you want to analyze.
2. Click the Duplicates drop-down menu on the Data tab.
3. Select Count Duplicate Occurrences.
4. Review the generated statistics or chart.

Success Criteria

• Interface result: The app generates a duplicate-count result for the selected content.
• What you can do next: You can decide whether to remove or adjust data based on the count result.

Tips While Using

• Common mistake: If the selected range is too large or includes unrelated columns, the result may be harder to interpret.

4. Reject Duplicate Entry

Feature path: Data tab → Duplicates → Reject Duplicate Entry

1. Select the cell range where you want to restrict input.
2. Click the Duplicates drop-down menu on the Data tab.
3. Select Reject Duplicate Entry.
4. When repeated content is entered later, review the prompt and adjust the value.

Success Criteria

• Interface result: A prompt appears when duplicate content is entered.
• What you can do next: You can revise the value and continue entering data.

Tips While Using

• Common mistake: If you do not select the target range first, the restriction will not apply where expected.
• Environment note: This setting controls future input and does not automatically clean existing duplicates.

5. Clear Duplicate Entry Restriction

Feature path: Data tab → Duplicates → Clear Duplicate Entry Restriction

1. Select the range where the restriction has been applied.
2. Click the Duplicates drop-down menu on the Data tab.
3. Select Clear Duplicate Entry Restriction.
4. Enter content again and confirm that duplicate-check prompts no longer appear.

Success Criteria

• Interface result: The duplicate-entry restriction is removed.
• What you can do next: You can continue entering data normally.

Tips While Using

• Common mistake: If the original restricted range is not selected, the setting may not be cleared as intended.

6. Remove Duplicates

Feature path: Data → Data Tools → Remove Duplicates

1. Select the cell range that contains the data.
2. Click Remove Duplicates on the Data tab.
3. Select the columns used to determine duplicates.
4. Confirm the action to remove repeated entries and keep deduplicated results.

Success Criteria

• Interface result: Duplicate content is removed and deduplicated results remain in the worksheet.
• What you can do next: You can continue saving, analyzing, or exporting the cleaned data.

Tips While Using

• Common mistake: Choosing the wrong columns can change the deduplication result.
• Environment note: This action changes current data directly, so backing up the worksheet first is recommended.