WPS Duplicates on Windows FAQ

Q: How do I remove duplicates based on only some columns?

Select the target data range and open the Remove Duplicates dialog box. Clear the columns that should not be used for duplicate checking. Keep only the key columns selected. Click OK to remove duplicates based on the selected columns.

Q: Does Remove Duplicates delete every repeated row?

Open Remove Duplicates and confirm the columns used for checking. Run the cleanup. The first occurrence is kept. Later repeated records are removed. If you want to review first, use Highlight Duplicates before cleanup.

When using WPS Duplicates, users often ask about 3 topics: undo recovery, duplicate-check scope, and removal results; this FAQ includes 3 common questions.

FAQ

Can I undo Remove Duplicates after it finishes?

After the cleanup finishes, avoid making too many additional edits right away.
Press Ctrl+Z immediately to undo the removal.
Check whether the original data has been restored.
If you need to run the cleanup again, back up the data first and then reselect the duplicate-check columns.

How do I remove duplicates based on only some columns?

Select the target data range and open the Remove Duplicates dialog box.
Clear the columns that should not be used for duplicate checking.
Keep only the key columns selected.
Click OK to remove duplicates based on the selected columns.

Does Remove Duplicates delete every repeated row?

Open Remove Duplicates and confirm the columns used for checking.
Run the cleanup.
The first occurrence is kept.
Later repeated records are removed. If you want to review first, use Highlight Duplicates before cleanup.

Glossary

Term	Definition
Duplicate	Data that is identified as repeated within the selected check range.
Highlight Duplicates	A command that marks repeated values with a fill color for visual review.
Remove Duplicates	A command that checks selected columns, keeps the first occurrence, and removes later repeated rows.