How to highlight and remove duplicates in Excel.

If you've ever tried merging 2 reports and wanted to see if there were any duplicates (whether that be words or numbers), there is an easy way to not only highlight were all the duplicates are, but to remove them as well. Here's how:

To highlight if there are any duplicates:

1. In the spreadsheet you are working on, highlight the cells you wish to evaluate then click on 'Styles' command in the 'Home' tab.
2. Click the 'Conditional Formatting'.
3. Click the 'Highlight Cells Rules'.
4. Click the 'Duplicate Values'.



5. All the duplicates will be highlighted. You can choose which colour you want to view the duplicates in.

To remove duplicates:

1. In the spreadsheet you are working on, highlight the cells you wish to evaluate then click on 'Remove Duplicates' command in the 'Data' tab.
2. The columns you have highlighted have already been flagged for selection. You can change this at this point if you wish.



3. Once you're ready to remove the duplicates in the range selected, press 'ok'.



4. Excel will tell you exactly how many duplicates were found and removed.

Have more questions or need help? Contact Gizmo on 1300 275 449 or help@gizmo.com.au