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

Step 2: Click on the Data tab and then Remove Duplicates.

how to delete duplicate rows in excel but keep one

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

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


  1. Microsoft Excel Shortcut Keys List
    Find and remove duplicates

Similar Posts

About the Author

Atul Rai
I love sharing my experiments and ideas with everyone by writing articles on the latest technological trends. Read all published posts by Atul Rai.