{"id":1447,"date":"2012-12-05T10:48:18","date_gmt":"2012-12-05T10:48:18","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1447"},"modified":"2025-12-07T00:55:35","modified_gmt":"2025-12-07T00:55:35","slug":"add-an-email-hyperlink-to-and-excel-worksheet","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/add-an-email-hyperlink-to-and-excel-worksheet\/","title":{"rendered":"Add an email hyperlink to an Excel Worksheet"},"content":{"rendered":"<p>Hyperlinks can add links to an Outlook email address to your Excel worksheet. \u00a0Here is how to do it.<\/p>\n<p>In the cell you wish to add the email address, go to the Insert tab, and select the hyperlink button<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/12\/hyperlink-button-excel-courses-in-london.png\"><img decoding=\"async\" class=\"size-full wp-image-1448\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/12\/hyperlink-button-excel-courses-in-london.png\" alt=\"hyperlink-button-excel-courses-in-london\" width=\"72\" height=\"99\" \/><\/a><\/p>\n<p>Type your preferred text into the cell (this saves space as email address are long). \u00a0This will be the text the user will click on to access the email address.<\/p>\n<p>Right-click on this cell and click on Hyperlink. This will open \u00a0the Insert Hyperlink dialog box. \u00a0Click the E-Mail Address button at the bottom left side.<\/p>\n<figure id=\"attachment_1449\" aria-describedby=\"caption-attachment-1449\" style=\"width: 148px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/12\/email-address-excel-training-in-london.png\"><img decoding=\"async\" class=\"size-medium wp-image-1449\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/12\/email-address-excel-training-in-london-148x300.png\" alt=\"email-address-excel-training-in-london\" width=\"148\" height=\"300\" \/><\/a><figcaption id=\"caption-attachment-1449\" class=\"wp-caption-text\">Link to the email address from here.<\/figcaption><\/figure>\n<p>Type the email address into the Address field and click OK.<\/p>\n<p>Now you can add a screen tip by clicking on the screen tip button.<\/p>\n<figure id=\"attachment_1450\" aria-describedby=\"caption-attachment-1450\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/12\/screentip-excel-training-in-London.png\"><img decoding=\"async\" class=\"size-medium wp-image-1450\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/12\/screentip-excel-training-in-London-300x129.png\" alt=\"screentip-excel-training-in-London\" width=\"300\" height=\"129\" \/><\/a><figcaption id=\"caption-attachment-1450\" class=\"wp-caption-text\">the screentip button.<\/figcaption><\/figure>\n<p>Add the text you want to appear in the dialogue box, and then click ok.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/12\/hyperlink-and-screentip-excel-training-in-London.png\"><img decoding=\"async\" class=\"size-full wp-image-1451\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/12\/hyperlink-and-screentip-excel-training-in-London.png\" alt=\"hyperlink-and-screentip-excel-training-in-London\" width=\"174\" height=\"83\" \/><\/a><\/p>\n<p>Here is the hyperlink in place. The text shows &#8220;go&#8221;, and the screen tip &#8220;Sam&#8217;s email&#8221; appears when the cursor hovers over the cell.<\/p>\n<p>This is the sort of thing we <a href=\"https:\/\/www.stl-training.co.uk\/microsoft\/excel-training-london.php\">teach on our Excel training London<\/a> courses.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hyperlinks can add links to an Outlook email address to your Excel worksheet. \u00a0Here is how to do it. In the cell you wish to add the email address, go to the Insert tab, and select the hyperlink button Type your preferred text into the cell (this saves space as email address are long). \u00a0This [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"singular-low-link.php","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[223,306],"class_list":["post-1447","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-excel-training-in-london","tag-hyperlinks-in-excel"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1447","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1447"}],"version-history":[{"count":3,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1447\/revisions"}],"predecessor-version":[{"id":7817,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1447\/revisions\/7817"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}