How to Remove, Highlight and Filter duplicate values in MS Excel - Urdu/Hindi Tutorial

  • Published date: October 23, 2017
  • Modified date: October 23, 2017
    • Pakistan

Remove, Highlight and Filter duplicate values in MS Excel - Urdu/Hindi Tutorial


In this video tutorial I try to teach how to remove, highlight and filter duplicate values in Microsoft Excel in Urdu or Hindi Language. 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

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

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

    Microsoft Excel October 23, 2017

    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, a...

  • How to use Pivot Table to simplify our data  in Microsoft Excel

    How to use Pivot Table to simplify our data in Microsoft Excel

    Microsoft Excel October 23, 2017

    Pivot Table to simplify our data in Microsoft Excel In this video tutorial I try to teach how to use Pivot Table option in Microsoft Excel to simplify our data. Friends Pivot Table is very great feature of Excel that help us to simplify our big data ...

  • How to use Pivot Table to simplify our data  in Microsoft Excel - Urdu/Hindi Tutorial

    How to use Pivot Table to simplify our data in Microsoft Excel - Urdu/Hindi Tutorial

    Microsoft Excel October 23, 2017

    Pivot Table to simplify our data in Microsoft Excel - Urdu/Hindi Tutorial In this video tutorial I try to teach how to use Pivot Table option in Microsoft Excel to simplify our data in Urdu and Hindi Language. Friends Pivot Table is very great featur...