Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Delete the Duplicate Lines in Excel

Date:2019-7-9 Author:Cordelia

When you’re dealing with a bunch of data in Excel, it can be a headache to find and remove all the unwanted duplicate lines. 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.

How to Delete the Duplicate Lines in Excel

2. Click Data tab, select Remove Duplicates in Data Tools section.

How to Delete the Duplicate Lines in Excel

3. Select all the columns that contain duplicates in the popping out window. Hit OK to implement it.

How to Delete the Duplicate Lines in Excel

4. Now all the duplicate lines in the sheet have been removed.

How to Delete the Duplicate Lines in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

0 thoughts on “How to Delete the Duplicate Lines in Excel”

  1. Pingback: SOPHUC
  2. Pingback: 24+ Microsoft Excel Tips for Beginners Who Work at Office

Leave a Reply

Your email address will not be published. Required fields are marked *