81. Excel Tips - Add a Link To Email

Nick's picture


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:

add-a-link-to-email

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:

AttachmentSize
add-a-link-to-email.xls27 KB

Add a Link To Email in Excel

Thanks for this tip, however what are the business senarios this feature could be used ?