When using Duplicates on Android, common questions usually involve recovery, recognition results, and follow-up handling; this FAQ covers 3 common questions and practical suggestions.
FAQ
How can I recover data after removing duplicates?
- After the removal is complete, first check whether the current page still shows an Undo option.
- Tap Undo to return to the state before removal.
- If you have already made other edits, review the original file or a backup copy.
Why were some values not recognized as duplicates?
- Check whether the related cell contents are exactly the same.
- Confirm whether there are differences in formatting, spaces, or displayed content.
- If needed, standardize the data format first and then run highlight or removal again.
Can I keep editing the spreadsheet after highlighting duplicates?
- Yes. You can continue viewing and editing the spreadsheet after duplicates are highlighted.
- Review the highlighted positions and decide which data should be kept.
- After confirmation, decide whether to run Remove Duplicates.
Glossary
| Term | Definition |
|---|---|
| Duplicates | Repeated data content in a worksheet that can be identified and cleaned up. |
| Highlight Duplicates | A method that marks repeated data with color so you can review it before deciding how to handle it. |
| Remove Duplicates | An action that removes repeated data records to keep a cleaner worksheet result. |