Excel can highlight or remove duplicates, but the selected columns determine which rows count as the same. Review the matches before deleting data.
Back up the worksheet first
Copy the original range to another worksheet or save a recoverable workbook version. Excel's Remove Duplicates command deletes matching rows and keeps the first occurrence. Filtering or conditional formatting is safer when you need to review the records before changing them.
Highlight duplicate values for review
- Select the cells or table you want to inspect.
- Open Home, Conditional Formatting, Highlight Cells Rules, and Duplicate Values.
- Choose a visible format and review the highlighted cells.
- Check whether spaces, capitalization, formulas, dates, blank cells, or identifiers explain apparent matches.
Highlighting identifies matching cell values; it does not automatically decide that an entire business record is redundant.
Remove duplicate rows in Excel
- Select the complete data range or click inside the table.
- Open Data and choose Remove Duplicates.
- Confirm whether the first row contains headers.
- Select the columns that together define a duplicate record.
- Choose OK and record the number of removed and remaining rows.
- Compare totals, row counts, and important identifiers with the backup.
Microsoft's current Excel duplicate-value guidance explains that selected columns form the comparison key and that the first matching occurrence is kept.
Choose columns carefully
Selecting only Email removes later rows with the same email even if names, dates, or order values differ. Selecting Email and Order ID removes a row only when both selected values match. Data in unselected columns is still deleted when its row is identified as a duplicate, so review the full record before confirming.
Use ToolZone for line lists and CSV data
The Remove Duplicate Lines tool keeps the first copy of each pasted line and can ignore case or surrounding spaces. It does not open or modify XLSX files. Export a flat table and use CSV Cleaner when entire CSV rows need exact deduplication, then verify the cleaned file before replacing the source workbook.
Duplicate-removal checklist
- Keep a recoverable original.
- Confirm the range and header row.
- Decide which columns define one record.
- Review spaces, case, dates, formulas, and blank values.
- Record removed and remaining row counts.
- Recalculate totals and reopen the saved workbook.