How to Remove or Highlight Duplicates in Excel
At whatever point you are utilizing an enormous arrangement of information, then, at that point, MS dominate is the application that assists with controlling and sort the information and get the eventual outcome wanted by you. The greater part of the clients utilize the essential choices in the dominate application yet there are a lot more elements which assist clients with making their information more improved and proficient. One of the elements is tracking down the copies and it is possible that you can feature or eliminate them from the bookkeeping page contingent on your prerequisite. Likewise finding the copies and erasing them is very simple in the event that you follow the means given underneath in this post. Kindly keep perusing to know more.
Step by step instructions to Highlight Duplicates in Excel Sheet
Stage 1: Press Windows key on your console and type dominate.
Stage 2: Then, press the Enter key to Open the MS Excel application.
Stage 3: Then, Click Open button to open the saved dominate sheet on which you need to feature the copies.
Stage 4: Then, select the saved dominate sheet in the open window and hit Enter key.
Stage 5: Once the dominate sheet is open, select the information which you need to feature the copies as displayed underneath.
Stage 6: Under the Home tab, Select Conditional Formatting at the right half of the Excel application to see the dropdown list.
Stage 7: Then, Hover the mouse cursor over Highlight Cells Rules and afterward, click Duplicate qualities from the rundown as displayed in the beneath screen capture.
Stage 8: Click on qualities with dropdown menu and select whichever design you need the copies to be featured.
NOTE:- I have picked Green load up with Dark Green Text, however you are allowed to pick any choice as displayed underneath.
Stage 10: You can see that for the informational index you had picked, the copies present in them are featured as displayed beneath.
Stage 10: That's it.
This is the way you can feature the copies in the dominate sheet for better examination of your information.
0 Comments