Step 4: In the Remove Duplicates dialog box that appears, and in the Columns section, check any boxes next to the spreadsheet columns where you'd like the duplicates to be deleted.

Click the "Data" tab in the Microsoft Excel 2007 ribbon and locate the Data Tools group. Click on the "Remove Duplicates" item to bring up the Remove Duplicates dialog box.