Adding a link to an email address is simple in Excel:

• All you have to do is to type in the email address into the cell, and it automatically adds a hyperlink that will launch your mail program and compose a mail addressed to the address you typed in

You can then right click and edit the hyperlink, adding a subject, or changing the text that is displayed whilst keeping the link the same.

Here's a screen shot what it looks link in Excel:

Download sheet to practise how to Add a Link To Email in Excel

Training Video on how to Add a Link To Email in Excel: