1. Select the range of cells, or make sure that the active cell is in a table.
  2. On the Data tab, in the Data Tools group, click Remove Duplicates.
  3. Do one or more of the following:
    • Under Columns, select one or more columns.
    • To quickly select all columns, click Select All.
    • To quickly clear all columns, click Unselect All.
  4. Click OK