On this article, we’ll present you 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 if you end up coping with large knowledge in an Excel worksheet, this function turns out to be 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
By utilizing the Spotlight Cells Guidelines, you possibly can spotlight duplicate cells in your Excel worksheet to keep away from confusion and errors. The steps to focus on the duplicate cells in an Excel worksheet are listed beneath:
Open the Excel worksheet wherein you need to discover and spotlight the duplicate cells. I’ve created pattern knowledge of marks scored by 10 college students in numerous topics.
Now, it’s a must to choose the rows and the columns, the duplicate cells of which you need to spotlight.
After that, click on on House and go to “Conditional Formatting > Spotlight Cells Guidelines > Duplicate Values.” It will 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 pink, yellow, and inexperienced colours, and many others. Furthermore, if you do not need to fill the complete cells with colour, you possibly can spotlight their borders or texts solely. A customized format choice can be accessible there, which you’ll be able to choose to focus on the duplicate cells along with your favourite colour. If you find yourself executed, 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 House > Conditional Formatting > Clear Guidelines > Clear Guidelines from Chosen Cells.
If you choose the “Clear Guidelines from Complete Sheet” choice, it would clear the highlighted cells from the complete Excel sheet.
- Find out how to delete duplicate rows in Excel and Google Sheets.
- Find out how to calculate Compound Curiosity in Excel.