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:
- Click the Data tab.
- In the Data Tools section, click Remove Duplicates.
- Select the columns (usually all of them.)
- Click OK.
Was that fast enough?