Do you want to see and delete the duplicate entries in your spreadsheets? If yes, you can do so through Microsoft Excel’s conditional formatting option to highlight duplicates and choose an option to delete those items. This article will show you how.
Highlight Duplicate Values in Excel
To highlight duplicate values, first, open your spreadsheet with Microsoft Excel. Once you get to your spreadsheet, select the dataset you want to scan for duplicates. Make sure to have the column headers in your selection.
From Excel’s ribbon, click the “Home” tab. Then, in the “Styles” section, click Conditional Formatting > Highlight Cells Rules > Duplicate Values.
You’ll notice that Excel has highlighted the duplicate entries in your selected formatting style on your spreadsheet.
And that’s how you smoothly spot non-unique records in your datasets.
Remove Duplicates in Excel
Microsoft Excel brings a feature that automatically extracts duplicate values from your datasets.
Select your dataset in your Excel spreadsheet to take advantage of this feature. Ensure to select your column headers as well.
From Excel’s ribbon, click the “Data” tab and choose “Remove Duplicates.”
If you’ve selected column headers on the “Remove Duplicates” box, then enable the “My Data Has Headers” option. In the “Columns” section, ensure the correct column(s) are listed. Then click “OK.”
Excel has removed duplicate entries from your dataset. And you’re all set.