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.

2 responses to “How to Delete the Duplicate Lines in Excel”

  1. SOPHUC says:

    […] addition to find duplicates in a spreadsheet, you may also need to remove the duplicate lines to simplify the content. Luckily Excel has a function to solve this problem […]

  2. […] addition to find duplicates in a spreadsheet, you may also need to remove the duplicate lines to simplify the content. Luckily Excel has a function to solve this problem […]

Leave a Reply

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