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?