How to Remove Duplicate Rows in Excel

How to remove duplicate rows in Excel? In this tutorial, I show you how to remove duplicate rows in Microsoft Excel spreadsheets. To automatically remove duplicate rows we use the built in remove duplicate data tool in Excel. This allows you pick which columns should be checked for duplicates.

Remove Duplicate Rows in Excel(Video Tutorial):

Follow the steps below to create a drop down list in Excel:

  1. Open Excel on your Windows 10 computer or Mac.
  2. Highlight the cells containing any potential duplicates. This can include any headers.
  3. In the top menu select Data, then Remove Duplicates.
  4. If your data has a head ensure you check My data has headers.
  5. Select the columns where you want Excel to check for duplicates.
  6. Select OK.

More Excel Tips & Tutorials:

You may also like

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.