- Select the range of cells, or make sure that the active cell is in a table.
- On the Data tab, in the Data Tools group, click Remove Duplicates.
- 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.
- Click OK