Posted on Leave a comment

Find duplicate cell values in Excel 2010

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

image

Select the formatting for duplicates and click OK.

Untitled

Leave a Reply

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