How do you delete duplicates in Excel?

Start Microsoft Excel, locate and open the file. Click inside the table. Select all the columns to examine for duplicate records. On the Table Tools Design tab, in the Tools group, click Remove Duplicates. All duplicate records (rows with duplicate data) will be deleted. Click Save.

1. Open the file

   Launch Microsoft Excel from the Start menu. Click File, and then Open. Select and open the target file.

2. Select the data to evaluate for duplicate records

   Press the CTRL Key while using the cursor to click and select the columns to examine for duplicate records.

3. Delete duplicate records

   On the Table Tools Design tab, in the Tools group, click Remove Duplicates. All duplicate records (rows with duplicate data) will be deleted permanently.

4. Save changes

   Click Save on the main menu to save the file.