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 confirmation message showing how many duplicates were removed
Save the workbook