Eliminating Duplicate Lines In an Excel Table

Is there an easy way to remove duplicate rows in an Excel spreadsheet? Yes!

Thomas Duff

by Thomas Duff on 7/18/2016

Share this:

Article Details

Date Revised:

Applies to:
Excel, one minute office magic, remove duplicate rows

Excel is a great way to build tables of data, but sometimes you need to make sure you don't have any duplicates in your data. That may be easy if you only have a dozen rows, but what if you have thousands?

It's very simple… use the Remove Duplicates menu option!

Here I have a table of ten data rows, four of which are exact duplicates. I can delete those using Table Tools > Design > Remove Duplicates:

Excel spreadsheet with duplicate rows

Excel will ask you what columns you should use to compare duplicates. By default, it selects the entire row:

The Remove Duplicates option in Excel

When you click OK, the duplicate rows are deleted and you now have unique table rows:

Excel spreadsheet with duplicate rows removed

Topic: One Minute Office Magic

Sign in with

Or register