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