top of page


The Remove Duplicates tool is a widely used feature in Excel that allows users to eliminate duplicate entries from a single column or a group of columns. This tutorial will guide you on removing duplicates in both Excel Online and Excel Desktop.

When applied to a range containing multiple columns, the Remove Duplicates tool removes the entire row that contains a duplicate value.

We can access the Remove Duplicates tool by first selecting the desired range for duplicates removal, then navigating to the Data ribbon in Excel, and then clicking Remove Duplicates. 

bottom of page