If you have an Excel spreadsheet with many duplicate rows that need removed, deleting them one by one could require a big chunk of time. Fortunately, Excel makes it fairly simple to remove duplicate rows.
First, so that you don't accidentally disturb your original data, right click on the tab of the worksheet and select Move or Copy. Then click Move to End and Create a Copy.
Next, right click on the tab again and click Insert to create a blank worksheet where you'll paste the new data.
Go to the worksheet where your data was copied, and select all the rows where you want to remove duplicates, including column headers.
Select the Data tab, then click Advanced, beside the word Filter. (In Excel 2003/2002, click Data, Filter, Advanced Filter.)
Make sure Filter list in Place is selected, and click next to Unique Records Only to select it.
Click OK.
The list is displayed without the duplicate records.
Then, press Alt + ; (hold down the Alt key and press the semicolon key) to select visible cells only.
Press Ctrl + C to copy the visible cells.
Go to the blank worksheet and press Ctrl + V to paste the rows without duplicates.
You can now delete the worksheet where you had originally copied the data and applied the filter. Right click on its tab and select Delete.
You're left with the original worksheet with the duplicates and the new worksheet without duplicates.
Comments