How to remove duplicates in Excel the safe way

Excel can strip duplicate rows in two clicks — but it deletes them in place, so one wrong setting and your originals are gone. Here's how to do it without regret.

The steps

Copy your data to a new sheet first. This is the whole safety net — Remove Duplicates has no "undo the ones it kept" once you've moved on.
Select the range (or click one cell inside a Table).
Data → Remove Duplicates.
Tick only the columns that define a duplicate. This is the part people get wrong.

"Duplicate" means what you say it means

If you tick every column, Excel only removes rows where all values are identical. Usually that's not what you want. To dedupe customers by email, tick only the Email column — Excel keeps the first row for each email and drops the rest, even if other fields differ. Choosing the key columns deliberately is the difference between a clean list and a wrong one.

Before you dedupe

Hidden spaces and case differences hide duplicates from this tool: Acme and Acme are treated as different. Run TRIM/CLEAN first so true duplicates actually collapse.

A non-destructive alternative

If you'd rather flag duplicates than delete them, use Conditional Formatting → Highlight Cell Rules → Duplicate Values, or count them with =COUNTIF($A$2:$A$500, A2) and filter for counts greater than 1.