Duplicates often appear after copying lists, combining exports, or importing data from several sources. Excel can highlight and remove duplicates, but the important question is which columns should be considered when deciding that two rows are the same.

Before you start: Save important work and avoid deleting, resetting, or changing anything you do not understand. Software menus can move slightly between versions.

Step-by-step instructions

Step 1: Save a backup

Create a copy of the workbook before removing many rows.

Step 2: Highlight duplicates first

Use Conditional Formatting to highlight duplicate values in the column you want to review.

Step 3: Check the highlighted data

Confirm repeated entries are actually unwanted.

Step 4: Select the correct range

Include the columns that should define a duplicate row.

Step 5: Use Remove Duplicates

Open the Data tools, choose Remove Duplicates, and select the comparison columns.

Step 6: Review the result

Check the remaining rows before saving over the original file.

Useful tips

  • Use a unique ID column when available.
  • Highlighting is safer than deleting when you are unsure.
  • Extra spaces and inconsistent formatting can interfere with comparisons.

Frequently asked questions

Does Remove Duplicates delete the first copy?

Excel normally keeps one instance and removes additional matching rows according to the selected columns.

Can I undo it?

Use Undo immediately, or restore the backup if the workbook has already been closed.

Why are duplicates not matching?

Extra spaces, hidden characters, or different data types can make values behave differently.

Prefer a video walkthrough?

NetCast on WebTech Zone also publishes visual how-to tutorials for everyday computer and software tasks.

Visit the YouTube Channel ↗