Skip to content

How to Remove Duplicate Values in an Excel Spreadsheet

< 1 minute read

ltfoam hives

If you have a spreadsheet with unwanted duplicate data, it’s simple to use Excel to automatically remove the repeated values. Don’t waste your time doing this task manually!

Follow the instructions in the video above, or:

  1. Go to your DATA tab.
  2. Click Remove Duplicates.
  3. Choose the column or column with duplicate values you want to remove, and click OK.

Two things to remember:

  • This method completely removes duplicate values; it doesn’t filter. If you need to save your original set of data, it’s a good idea to copy it to another sheet.
  • You can’t remove duplicate values from a table that is outlined or has subtotals.

Sign up for our newsletter