How to Remove, Highlight and Filter duplicate values in MS Excel

  • Published date: October 23, 2017
    • Pakistan

Remove, Highlight and Filter duplicate values in Microsoft Excel

In this video tutorial I try to teach how to remove, highlight and filter duplicate values in Microsoft Excel. It's very simple but very useful, this will help you in your Excel work, and if you going to apply for computer operator or office clerk then you should know this basic excel work.

Find and Remove Duplicates in Excel

Sometimes duplicate data is useful, sometimes it just makes it harder to understand your data. Use conditional formatting to find and highlight duplicate data.

Steps to find and highlight duplicate Cells

1) Select the cells you want to check for duplicates.

2) Click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.

3) In the box next to values with, pick the formatting you want to apply to the duplicate values, and then click OK.

Steps to remove duplicate Cells

1) Select the range of cells that has duplicate values you want to remove.

2) Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates.

3) Click OK

IF you have any question you can ask me in comments.


Share by email Share on Facebook Share on Twitter Share on Google+ Share on LinkedIn Pin on Pinterest

Useful information

  • Avoid scams by acting locally or paying with PayPal
  • Never pay with Western Union, Moneygram or other anonymous payment services
  • Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
  • This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"

Leave your comment (spam and offensive messages will be removed)

Related listings