Delete duplicate rows
- Click a cell inside your data (or select the range).
- Open the Data tab and click Remove Duplicates.
- Tick the columns that must match for a row to count as a duplicate.
- Click OK. Excel tells you how many duplicates were removed.
Keep the original (Microsoft 365)
The UNIQUE function returns a de-duplicated list without touching your data:
=UNIQUE(A2:A100)
Find duplicates before deleting
- Select the column.
- Choose Home, Conditional Formatting, Highlight Cells Rules, Duplicate Values.
- Review the highlighted cells.
In Google Sheets
Select the range and choose Data, Data cleanup, Remove duplicates.
Warning: “Remove Duplicates” deletes rows immediately. Work on a copy of the sheet, or press Ctrl + Z straight away if the result is wrong.
Questions
Why are “identical” cells not treated as duplicates?
Trailing spaces and different capitalisation can make cells differ. Clean them with =TRIM(A2) first.
Does it keep the first or last entry?
Excel keeps the first occurrence and removes the later ones.