How To Remove Duplicate Lines From An Excel Spreadsheet

I’ve just posted about how to remove blank lines from an Excel spreadsheet, but that has left me with a lot of duplicate lines. How do I get rid of those? Turns out it’s straightforward, thank goodness.

• First, select the column with your duplicates (by clicking on the column header letter, “A” in the example above).
• Then in the “Data” tab, click on “Remove Duplicates”

• Select the column that you want to de-dupe based on (in this example there’s only 1 column).
• Hit “OK”.
• All your dupes will be deleted.

no duplicates!

Note — the completion alert you get here seems very odd. It told me it had removed more duplicates than it had and left more than it had. It did seem to work though and this is clearly the official process….

Qlockwork is an activity tracking add-in for Microsoft Outlook and an alternative to Microsoft Journal. Companies worldwide use Qlockwork to automatically record their activities on all applications for accurate billing and increased productivity.

Please try our free trial.