-
Select the cell range where you want to remove the duplicates.
-
Go to the Data tab and selectÂ
 Remove Duplicates in the Data Tools group. -
If you get a warning dialog, choose whether to expand your selection or continue.Â
-
Choose all the columns with duplicates and select OK.
-
Select the cell range where you want to remove the duplicates.
-
Go to the Data tab and selectÂ
 Remove Duplicates. -
If you get a warning dialog, choose whether to expand your selection or continue.Â
-
Select all the columns with duplicates and select OK.
-
Select the cell range where you want to remove the duplicates.
-
Go to the Data tab and selectÂ
 Remove Duplicates. -
If you get a warning dialog, choose whether to expand your selection or continue.Â
-
Select all the columns with duplicates and select OK.