How to remove duplicates in Excel for a single column 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.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.