How to remove duplicate records in excel 2007

Data ribbon > Remove Duplicates. Click the question mark in the dialog for more help. In short: tick the columns that you want to test for duplicates.