Select the range of cells or the entire table
Go to the Data tab
Click Remove Duplicates
Choose the columns to check for duplicate values
Check or uncheck My data has headers as needed
Click OK
Review the duplicate removal summary
Save the workbook
Select the range of cells or the entire table
Go to the Data tab
Click Remove Duplicates
Choose the columns to check for duplicate values
Check or uncheck My data has headers as needed
Click OK
Review the duplicate removal summary
Save the workbook