How to Remove Duplicates in Excel

Clean repeated rows out of an Excel sheet in a couple of clicks.

1. Make a backup copy first

   Remove Duplicates permanently deletes rows. Copy the sheet (right-click the tab > Move or Copy > Create a copy) so you can get the originals back if needed.

2. Select your data range

   Click any cell inside the table, or drag to select the exact range including the header row.

3. Click Data > Remove Duplicates

   On the Data tab, find "Remove Duplicates" in the Data Tools group. A dialog lists your columns.

4. Choose what counts as a duplicate, then confirm

   Check only the columns that define a duplicate (e.g. just "Email"), or leave all checked to match entire rows. Click OK — Excel deletes the extras and tells you how many it removed.