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

OpenCart
Software; System software

Open Cart is a unique open source shopping cart system. It ...

roving keyframe
Software; Graphic design software

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

behaviors
Software; Graphic design software

Behaviors are predefined scripts that you can attach to ...

Find My iPhone
Software; Phone apps

A smartphone app that can remotely track the location of ...

resample
Software; Graphic design software

To change the resolution and dimensions of a bitmap. ...

ActionScript
Software; Graphic design software

ActionScript is the scripting language used to control ...

Creator

Featured blossaries

Video Games Genres

Category: Entertainment   1 1 Terms

Hiking Trip

Category: Sports   1 6 Terms

Photograpy Framing

Category: Arts   1 55 Terms

Azazeel

Category: Literature   1 3 Terms

Futures Terms and Definitions

Category: Business   2 20 Terms

Table Tennis Ball

Category: Sports   1 5 Terms

TermWiki is ranked top innovative application by IDC.

© 2025 CSOFT International, Ltd.   

Follow us on: