WPS Duplicate Items on macOS FAQ

When using WPS Duplicate Items on macOS, common questions usually involve restoring data, keeping deduplicated results, and understanding the difference between related actions; this FAQ includes 4 common questions and a glossary.

FAQ

Can I restore data after deleting duplicate items?

1. If you just deleted duplicate items and have not made other overwrite actions, try Undo first.
2. If the file has already been saved, check whether a backup copy or version history is available.
3. Before deleting duplicates in a formal worksheet, copy the original data to a new sheet first.

How do I keep only non-duplicate data?

1. Select the range that contains repeated data.
2. Open Delete Duplicate Items from the Data tab.
3. Choose the columns used to identify duplicates and run the command. The remaining results are the deduplicated results.

Does highlighting duplicate items delete data?

1. No.
2. Highlight Duplicate Items only marks repeated content for review.
3. If you want to remove repeated records, use Delete Duplicate Items instead.

What is the difference between Reject Duplicate Entry and Delete Duplicate Items?

1. Reject Duplicate Entry works during input and helps reduce newly added repeated content.
2. Delete Duplicate Items works on existing data and removes repeated records that are already there.
3. If you want to clean existing data and also control future input, delete duplicates first and then turn on Reject Duplicate Entry.

Glossary