How to Remove Duplicates Excel?

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

Suggested for You

Trending Today