Then click OK, all the duplicate rows are selected as following screenshots: And then check Select entire rows option. In the Select Duplicate & Unique Cells dialog box, select Duplicates (Except 1 st one) or All duplicates (Including 1 st one) as you need. Click Kutools > Select Tools > Select Duplicate & Unique Cells, see screenshot:ģ. Select the range that you want to remove the duplicate rows.Ģ. If you have installed Kutools for Excel, please do as following steps:ġ.
How to remove duplicates in excel free#
Free to try with no limitation in 30 days. Kutools for Excel includes more than 300 handy Excel tools. If you have Kutools for Excel, with its Select Duplicate & Unique Cells utility, you can select the duplicate rows first, and then delete them at once. Remove duplicate rows in Excel with Kutools for Excel To do this, you just need to check the columns that you want to remove the duplicate values in the Remove Duplicates dialog box in step 3. Note: With this function, you can also remove rows with the same values in certain columns. Then click OK, a prompt box will pop out to tell you the removing result, and all identical rows are removed except for the first identical row. In the Remove Duplicates dialog box, leave all the checkboxes checked under Columns list box, and if your data contains headers, please check My data has headers option. On Data tab, click Remove Duplicates in the Data Tools group.ģ.
If you want to delete all duplicate rows in the worksheet, just hold down Ctrl + A key to select the entire sheet.Ģ. Select the range you want to remove duplicate rows.
Supposing you have the following range which contains some duplicate rows, to remove duplicate rows from a worksheet in Excel, you can according to following steps:ġ. Remove duplicate rows in Excel with Remove Duplicates function Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!
Super Filter: Create advanced filter schemes and apply to any sheets Sort by week, day, frequency and more Filter by bold, formulas, comment.Paste Skipping Hidden/Filtered Rows Count And Sum by Background Color Send Personalized Emails to Multiple Recipients in Bulk.