Home > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909

How to Highlight or Remove Duplicates in Excel 2007?

I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?

Answers (1)

Joseal

For Excel 2007, this is pretty easy. Just go to the Data menu and then select Remove Duplicates from the Data Tools section on the top quick access toolbar.

05:56, 4 November 2011

You have to log in to post to discussions.

Related terms

roving keyframe
Software; Graphic design software

Roving keyframes let you create smooth animation across a ...

SAS Institute
Software; Software development

SAS Institute is a developer of analytics software based in ...

The National Broadcasting Company (NBC)
Software; Video editing

Television network that was an original proponent of the ...

download
Software; Globalization software service

To transfer data from a computer to a connected device, ...

Tesco Groceries
Software; Phone apps

Tesco Grocery is a Google Glassware software lets you ...

virus
Software; Anti virus

A virus is a computer program file capable of attaching to ...

Creator

Featured blossaries

Skiing

Category: Sports   2 9 Terms

Martial Arts

Category: Sports   2 11 Terms

African Women in Politics

Category: Politics   1 15 Terms

10 Classic Cocktails You Must Try

Category: Education   1 10 Terms

Leaf vegetables

Category: Food   1 19 Terms

Food products of Greece

Category: Other   1 2 Terms

TermWiki is ranked top innovative application by IDC.

© 2024 CSOFT International, Ltd.   

Follow us on: