When using WPS Duplicate Values on macOS, common questions usually involve undo, matching rules, and column selection; this FAQ covers 3 frequent questions.
FAQ
Can I undo Remove Duplicate Values after it finishes?
- Use Undo immediately after the deletion if you need to restore the data.
- If you have already made additional edits, the undo history may no longer restore the earlier state.
- Before deleting duplicates, it is recommended to copy the worksheet or back up the original data.
How do I remove duplicates based on only some columns?
- Select the target data range and open the Remove Duplicate Values dialog box.
- Clear the columns that should not be used for duplicate matching.
- Keep only the key columns selected, then confirm to run deduplication by those columns.
Why are some values that look the same not recognized as duplicates?
- Check whether the cell contents are exactly the same.
- Look for spaces, hidden characters, or formatting differences that may affect matching.
- If needed, standardize the data format first and then run highlight or removal again.
Glossary
| Term | Definition |
|---|---|
| Duplicate Values | Cells or records with the same content within the selected data range. |
| Highlight Duplicate Values | Marks repeated content with color for manual review without deleting data. |
| Remove Duplicate Values | Checks duplicates by selected columns, keeps the first record, and removes later repeated records. |