# Safe Approach
1) Select column
2) Go to "Home" tab > Click "Conditional Formatting" > Highlight Cells Rules
> Duplicate Values > OK
3) Select and Delete duplicates from highlighted duplicate cells
4) Go to "Home" tab > Click "Conditional Formatting" > Clear Rule
to clear the conditional formatting
# Unsafe Approach (Automatically removes duplicate)
1) Select whole datasheet with Ctrl + Shift + End
2) Go to "Data" tab > Click "Remove Duplicates" icon
3) Select specific columns to remove duplicates from > Click "OK"