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 results in the confirmation message
Use Advanced Filter to copy unique records only
Use Conditional Formatting to highlight duplicate values before removing them
Use the UNIQUE function in newer Excel versions to return distinct values
Use Power Query to remove duplicates from imported data
Save a backup before deleting duplicate rows
