How to Highlight Duplicate Values in Microsoft Excel

How to Highlight Duplicate Values in Microsoft Excel

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.

This blog post is powered by AIIT Solutions.

You May Also Like

About the Author: Faris Khan

Faris is a focused and skilled Technical Content Writer, SEO Expert, Graphic Designer, Social Media Content Management, and a lifetime student. Seeking to be inspired, envision the unlikely, and be surrounded by those who bring out the best in him.

Leave a Reply

Your email address will not be published.

Share This