Office Dễ Hiểu

How to remove duplicate rows in Excel

Choose the columns that define a duplicate and remove repeated records safely.

Select the complete table, choose Data → Remove Duplicates, then select the columns Excel should compare.

Visual walkthrough

DataRemove Duplicates

Before

The table contains repeated record IDs.

After

One record remains for each selected key.

Check the result

Compare row counts and spot-check the retained records.

Step-by-step instructions

  1. Make a copy of the worksheet before removing records.
  2. Select the complete table and choose Data → Remove Duplicates. Confirm My data has headers when appropriate.
  3. Select only the comparison columns. Choose a record ID for unique IDs, or several columns when the whole combination defines a duplicate.
  4. Choose OK and read the number of removed and remaining records. Check a few examples against the original sheet.

Frequently asked questions

Why are duplicates still present?

Check for extra spaces, inconsistent characters and differences in columns selected for comparison. Two rows are duplicates only under your chosen comparison.

Reference: Microsoft Support