How to remove duplicate entries in Excel

How to remove duplicate entries in Excel
How to remove duplicate entries in Excel

For a small spreadsheet, finding and removing duplicates is as easy as selecting and deleting each additional entry. For a large data set with hundreds or even thousands of names, the ability to remove duplicate entries in a semi-automated way could potentially save you days of hunting.

Today we’re going to create a small set of data, and remove duplicate entries through Excel’s own duplicate removal tools.

How to remove duplicate entries in Excel

1. Open an Excel workbook, or create a new one if you want to follow along. If there’s no existing data, you’ll have to add some dummy text to try this out yourself. For the sake of this tutorial, I just made a list of artists and bands, duplicating a few names along the way.

2. Select a column (or columns) to look for duplicated data. If you’re using a large data set, I’d recommend selecting each column individually. Often times, there’s a name in a different column that’ll match the first column, but won’t be a duplicate we need to remove.

3. Open the Data tab at the top of the ribbon. 

4. Find the Data Tools menu, and click Remove Duplicates

5. Press the OK button on the pop-up to remove duplicate items from your data set.

Read more
An illustration of a man's silhouette and the top of his head is open like a lid as a slew of app icons float out into the air. The illustration is on a flat orange background.
I found an app that connects all my apps — without trying to replace them. It's a life-changer.
Microsoft Office
Microsoft's recent tests could lure Google Workspace users back to Office apps
Microsoft Edge update
Microsoft doesn't want to tell you how to uninstall Microsft Edge
Dell Inspiron laptop on a table
3 surprising ways a budget laptop supercharged my writing career
Procreate provides the most appealing digital painting experience I’ve encountered.
Adobe is too expensive, so I switched to these alternative art apps
The 39.7-inch Dell UltraSharp monitor beside a Laptop Mag deals icon in front of an orange and yellow background
Top 5 Dell UltraSharp monitor deals: Save up to $300 on the ultimate productivity monitor!
Latest in Work & Collaboration Tools
An illustration of a man's silhouette and the top of his head is open like a lid as a slew of app icons float out into the air. The illustration is on a flat orange background.
I found an app that connects all my apps — without trying to replace them. It's a life-changer.
Thunderbolt Share depiction
Intel Thunderbolt Share: The powerful PC-to-PC connection software is frustratingly elusive, but you don't need a new laptop to use it
The 39.7-inch Dell UltraSharp monitor beside a Laptop Mag deals icon in front of an orange and yellow background
Top 5 Dell UltraSharp monitor deals: Save up to $300 on the ultimate productivity monitor!
The Logitech MX Creative Console seen from above on a white table
Logitech MX Creative Console review: Is this alternative stream deck a creative game changer?
Google Search
Google Reverse Image Search: How to search with an image in Google
docs in proton drive
What is Proton Docs? Why you might want to give the privacy-focused Google competitor a chance
Latest in News
Nintendo switch 2 virtual game card
Nintendo's Virtual Game Card feature might be more revolutionary than the Switch 2
A close-up of a light-colored computer keyboard shows the keys T, Y, G, and H replaced by the logos of OpenAI, DeepSeek, Grok, and Gemini, the leading competitors in the artificial intelligence market. This serves as a visual metaphor for the intense rivalry and innovation in the AI industry. (Photo by Matteo Della Torre/NurPhoto via Getty Images)
Is generative AI inadvertently reducing the voices of many to the banality of one?
Asus ROG Ally Z1 on a brown table with the game Unpacking played on screen.
Handheld gaming PCs have a Windows problem — but maybe not for long
WWDC 2025 could mark the beginning of the end for certain iPhone users
Error when installing Google Chrome on the Asus Vivobook 16 Flip, on a white desk against a blue background.
"This app can't run on your PC": Google's Chrome Installer broke on Windows, but there's a fix
Nintendo Switch 2 handheld gaming console
Nintendo Switch 2 preorder date: It might be a lot closer than you think, say tipsters