Duplicate rows can throw off totals, charts, and mailing lists in Excel. The built-in Remove Duplicates tool clears repeated entries in a few clicks so your data stays reliable.
What you'll need
- Microsoft Excel
- A workbook with your data
Step by step
- Click inside your dataSelect any cell within the table. Excel usually detects the surrounding range automatically, so you rarely need to highlight it all by hand.
- Open the Data tabGo to the ribbon at the top and click the Data tab to find the data tools.
- Click Remove DuplicatesIn the Data Tools group, click Remove Duplicates to open the options dialog.
- Choose the columns to checkTick My data has headers if the first row is column labels, then select the columns that define a duplicate. Rows match only when the ticked columns are all identical.
- Confirm removalClick OK. Excel shows a message stating how many duplicate values were removed and how many unique values remain.
Handy tips
- To spot duplicates before deleting, use Home, Conditional Formatting, Highlight Cells Rules, Duplicate Values.
- Copy your sheet to a second tab before removing duplicates so you keep the original data intact.
- Selecting fewer columns makes the match looser, so a row is removed whenever those specific columns repeat.
Heads up
- Remove Duplicates deletes rows and cannot be recovered except with Undo right afterward. Save a backup copy before running it on important data.
FAQ
Which duplicate row does Excel keep?
It keeps the first occurrence in the range and deletes the later matching rows.
Can I remove duplicates from a single column only?
Yes. In the dialog, tick just that one column so Excel treats repeated values in it as duplicates.
Why does Excel say there are no duplicates when I can see some?
Trailing spaces, different formatting, or text versus number formats make cells look the same but count as different. Clean the data with TRIM or match the formats, then try again.