Click on the Data tab in top menu bar and select Remove Duplicates option in ‘Data Tools’ section. If you only need to remove duplicate values, you can remove them all at once by following the steps below.ġ. In Duplicate Values dialog box, select the Conditional Format that you want to apply for cells with duplicate values and click on OK.Īfter this, Cells with duplicate values will become highlighted, making it easy for you to change or delete the Cells containing duplicate data.

After selecting data, make sure you are on the Home tab > click on Conditional Formatting > Highlight Cells Rules and select Duplicate Values option.Ĥ. Go to the Data tab and click the Remove Duplicates icon in the Data Tools section. Here’s how to use the tool: Select a cell on the table and press Control + A on your keyboard to highlight the table. Using Mouse, select the entire section of data that you want to check for duplicate values.ģ. It achieves this by comparing selected columns in your worksheet and removing rows with duplicate values. Open the Excel File containing data that you want to check for duplicates.Ģ. So let us go ahead and take a look at the steps to find duplicates in Excel using Conditional Formatting. Once duplicate values are highlighted, it makes it easy to correct those values by deleting or modifying the duplicate values as required.