Open the Excel worksheet in which you want to find and highlight the duplicate cells. I have created sample data of marks scored by 10 students in different subjects.

Type a word into a cell that is adjacent to the cells in which you want to duplicate it. Point to the lower-right corner of that cell so that the cursor becomes a solid cross or plus sign. Click ...

If you need to count duplicate values in a column in Excel, read through this article. Count duplicate values in a column in Excel The needful can be achieved using the COUNTIF function.

From the dropdown, choose Highlight Cells Rules, and then choose Duplicate Values from the resulting submenu (Figure A). Choose a preset format from the dropdown to the right (Figure B).

Open the Excel worksheet and select the range of cells that you want to search for duplicate items. For example, you might want to click a column header to select a column of telephone numbers.

1. In Excel, select the cell, group of cells, or entire column that has the text you want to split. It doesn't need to have delimiters. 2. Click the "Data" tab and then click "Text to Columns." 3.

Then, click the Conditional Formatting dropdown in the Styles group. From the dropdown, choose Highlight Cells Rules, and then choose Duplicate Values from the resulting submenu (Figure A).