Delete duplicate rows from a list in Excel
The following article describes how you can use an advanced filter in Excel to show only unique items in a list, allowing you to remove or delete duplicate rows.
Before starting, please ensure you have a recent backup of the file you are going to remove the duplicate rows from.
- In the list you want to filter, select all of the rows including the column headers by clicking the top left cell of the range, and then dragging to the bottom right cell.
- Go to the Data menu > Filter > Advanced Filter.
- Select Filter the list, in place.
- Select the Unique records only check box and click OK.
What you are now left with is the filtered list that has no duplicate cells/rows. You can now either copy and paste the filtered list into a new worksheet/workbook or you can:
- Copy the filtered list to the clipboard.
- Disable the filter – Data menu > Filter > Show All.
- Press Delete on your keyboard to remove the original list.
- Paste the new list in from the clipboard.




