How to delete duplicate rows in Excel

By Atul Rai | Last Updated: October 20, 2022 Previous       Next

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.

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

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.

Step 4: After clicking on the OK button, all the duplicate rows will be removed from the sheet.

References

1. Microsoft Excel Shortcut Keys List
   Find and remove duplicates