How to Use WPS Duplicates on Android

This section includes 2 how-to topics, and both are available without membership; use the index below to jump to the task you need.

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 duplicate data.
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 detects and removes duplicate items in the worksheet.

Success Criteria

• On-screen result: repeated data is processed and the number of duplicate rows is reduced.
• What you can do next: continue editing, save the file, or undo the action.

Tips While Using

• Common mistake: removing duplicates before checking the data range may affect original records.
• Environment note: save the spreadsheet first if you want an easier before-and-after review.

2. Highlight Duplicates

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

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

Success Criteria

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

Tips While Using

• Common mistake: treating highlighted results as deleted data; highlighting only marks duplicates.
• Environment note: duplicate detection depends on the data currently shown in the worksheet.