Then, click Remove Duplicates. Select the columns that might have copies in the dialog box and press OK. Excel will eliminate duplicate entries, leaving unique values. This method might remove ...