Lyte Byte

In the previous version of Excel, deleting duplicate cells or highlighting was a feature known only to a pro but with Excel 2007 from MS Office deleting duplicate cells or even highlighting is an easy task.

Let us see how to delete duplicates or highlight them one by one.

How to Remove or delete duplicate cells in Excel 2007?

Select the columns or rows where you want to find the duplicate cells.

Go to the Data tab and under data tools, click Remove duplicates. This would remove duplicate cells and their corresponding rows.

But most of the time, it deletes all the corresponding data in the rows and you may want to review the duplicate cells before deleting it. In this case highlighting the duplicate cells helps.

So how to highlight the duplicate cells in Excel 2007?

Again, select the cells that you want to highlight. Under the Home tab, under Styles, Click Conditional Formatting. Go to Highlight Cell Rules and Click Duplicate Values.

Here you can either highlight the duplicate cells or the unique cells. Choose your selection and format styles. Click Ok.

Now depending on your choices all the duplicate cells will be highlighted, you may choose to review and then delete duplicate cells based on the tips above.

Share This