Remove Duplicates

You’ve entered all of your data. It’s midnight. You’re exhausted. The presentation is early the next morning. You have already spell-checked, so what’s next? CHECK FOR DUPLICATES. Fortunately, there is a quick fix.

First, select the range of data that you want to check. Make sure you have a header for your column. You can choose the entire column OR just the data range you want to check.

Next, go to Data > Data Tools > Remove Duplicates.

That’s it. It’s really that simple.

Want to take it to the next level? Use the Conditional Formatting command in the Style group on the Home tab to highlight the duplicates first.