How to Remove Duplicate Rows in Excel, by Gauging Gadgets on YouTube. 2 min 33 s.
- Video length
- 2 min 33 s
- Time to do it
- Varies
- Difficulty
- Easy
- Steps
- 6
What this tutorial covers
- Uses Excel's built-in Remove Duplicates tool rather than formulas.
- Lets you choose which columns Excel checks when identifying duplicate rows.
- Includes an option to mark that your data has headers before removal.
Prerequisites
- Microsoft Excel on a Windows 10 computer or a Mac.
Steps
Open Excel on your Windows 10 computer or Mac.
Highlight the cells containing any potential duplicates. This can include any headers.
In the top menu select Data, then Remove Duplicates.
If your data has a header, ensure you check My data has headers.
Select the columns where you want Excel to check for duplicates.
Select OK.
