How to Use WPS Duplicate Items on macOS

Use WPS Duplicate Items on macOS with 6 how-to topics, including highlighting duplicates, clearing highlights, counting duplicate occurrences, rejecting duplicate entry, clearing the restriction, and deleting duplicates; use the index below to jump to the task you need.

How-to Index

How-to Guide

1. Highlight Duplicate Items

Feature path: Data → Duplicate Items → Set Highlight Duplicate Items

1. Select the cell range that you want to check.
2. Click the Duplicate Items drop-down menu on the Data tab.
3. Select Set Highlight Duplicate Items.
4. Check whether repeated data is shown with a red background.

Success Criteria

• On-screen result: Repeated content in the selected range is clearly marked.
• What you can do next: You can continue reviewing, filtering, or deleting duplicate items.

Tips While Using

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

2. Clear Highlighted Duplicate Items

Feature path: Data → Duplicate Items → Clear Highlight Duplicate Items

1. Select the cell range where highlights were previously applied.
2. Click the Duplicate Items drop-down menu on the Data tab.
3. Select Clear Highlight Duplicate Items.
4. Confirm that the existing highlight marks are removed.

Success Criteria

• On-screen result: The highlight background on duplicate items is removed.
• What you can do next: You can apply highlighting again or continue with other data-processing tasks.

Tips While Using

• Common mistake: If you select a different range, the original highlighted area may not be cleared.

3. Count Duplicate Occurrences

Feature path: Data → Duplicate Items → Count Duplicate Occurrences

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

Success Criteria

• On-screen result: A chart or statistical result appears for repeated text in the selected range.
• What you can do next: You can decide whether to continue with duplicate cleanup based on the result.

Tips While Using

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

4. Reject Duplicate Entry

Feature path: Data → Duplicate Items → Reject Duplicate Entry

1. Select the cell range where you want to restrict input.
2. Click the Duplicate Items drop-down menu on the Data tab.
3. Select Reject Duplicate Entry.
4. During later input, check for a reminder when repeated content is entered.

Success Criteria

• On-screen result: A check or reminder appears when duplicate content is entered.
• What you can do next: You can revise the input and continue entering data.

Tips While Using

• Common mistake: If you do not confirm the target range first, the restriction may be applied to the wrong cells.

5. Clear Reject Entry Restriction

Feature path: Data → Duplicate Items → Clear Reject Entry Restriction

1. Select the range where duplicate-entry restriction was previously applied.
2. Click the Duplicate Items drop-down menu on the Data tab.
3. Select Clear Reject Entry Restriction.
4. Enter content again and confirm that duplicate checking no longer appears.

Success Criteria

• On-screen result: Duplicate-entry reminders no longer appear.
• What you can do next: You can return to normal data-entry work.

Tips While Using

• Common mistake: If the original restricted range is not selected, the restriction may not be fully cleared.

6. Delete Duplicate Items

Feature path: Data → Data Tools → Delete Duplicate Items

1. Select the cell range that contains the data.
2. Click Delete Duplicate Items on the Data tab.
3. Select the columns used to identify duplicates.
4. Run the command to remove duplicates and keep deduplicated results.

Success Criteria

• On-screen result: Repeated records are removed and deduplicated results remain in the spreadsheet.
• What you can do next: You can save, filter, or analyze the cleaned data.

Tips While Using

• Common mistake: If you do not confirm the columns used to identify duplicates, more data than expected may be removed.
• Environment note: Deleting duplicates directly changes the current selection, so backing up the original data first is recommended.