How to find duplicates from excel spreadsheet

Steps
1) Select the area you wish to be included in the search
2) On home tab click on Conditional Formatting > Highlight Cell rules > Duplicate Values (See the image below for help)

3) All the values will be...