When you have duplicate data that you want to remove from a single column in your dataset, start by clicking into the column you want to dedupe. 1. Click "Data" in the top menu of the Excel window ...