How to remove duplicate rows in Microsoft Excel 2010?
In Excel, you can remove duplicate rows easily using the Data Tools available in Excel 2010.
How to remove duplicate rows in Microsoft Excel 2010?
Follow the below steps to Remove duplicate rows in Microsoft Excel 2010.
1. Select the list of rows that you want to find the duplicate rows and delete.
2. Navigate to Data Tab and Click Remove Duplicates button in the Data Tools group.
3. This will display the Remove Duplicates Dialog. Select the columns on which you want to find the duplicates and click OK.
4. The duplicate rows would be deleted accordingly.
