How to Delete Duplicate Rows in Excel Based on One Column


Microsoft Excel is spreadsheet software that helps you organize, chart and modify large amounts of data. If you have a single column of data (in other words, a list), you may accidentally enter duplicate data during the data entry process. Finding the duplicate entry by hand can be a time consuming process, especially if you have thousands of entries in a column. Excel's Data Sorting function can help you locate and remove duplicate entries.

Things You'll Need

  • Excel 2007
  • Select the entire column of data by left clicking on the top cell and dragging the cursor to the bottom cell.

  • Click on the "Data" tab and select "Filter > Advanced." Click the "Filter the list, in-place" radio button and check the box next to "Unique records only." Click the "OK" button.

  • Open the Office Clipboard by pressing the "Home" tab and choosing "Clipboard."

  • Hold down the Crtl and C keys at the same time to copy the cells into the clipboard.

  • Click on the "Filter" tab to restore the original cell data.

  • Paste the modified cell contents from the clipboard into the cells by clicking on the contents in the clipboard.

Tips & Warnings

  • Make sure the column cells remain highlighted as you move through the steps. If the column is not highlighted, redo Step 1.
  • Column headers are required to use the filter function. If you do not use column headers you will receive an error message.

Related Searches


  • Photo Credit Pixland/Pixland/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!