How To Remove Duplicate Rows In Excel?

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

Save the workbook

Suggested for You

Trending Today