Decide which columns define a duplicate
If every cell in two rows must match, compare the full row. If a customer ID alone identifies a record, compare that column. You can also use a combination—such as first name plus last name—when that is the key your task requires.
Make a safe copy and preview the result
- Duplicate the worksheet or copy the original table to another sheet or workbook.
- If you are unsure what will match, highlight duplicates with Conditional Formatting or use Advanced Filter to copy unique records to a new location.
- Select the intended range, then choose Data → Remove Duplicates.
- Select only the columns that define a duplicate, confirm the result, and inspect several rows before continuing.
Excel keeps the first matching occurrence and removes later matches. If you need to keep the newest or highest-priority record instead, sort the data deliberately before deduplicating, and verify the result on the copy.
Watch for values that look the same but are not
- Spaces at the beginning or end of a cell can make text values differ.
- Different date formats may display similarly while storing different values, or the same date can display in different formats.
- A name alone may not be a safe key when two different people share it.
- Selecting the wrong columns can remove rows that are not duplicates for your purpose.
Keep the backup until you have checked both the retained rows and the removal count. Excel’s Undo can help immediately, but a separate copy is safer if you continue working afterward.
Clean a pasted list without changing your spreadsheet
For a simple list or tab-separated rows, UsefulVerse’s duplicate-line remover keeps the first matching line and preserves the order. You can trim edge spaces, ignore letter case, or remove blank lines. It compares the entire line, so use Excel when the duplicate key should be only selected columns. Review the output before pasting it back.