Posted on Leave a comment

Find duplicate cells values in Excel 2010 & 2013

Duplicated Values result

To quickly find duplicate values in a Excel spreadsheet you can use Conditional Formatting under Home tab. There is a special rule for this called Duplicate Values…

Highlight the cells in which you want to find the duplicates and click on the Conditional Formatting | Highlight Cells Rules | Duplicate Values

Excel Duplicate Values

Select the formatting for duplicates and click OK.

Duplicated Values result

Leave a Reply

Your email address will not be published. Required fields are marked *