How to set a unique key in Excel column

1. Select a column you want to set the rule
2. Go to Date tab->Data Validation
3. In Settings tab, allow->custom, Formula "=COUNTIF(A:A,A1)=1"
4. In Error Alert tab, write something in Title, in Error message do the same, write whatever you want
5. Press OK, that's it. Simple as that