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?

添加图像

行业/领域：软件
类别电子表格
Created: 04:18, 3 November 2011

AnswerBea (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

类似词条

qt

软件; 软件开发

Qt is an open source software development framework ...

case-sensitive

软件; 软件工程

Computer command which specifies that each letter of a word ...

The National Broadcasting Company (NBC)

软件; 视频编辑

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

corner point

软件; 图形设计软件

When animating, you can use the Motion Editor to control ...

Truth Goggles

软件; 分析软件

In-development software, developed by MIT student Dan ...

evercookie

软件;

Evercookie is a javascript API available that produces ...

创建者

Zhangjie

词条

词汇

关注者

精选词汇表

HalimRosyid

词条

词汇

关注者

Famous Bands in Indonesia

类别：娱乐 2

20 词条

a.protic

词条

词汇

关注者

World War II Infantry Weapons

类别：历史 2

22 词条

Sanket0510

词条

词汇

关注者

Indian Super League (ISL)

类别：体育 1

3 词条

eleonora86

词条

词汇

关注者

crime

类别：其他 1