Remove Duplicates in Excel Records

Posted by on Jan 13, 2013 in MS Excel | 0 comments

Excel – 2010 or 2007

You can Catch  Duplicates by the feature that is available in Excel 2007 or 2010 version.

Under Home tab, Under Style section – click on Conditional Formatting,

Select “Highlight Cells Rules” and click on Duplicate Values . The window will popup as shown below. Select the colour from the list and click OK.  The duplicate values will be highlighted and it will be easily visible to you if you want to spot any duplicate records! 🙂


Leave a Reply