Free Computer Courses-For Dummies

Easy Steps Remove Duplicate Records in Excel 2003 ,2007,and 2010

Generally in office 2003, the option for removing duplicate records is hidden compare to office 2007.

So Here is the Simple Steps to Remove Duplicate records from Excel 2003

Step1:Select the row or column that contains duplicate record, that you would like to remove.

Step2: Go to Data—–Filter Range—>click Advanced Range

Step3:Make sure that range is correct and check the option “unique records only“,as shown in figure. press Ok.

Now Duplicate records are removed. By using this option you can either choose replace the content option or copy unique records to a new location.

Steps to Remove Duplicate Records in MS Excel 2007

In MS Excel 2007 selection(Highlighting)of duplicate records and deletion of that record is a easy task compare to office 2003.

Step 1 :Select the columns or rows which is having duplicate records.

Step2 Go to the Data tab and under data tools, click Remove duplicates. This would remove duplicate records and cells from selected row and column.

Steps to highlight duplicate cells in Excel 2007

Select the cells which you want to highlight Click on Home tab —>Styles, Click on Conditional Formatting. Go to Highlight Cell Rules option and Click Duplicate Value.

So here you can highlight the duplicate cells or the unique cells by selecting values in styles.

Steps to Remove Duplicate Records in MS Excel 2010.

In Office 2010 MS Excel Removal of Duplicate records is too easy.The cool part is that you don’t need to select any specific row before removing the duplicate rows, the built-in Remove Duplicate feature will monitor the your content.

Step1: Select the portion of your excel table.

Step2: Go to data tab Click on remove duplicates.

Duplicate records are now removed and you will get confirmation message as shown in this figure

[ office Excel 2010 Figure Credit:http://www.addictivetips.com]

Be the first to comment - What do you think? Posted by Chandrashekhar - January 18, 2010 at 10:29 am

Categories: Free Computer Courses-For Dummies, News Tags:

5 Excellent Online HTML Tutorials

1.W3School

W3Schools, you can study everything you need to learn, in an accessible and handy format.It is very famous for HTML Online tutorials

2.HTML DOG
If you have looked at tutorials, you might have found that they mention certain things that HTML Dog does not. This is because many methods are obsolete, non-standard or just plain bad practice. Getting into the frame of mind of doing things the right way from the start will turn in to much better results in the end.

3.HTML.NET

This site also provides a good HTML Tutorial will give you an easy, yet thorough and correct introduction on how to make websites. The tutorial starts from scratch and requires absolutely no prior knowledge of programming.

4.Quackit
This Another HTML Tutorial is for beginners. It teaches you HTML from the ground up – starting with the basics. Coding HTML is actually quite easy – as this tutorial will show you.