Remove duplicate rows

Remove Duplicates keeps the first of each row and deletes the copies.

2 steps1 minutesPlans: Free, Personal, Pro, Enterprise

  1. 1

    Click in the list

    Any cell with data.

    Click in the list
  2. 2

    Press Remove Duplicates

    On the Data tab. Choose the columns that must match, then press OK.

    Press Remove Duplicates

Was this helpful?

We count yes and no per article. Nothing about you is stored.

Related tasks

Filter a listShow only the rows you need.2 steps, 1 minImport a CSV or text fileBring in data from a bank, shop or other program.2 steps, 2 min

Still stuck? Ask us.

People, not a bot. We answer within one working day.

Write to us