How to delete duplicate rows in Excel
This tutorial will help you to remove all the duplicated data/rows from the Excel sheet. Follow the below steps:
Step 1: Open the Excel worksheet file and select all the rows on which you want to find the duplicate.
![How to delete duplicate rows in Excel](https://websparrow.org/wp-content/uploads/2022/10/how-to-delete-duplicate-rows-in-excel-1.png)
Step 2: Click on the Data tab and then Remove Duplicates.
![how to delete duplicate rows in excel but keep one](https://websparrow.org/wp-content/uploads/2022/10/how-to-delete-duplicate-rows-in-excel-2.png)
Step 3: A pop-up window will open, select all the fields/criteria on which you want to filter the duplicate rows. And click on OK.
![remove duplicate rows in excel](https://websparrow.org/wp-content/uploads/2022/10/how-to-delete-duplicate-rows-in-excel-3.png)
Step 4: After clicking on the OK button, all the duplicate rows will be removed from the sheet.
![formula to automatically remove duplicates in excel](https://websparrow.org/wp-content/uploads/2022/10/how-to-delete-duplicate-rows-in-excel-4.png)