Chat with us, powered by LiveChat

Excel Remove Duplicates

How to Remove Duplicates in Excel

If there are duplicate rows of identical data in your table, Excel can find and remove the duplicate rows for you. You can also remove duplicates from cell ranges, not just tables. In that case, you need to select the entire cell range you want to examine.

Remove Duplicate Values

  1. Select a cell in the table.
  2. Click the Data tab.
  3. Click the Remove Duplicates button.

    All columns are selected by default, but it’s possible to select/deselect individual columns in the Columns list. You can also use the Select All and Unselect All buttons to select columns.

  4. Select the columns you want to check for duplicates.
  5. Click OK.
    Remove Duplicates

    The dialog box displays the number of duplicates that were removed and how many values remain.

    Removing duplicate values actually deletes the duplicate data, so you may want to copy the data to another worksheet or workbook first, just in case.

  6. Click OK.
    Remove Duplicates