short banner

Remove Duplicate Rows in Excel

May 23, 2011

If you have a large spreadsheet with duplicate rows, you probably would like to have a fast, easy way to remove all of the duplicates. Try this:

  1. Click the Data tab.
  2. In the Data Tools section, click Remove Duplicates.
  3. Select the columns (usually all of them.)
  4. Click OK.

Was that fast enough?

Contact Information

Archive of Tips

 Computer Tutorials 

Tips by Programs

Access 

Excel 

Outlook 

PowerPoint 

Word