Remove Duplicates in Excel: 3 clicks, no formula

Excel has a button that deletes repeated rows for you. No formula, no sorting, three clicks.

The 3 clicks

1. Click any cell inside your list.
2. Go to the Data tab and click Remove Duplicates.
3. Tick the columns that must match for a row to count as a duplicate, then click OK.

Excel keeps the first copy of each row and deletes the rest. It tells you how many it removed.

Example

After Remove Duplicates, only apple and pear stay.

Keep the original

The button deletes rows for good. Copy the sheet first (right-click the sheet tab › Move or Copy › tick Create a copy) so you can go back.

Only highlight them instead

If you want to see duplicates before deleting: select the column, go to Home › Conditional Formatting › Highlight Cells Rules › Duplicate Values. Repeated cells turn red.

Two ways it goes wrong

“Apple” and “apple ” are not the same. A trailing space or different capitals stops Excel matching them. Run =TRIM(A1) in a helper column first, or use Find and Replace to delete the extra spaces.

You ticked only one column. If you tick only “Name”, two people with the same name but different emails are treated as duplicates. Tick every column that makes a row unique.