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"

  1. Select the cell range you want to check
  2. Click the Duplicate Items dropdown menu in the Data tab
  3. Select the "Set Highlight Duplicate Items" button
  4. Duplicate data will be displayed with a red background

image

Clear Highlight Duplicate Items

Feature Entry
"Data" tab → "Duplicate Items" dropdown menu → "Clear Highlight Duplicate Items"

  1. Select the cell range you want to check
  2. Click the Duplicate Items dropdown menu in the Data tab
  3. Select the "Clear Highlight Duplicate Items" button
  4. Highlighted duplicate items will be cleared

image

Count Duplicate Occurrences

Feature Entry
"Data" tab → "Duplicate Items" dropdown menu → "Count Duplicate Occurrences"

  1. Select the cell range you want to check
  2. Click the Duplicate Items dropdown menu in the Data tab
  3. Select the "Count Duplicate Occurrences" button
  4. A chart will be automatically generated to count the number of duplicate texts in the selected area

image

Reject Duplicate Entry

Feature Entry
"Data" tab → "Duplicate Items" dropdown menu → "Reject Duplicate Entry"

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

image

Clear Reject Entry Restriction

Feature Entry
"Data" tab → "Duplicate Items" dropdown menu → "Clear Reject Entry Restriction"

  1. Select the cell range you want to check
  2. Click the Duplicate Items dropdown menu in the Data tab
  3. Select the "Clear Reject Entry Restriction" button
  4. The check for duplicate input content will be disabled

image

Delete Duplicate Items

Feature Entry
"Data" → "Data Tools" → "Delete Duplicate Items"

  1. Select the cell range containing data
  2. Click the "Delete Duplicate Items" button in the "Data" tab
  3. Select the columns to determine duplicates
  4. Click Delete Duplicate Items to remove duplicate content and keep unique values

image

Frequently Asked Questions

Question 1: Can I recover data after deleting duplicate items?

  • Solution: Immediately after deletion, use Command + Z to 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