Find duplicate data using conditional formatting in MS Excel 2013
Excel 2013 is all about managing walls of numbers. However, while keeping a tack of large volumes of data, sometimes you don’t realize and copy and paste some items twice. Or at times, already there can be multiple entries of a number or item in an Excel. And often, due to this, the size of your Excel can get notoriously huge. The question is- how do you find duplicate and repeated entries in an Excel. Because finding and deleting this data manually can be really time consuming and complicated. Therefore, adapting conditional formatting techniques can prove handy. The best part about using conditional formatting is that it can highlight the duplicate data to enable you to delete it easily.
Know how to find duplicate data through conditional formatting in Excel 2013
- Open the Excel sheet in which you want to delete the repeated entries.
- In order to find the duplicate data, highlight the list that you would like to search.
- Now highlight the list in which you would like to search the duplicate entries.
- After highlight the list, go to the Excel ribbon and select ‘Conditional Formatting’.
- Choose ‘Highlight Cell Rules’ and then click on ‘Duplicate Values’.
- From ‘Duplicate Values’, choose the format of your choice. For example, select ‘Red Border’. Once you have adjusted your settings, click on ‘OK’.
- As you click ‘OK’, duplicate entries will be highlighted. Delete or keep the data according to your needs.
Keeping redundant data can make your Excel unnecessarily heavy and hard to open. And using conditional formatting is one of the easiest ways to find and delete duplicate entries from volumes of data.