Deleting Duplicate Entries

Im a total noob...sorry if this is a really basic question.


I need help with sorting our company mailing list in Excel. Specifically I need help in deleting duplicate entries. I know how to delete duplicates but I don't know how to delete them in such a way that it deletes the entire row even though I am only deleting duplicates from a single column. Does that make sense? I want to be able to search the Address column for example and find duplicates but when I delete the duplicate Address's I want the entire row to delete with it (even if the rest of the entries i.e. Name or email address is different). This way when I delete them all the information still lines up.

Thank you in advance!