Feature Summary
The Duplicate Items feature is used to detect and process duplicate data in spreadsheets, supporting operations such as highlighting, deleting duplicate values, and extracting unique values.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction |
Operation Steps
Highlight Duplicate Items
Feature Entry
"Data" tab → "Duplicate Items" dropdown menu → "Set Highlight Duplicate Items"
- Select the cell range you want to check
- Click the Duplicate Items dropdown menu in the Data tab
- Select the "Set Highlight Duplicate Items" button
- Duplicate data will be displayed with a red background

Clear Highlight Duplicate Items
Feature Entry
"Data" tab → "Duplicate Items" dropdown menu → "Clear Highlight Duplicate Items"
- Select the cell range you want to check
- Click the Duplicate Items dropdown menu in the Data tab
- Select the "Clear Highlight Duplicate Items" button
- Highlighted duplicate items will be cleared

Count Duplicate Occurrences
Feature Entry
"Data" tab → "Duplicate Items" dropdown menu → "Count Duplicate Occurrences"
- Select the cell range you want to check
- Click the Duplicate Items dropdown menu in the Data tab
- Select the "Count Duplicate Occurrences" button
- A chart will be automatically generated to count the number of duplicate texts in the selected area

Reject Duplicate Entry
Feature Entry
"Data" tab → "Duplicate Items" dropdown menu → "Reject Duplicate Entry"
- Select the cell range you want to check
- Click the Duplicate Items dropdown menu in the Data tab
- Select the "Reject Duplicate Entry" button
- When duplicate content is entered, a prompt will remind you to check the correctness of the input

Clear Reject Entry Restriction
Feature Entry
"Data" tab → "Duplicate Items" dropdown menu → "Clear Reject Entry Restriction"
- Select the cell range you want to check
- Click the Duplicate Items dropdown menu in the Data tab
- Select the "Clear Reject Entry Restriction" button
- The check for duplicate input content will be disabled

Delete Duplicate Items
Feature Entry
"Data" → "Data Tools" → "Delete Duplicate Items"
- Select the cell range containing data
- Click the "Delete Duplicate Items" button in the "Data" tab
- Select the columns to determine duplicates
- Click Delete Duplicate Items to remove duplicate content and keep unique values

Frequently Asked Questions
Question 1: Can I recover data after deleting duplicate items?
- Solution: Immediately after deletion, use
Command + Zto undo; recovery is not possible after saving. It is recommended to back up data before operation.
Question 2: How to keep only unique values?
- Solution: After using the "Delete Duplicate Items" feature, the remaining values are the unique ones.
Notes
- When deleting duplicate items, you can choose which columns to use for determining duplicates
- It is recommended to back up data before operation
- Highlighting does not delete data; it only marks it