On the Data tab, click Remove Duplicates (in the Data Tools group). Select the range of cells, or ensure that the active cell is in a table. When duplicates are removed, the first occurrence of the value in the list is kept, but other identical values are deleted.īecause you are permanently deleting data, it's a good idea to copy the original range of cells or table to another worksheet or workbook before removing duplicate values. Other values outside the range of cells or table will not change or move.
Here we discuss how to highlight duplicate values in excel by using two methods: practical examples and a downloadable excel template.When you remove duplicate values, the only effect is on the values in the range of cells or table. This has been a guide to Highlight Duplicates in Excel.
Here we will find the duplicate values in excel using the conditional formatting feature and will highlight those values.
You can download this Highlight Duplicates Excel Template here – Highlight Duplicates Excel Template Conditional Formatting – Duplicate Values Rule