How to change color duplicate rows in Excel

Remove duplicate values

When you use the Remove Duplicates feature, the duplicate data will be permanently deleted. Before you delete the duplicates, its a good idea to copy the original data to another worksheet so you dont accidentally lose any information.

1. Select the range of cells that has duplicate values you want to remove.

   Tip: Remove any outlines or subtotals from your data before trying to remove duplicates.

2. Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates.

   

   For example, in this worksheet, the January column has price information I want to keep.

   

   So, I unchecked January in the Remove Duplicates box.

   

3. Click OK.