To remove duplicates in Excel, select any cell in your data, go to the Data tab, and click Remove Duplicates in the Data Tools group. Tick the columns that define a duplicate, click OK, and Excel deletes every repeated row while keeping the first occurrence of each. The change is permanent, so work on a copy or be ready to press Ctrl+Z. If you only want to see the duplicates rather than delete them, use Conditional Formatting instead, which highlights repeats without touching the data.
Duplicate rows show up constantly after a PDF conversion, especially when you merge several months of statements or reports into one sheet and the same transaction or a repeated header row lands twice. Here is how to remove duplicates cleanly, how to find them first so you can check what you are about to delete, and the case sensitivity trap that catches people out.
How do you remove duplicates in Excel?
Click any cell inside your table, open the Data tab, and choose Remove Duplicates. A dialog lists every column with a checkbox. Leave all columns ticked to remove rows that are identical across the board, or tick only the columns that should define a match. Click OK and Excel reports how many duplicate values it removed and how many unique values remain. It keeps the first occurrence in each set and deletes the rest, working from the top down. This tool has been in Excel since the 2007 version, so it is on the ribbon in every current release on Windows and Mac.
One thing to set up first: make sure your data has a header row and no fully blank rows running through the middle, or Excel may misread where the table ends. Remove Duplicates deletes the entire row, not just the repeated cell, so anything sitting in the other columns of that row goes with it.
How do you find duplicates in Excel without deleting them?
Select the range, go to Home, then Conditional Formatting, Highlight Cells Rules, and Duplicate Values. Excel shades every cell that appears more than once so you can eyeball them before deciding what to cut. This is the safe first step: it changes nothing in the data, it only colors the repeats. To flag duplicates in a helper column instead, use a COUNTIF formula. Enter =COUNTIF($A$2:$A2,A2)>1 next to the first row and fill it down; it returns TRUE only on the second and later times a value appears, so the first occurrence stays FALSE. Filter that column to TRUE and you have an exact list of the rows Remove Duplicates would delete.
How do you remove duplicate rows based on one column?
Open Remove Duplicates and untick every column except the one that should define a match. If you have a transaction ID or an invoice number that must be unique, tick only that column and Excel removes any row whose ID repeats, regardless of what the other columns say. This matters when two rows describe the same record but a description or a date was captured slightly differently. Deduping on the key column alone catches them; deduping on all columns would keep both because they are not perfectly identical.
Is Excel Remove Duplicates case sensitive?
No. Remove Duplicates is not case sensitive, so it treats "Apple" and "apple" as the same value and deletes one of them. For most data that is what you want, but if case actually distinguishes two records you need a different approach. Add a helper column with =IF(SUMPRODUCT(--EXACT(A$2:A2,A2))=1,"keep","dup"), which uses the EXACT function to compare case exactly, then filter to the "dup" rows and delete them by hand. The built in tool has no case sensitive option, so the EXACT formula is the standard workaround.
How do you get a list of unique values in Excel?
In Excel 365 and Excel for the web, use the UNIQUE function. Enter =UNIQUE(A2:A100) and Excel spills a clean list of every distinct value, updating automatically when the source changes. That leaves your original data intact and builds the deduplicated list somewhere else, which is often safer than deleting rows in place. On older versions without UNIQUE, use Data, Advanced Filter, tick "Unique records only", and copy the result to another location.
Which duplicate tool should you use?
| Tool | What it does | Deletes data? |
|---|---|---|
| Remove Duplicates | Deletes repeated rows, keeps the first | Yes, permanent |
| Conditional Formatting | Highlights repeats in color | No |
| COUNTIF helper column | Flags each repeat TRUE or FALSE | No |
| UNIQUE function | Spills a fresh deduplicated list | No, builds a copy |
| Advanced Filter | Copies unique records elsewhere | No, builds a copy |
Why do I have duplicate rows after converting a PDF to Excel?
The usual cause is merging. When you convert several PDF statements and stack them into one sheet, any transaction that appeared on two statements, or a repeated column header that got captured from the top of each page, ends up as a duplicate row. Scanned pages can also produce near-duplicates when the same line is read twice. Before you dedupe, sort the data so repeats sit next to each other and you can confirm they are truly identical and not two legitimate transactions of the same amount. If you are stacking many files, our guide on how to combine multiple PDFs into one Excel spreadsheet covers doing it cleanly, and a good PDF to Excel conversion that keeps each page in one consistent layout leaves you far fewer repeats to remove. When the deduplicated transactions are headed into your accounting software, it is quicker to move them straight into QuickBooks than to clean the same rows twice.
Deduping is one step in a wider tidy up. If your converted sheet also has empty rows or text jammed into single cells, see how to clean up data in Excel after a PDF conversion and how to remove blank rows.
The short version
Data, Remove Duplicates, tick the columns that define a match, and Excel keeps the first of each and deletes the rest permanently. Highlight duplicates with Conditional Formatting first if you want to check before cutting, remember the tool ignores case, and use UNIQUE or Advanced Filter when you would rather build a clean list than delete rows in place. If the duplicates came from merging converted PDFs, fixing the merge upstream saves most of the work.