How to Remove Duplicate Rows in Excel Without Losing the Wrong Records

October 29, 2026

Remove duplicate rows in Excel after deciding which fields identify the same record. These steps cover desktop Excel for Windows and Excel for the web.

Keep the original and review duplicates

Copy the original table to another worksheet or workbook first. To inspect repeated values, select the relevant cells, then choose Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values. Select a format and confirm.

For example, repeated customer names may be legitimate when the rows contain different orders. Decide whether your key should be an order ID, an email address, or a combination of columns before deleting anything.

Remove the matching rows

  1. Select the complete table or range you want to clean.
  2. Choose Data > Remove Duplicates.
  3. Select only the columns that define a duplicate. Choosing two columns means both values must match.
  4. Select OK and review Excel’s count of removed duplicates and remaining unique records.

Excel retains the first occurrence. When the selected key matches, it removes the entire duplicate row within the table or range, including values in columns you did not select as keys.

Verify the result

Compare several retained records with the original. Check totals and important identifiers, especially where names repeat. If the wrong rows disappeared, use Ctrl + Z immediately and revise the key before trying again.

If your data has outlines or subtotals, remove those before using Remove Duplicates. For a visual review workflow, see our Excel conditional formatting guide.

Sources

Topics:
Read next
November 21, 2026

How to Create and Configure a Shared Mailbox in Microsoft 365

Create a Microsoft 365 shared mailbox, grant the correct Full Access and Send As permissions, understand automapping and licensing, and verify that users can work from Outlook safely.
November 17, 2026

Microsoft 365 Business Basic vs Standard vs Premium vs E3 in Canada (2026): Which Plan Should You Buy?

A practical Canadian comparison of Microsoft 365 Business Basic, Standard, Premium, and E3, including verified November 2026 pricing, feature differences, user limits, hidden costs, and recommendations by business need.