Microsoft Office 2016: The Complete Guide (2015)
HOW TO CREATE OR REMOVE A HYPERLINK TO AN EMAIL ADDRESS
Once an email program is installed on your device, clicking the hyperlink to an email address, will instruct the email program to compose an email, by inserting an email address into the Tool box
Go to a new worksheet in excel and select the cell where the hyperlink will be created.
TIP Excel also provides the option to use objects, such as pictures or an element to represent a hyperlink.
Then select either of these options:
Go to the Insert tab, and under the Links group, select Hyperlink.
Choose the cell or image, and then click Hyperlink, or you can press Ctrl+K.
Go to Link to and select E-mail Address.
Insert the email address that will be used, in the E-mail address box.
Then go to the Subject box and compose the subject for the email.
Note that the subject line may not be familiar to some browsers.
Go to the Text to display box, and type the text that will be used to represent the hyperlink.
By selecting ScreenTip, you will be able to view helpful tips and information, when the pointer is placed on the hyperlink. Select the ScreenTip text box, and then click OK.
TIP Hyperlinks to email addresses can also be created by typing the address directly into the cell. Once an email address is typed directly into a cell, a hyperlink will automatically be created