The add-in will automatically pick the range that you select in your worksheet.ĭealing with duplicates removal in Excel, it is better to have a backup copy of the original dataset then to restore the mistakenly deleted entries. In the Excel ribbon, let's find the Ablebits Data tab and the Dedupe group. Let's have a look at the way we can do it. If your task is to delete duplicate rows from your Excel table, the Ablebits Duplicate Remover tool will help you out.