Q:

How do you delete duplicates in Excel?

A:

Quick Answer

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.

Continue Reading

Full Answer

  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.

Learn more about Software

Related Questions

Explore