Select the range of cells or the entire table
Go to the Data tab
Click Remove Duplicates
Choose the columns to check for duplicates
Click OK
Review the confirmation message
Use Conditional Formatting to highlight duplicates before removing them
Use Advanced Filter to copy unique records to another location
Use the UNIQUE function in Excel 365 or Excel 2021
Use Sort and Filter to help identify duplicate entries
Save a backup copy before deleting duplicates