How to Use WPS Duplicates on Android

Use WPS Duplicates on Android with 2 how-to topics, including removing duplicates and highlighting duplicates; choose a topic below and follow the entry path and steps to complete the task.

How-to Index

How-to Guide

1. Remove Duplicates

Entry path: Tools → Data → Highlight/Remove Duplicates → Remove Duplicates

1. Open the spreadsheet where you want to remove duplicates.
2. Tap Tools at the bottom of the screen.
3. Select the Data tab.
4. Tap Highlight/Remove Duplicates.
5. Tap Remove Duplicates.
6. Wait while WPS automatically detects duplicate items in the worksheet and removes them.

Success Criteria

• On-screen result: repeated data is cleaned up and the worksheet keeps the deduplicated result.
• What you can do next: you can continue editing, saving, or sharing the current spreadsheet.

Tips While Using

• Common mistake: removing duplicates before checking the data range may affect which original records remain.
• Environment note: removing duplicates changes the current data result directly, so review the content before you run it.

2. Highlight Duplicates

Entry path: Tools → Data → Highlight/Remove Duplicates → Highlight Duplicates

1. Open the spreadsheet where you want to check duplicates.
2. Tap Tools at the bottom of the screen.
3. Select the Data tab.
4. Tap Highlight/Remove Duplicates.
5. Select a color in Highlight Duplicates.
6. Wait while WPS automatically detects duplicate items in the worksheet and fills them with the selected color.

Success Criteria

• On-screen result: duplicate cells or related repeated content appear in the selected highlight color.
• What you can do next: you can continue reviewing the data and decide whether to remove duplicates afterward.

Tips While Using

• Common mistake: choosing an unsuitable color first may make later review less clear.
• Environment note: highlighting is for review assistance, and whether to delete data still requires your confirmation.