1
Open the excel sheet
Select the range of the cells where duplicates needs to be removed.
How to Remove Duplicates in Excel
In this tutorial, you will learn how to clean up your spreadsheet data by removing duplicate entries in Microsoft Excel.
Operations
2
Click the Data tab
Click the Data tab in the top ribbon to access data management and analysis tools.
3
Click the Remove Duplicates button
Click the "Remove Duplicates" button in the Data Tools group on the ribbon to clean up your dataset.
4
Click the OK button
Click the OK button in the Remove Duplicates dialog box to confirm your selection.
5
Click the OK button
Click the OK button in the dialog box to acknowledge the message and close the window. The duplicates are removed.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.