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 as needed
Click OK
Review the message showing how many duplicates were removed
Save the workbook
