When you’re dealing with a bunch of data in Excel, it can be a headache to find and remove all the unwanted. How to eliminate them in a quick and simple way? Excel itself has the function called Remove Duplicates. Let’s see how to make use of it.
1. Select the range of cells you want to remove duplicates from.
2. Click Data tab, select Remove Duplicates in Data Tools section.
3. Select all the columns that contain duplicates in the popping out window. Hit OK to implement it.
4. Now all the duplicate lines in the sheet have been removed.