Select the range of cells or the entire table
Go to the Data tab
Click Remove Duplicates
Choose the columns you want Excel to check for duplicates
Check or uncheck My data has headers if needed
Click OK
Review the message showing how many duplicate values were removed
Save the workbook