Select the range of cells or the table containing duplicates
Go to the Data tab
Click Remove Duplicates
Choose the columns to check for duplicates
Check or uncheck My data has headers as needed
Click OK
Review the message showing how many duplicates were removed and how many unique values remain