RSS

How to remove duplicates from Excel 2010?

04 May

Microsoft has made it quicker to remove duplicate rows in Excel 2010, all it takes now is two simple steps. The best part is that you don’t need to select any specific row before removing the duplicate rows, the build-in Remove Duplicate feature takes care of it.

If you want to get rid of all duplicate columns in an excel spreadsheet, click Select All, so that all columns are selected and then click OK.

There is also another way of doing it. It’s bit longer but more useful.

IInsert table>remove duplicates

Now you can remove duplicates or lot many things…..

see the multiple options in the menu bar under “format table”

Advertisements
 
Leave a comment

Posted by on May 4, 2012 in MS Excel, My Home

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: