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

bone tool
Software; Graphic design software

Inverse kinematics (IK) is a method for animating an object ...

LizaMoon
Software; Anti virus

A scareware that uses SQL injection to force scripts into ...

Cyanogen
Software; Operating systems

Cyanogen is a US-based mobile software company that ...

4images
Software; System software

4images is a powerful web-based image gallery management ...

LivingSocial
Software; Phone apps

Similar to Groupon, you can use this app to gain hand-held ...

cloud computing
Computer; Servers

Cloud computing relies on sharing of resources to achieve ...

Creator

Featured blossaries

Under the Dome

Category: Other   2 5 Terms

Linguistics

Category: Languages   1 10 Terms

Famous Novels

Category: Literature   6 20 Terms

Greek Mythology

Category: History   1 20 Terms

Dark Princess - Stop My Heart

Category: Entertainment   1 10 Terms

Azazeel

Category: Literature   1 3 Terms

TermWiki is ranked top innovative application by IDC.

© 2024 CSOFT International, Ltd.   

Follow us on: