#Delete duplicate rows in excel how to#
#Delete duplicate rows in excel download#

Let’s resume by opening the Excel spreadsheet. The second tool that you can use in Excel to identify and remove duplicates is the “Advanced Filter”. In this case, all rows with duplicate information except one have been deleted, and the details of the deletion are displayed in the pop-up dialog box. Now that the entire table is selected, you just need to press the “OK” button to remove all duplicates. Once you have done this, you will notice that the entire table has been highlighted again and the “Columns” section has changed from “Duplicate” to “Columns A, B, and C”. We will deselect the “My data has headers” box. In this case, we have no header since the table starts at “Row 1”. The reason is that the “My data has headers” box is checked. You will notice that the first row has been automatically deselected. Once you click on it, a small dialog box will appear. Once you have successfully selected the table, you will need to click on the “Data” tab at the top of the screen and then select the “Remove Duplicates” function as shown below.

In this case, we will select the whole table by pressing “Ctrl” and “A” at the same time (Ctrl + A). Start by selecting the cells you want to target for your search. If you are using Microsoft Office Suite, you will have a little advantage as there is a built-in feature to find and remove duplicates. Once you’ve downloaded and opened the resource, or opened your own document, you’re ready to continue.

#Delete duplicate rows in excel download#

If you don’t have files with duplicate lines now, feel free to download our handy resource with multiple duplicate lines created for this tutorial. To know more about Excel go through our Formulas.ĭo follow our YouTube channel for regular updates.Today we are going to talk about some handy methods to identify and remove duplicate rows in Excel. Undo the change by pressing the shortcut key Ctrl + Z or you will find the undo icon on the top left corner of the Excel file.

Step 7: Once you click OK, the duplicate entries will be removed from the Excel table. Step 6: Once you click OK, a message will be displayed to show how many duplicates were removed and how many unique values have been remaining. It not, it will show you the message has “No duplicate values found” in the dialog box. If a duplicate is found in the specified columns, then the entire row will be removed from the Excel table. If you select only the Column 1 and Column 2, then Excel will match the duplicate entries only for those columns. Here I want to remove the duplicate entries for all the columns, so I have selected all the columns. Step 5: Tick the columns where you want to remove duplicate entries and click OK. If you want to find the duplicate entries in all the columns, then click the Select All option and if you want to find the duplicate entries to the specified columns, then click Unselect All option and then tick the checkbox you want. Here, you can see the Select All and Unselect All option in the dialog box. Other cells outside the table are not affected. Excel will automatically select the range of cells within the table. Step 4: Once you click Remove Duplicates, the Remove Duplicates dialog box appears in the window. Step 3: To remove duplicate entries, go to Data > Remove Duplicates ( in the Data Tools group). Step 2: Select the cell or range of cells within the table.

#Delete duplicate rows in excel how to#

To know how to create an Excel table please Click Here. Step 1: The first step is to create an Excel table for the data. In that case, you can follow the below steps to remove the duplicate values easily. To make it much easier for you to understand, I have highlighted the duplicated entries. In the below image, you can see that row 8, row 12, and row 16 has been duplicated. So Excel has a built-in option to remove duplicate values.Įxample: Here I have a collective data and I want to remove the duplicate entries from the table. If you have a huge set of data, then finding and removing the duplicates manually is not possible in the Excel table. A Scenario – Remove Duplicate Values from the Excel Table Is it hard to find and remove duplicates manually? Want to know the easiest way to remove duplicate values? Then this article will help you to remove the duplicates from the table with an appropriate example.