On this article, we’ll present you how you can discover and spotlight duplicate cells in Microsoft Excel. When there’s restricted knowledge in your Excel worksheet, you possibly can simply discover the duplicate cells manually. However when you find yourself coping with large knowledge in an Excel worksheet, this function is useful. Additionally, typically the duplicate values in an Excel worksheet can create confusion and make knowledge more durable to know.
Discover and spotlight Duplicate Cells in Excel
Through the use of the Spotlight Cells Guidelines, you possibly can spotlight duplicate cells in your Excel worksheet to keep away from confusion and errors. The steps to spotlight the duplicate cells in an Excel worksheet are listed under:
Open the Excel worksheet through which you wish to discover and spotlight the duplicate cells. I’ve created pattern knowledge of marks scored by 10 college students in several topics.
Now, it’s a must to choose the rows and the columns, the duplicate cells of which you wish to spotlight.
After that, click on on Dwelling and go to “Conditional Formatting > Spotlight Cells Guidelines > Duplicate Values.” This may open a brand new popup window.
Within the popup window, you possibly can choose several types of highlighting choices, by clicking on the drop-down menu.
For instance, you possibly can spotlight the duplicate cells with crimson, yellow, and inexperienced colours, and many others. Furthermore, if you don’t want to fill your complete cells with coloration, you possibly can spotlight their borders or texts solely. A customized format possibility can be obtainable there, which you’ll choose to spotlight the duplicate cells together with your favourite coloration. If you find yourself completed, click on OK. After that, Excel will spotlight all of the duplicate cells within the chosen rows and columns.
If you wish to revert the modifications, comply with the below-listed process:
- First, choose the rows and columns within the Excel worksheet.
- Go to Dwelling > Conditional Formatting > Clear Guidelines > Clear Guidelines from Chosen Cells.
If you choose the “Clear Guidelines from Complete Sheet” possibility, it would clear the highlighted cells from your complete Excel sheet.
That’s it.
Associated posts:
- How one can delete duplicate rows in Excel and Google Sheets.
- How one can calculate Compound Curiosity in Excel.
