How to Find Duplicate Entries on Excel

1. Launch Microsoft Office Excel 2007 on your computer.
2. Select the rows or columns where you want to find the duplicate entries. Point your mouse in the first cell and continue to hold down the mouse while you drag over the cells you wish to search.
3. Click the 'Home' tab and then click 'Conditional Formatting' under 'Styles' in the top menu.
4. Select 'Highlight Cells Rules' from the drop-down menu. Click on 'Duplicate Values.'
5. Select 'Duplicate' under 'Format cells that contain:' in the Duplicate Values dialog box.
6. Select a highlighting style from the drop-down menu in the Duplicate Values dialog box. Styles include a variety of fill and text-color options.
7. Click 'OK.' All duplicate values will be highlighted in your Excel spreadsheet.