Microsoft has made it quicker to remove duplicate rows in Excel 2010, all it takes now is two simple steps. The best part is that you don’t need to select any specific row before removing the duplicate rows, the build-in Remove Duplicate feature takes care of it.
For demonstration purpose I created a quick data table, note that rows 2 and 5 have same values. Head over to the Data tab and click Remove Duplicate button. This will open a dialog window where you can select the columns from which you want to delete the duplicate values.
If you want to get rid of all duplicate columns in an excel spreadsheet, click Select All, so that all columns are selected and then click OK.
After the process is complete, you will be shown a notification window with the results. Note in the screenshot below that the duplicate in row 5 is removed.
This guide only covers method to remove duplicate rows, if you are looking to find and remove duplicate values in the whole spreadsheet, visit the guide here.