How to Use WPS Duplicates on macOS

Use WPS Duplicates on Mac with 2 how-to topics, both available without membership; start from the How-to Index to highlight repeated values or remove duplicate rows.

How-to Index

How-to Guide

1. Highlight Duplicates

Entry point: Data tab → Duplicates → Highlight Duplicates

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

Success Criteria

• UI state: Cells with duplicate data are marked with the selected color.
• Next actions: You can continue filtering, reviewing, or removing duplicates.

Tips While Using

• Common mistakes: If you do not select the target range first, the duplicate check may not run on the data you expect.
• Environment limits: Duplicate checks use exact cell content matching, so only fully identical content is treated as a duplicate.

2. Remove Duplicates

Entry point: Data tab → Duplicates → Remove Duplicates

1. Select the data range that contains duplicate data, preferably including headers.
2. Click Duplicates and then select Remove Duplicates.
3. In the dialog box, select the columns that should be used to judge duplicates.
4. Click OK. WPS keeps the first occurrence and removes later duplicate rows.
5. Review the result message to confirm how many duplicate entries were removed.

Success Criteria

• UI state: Duplicate rows are removed and a result message appears.
• Next actions: You can continue saving, analyzing, or exporting the cleaned spreadsheet.

Tips While Using

• Common mistakes: If the wrong columns are selected, the removal result may not match your expectation.
• Environment limits: Check the result right away after removal. If needed, use Command+Z promptly to undo the change.