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.