{"id":7036,"date":"2024-12-21T16:47:30","date_gmt":"2024-12-21T16:47:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/gui-thu-bang-hyperlink-trong-excel\/"},"modified":"2024-12-21T16:47:30","modified_gmt":"2024-12-21T16:47:30","slug":"gui-thu-bang-hyperlink-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/gui-thu-bang-hyperlink-trong-excel\/","title":{"rendered":"G\u1eedi th\u01b0 b\u1eb1ng Hyperlink trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>B\u1ea1n c\u00f3 bi\u1ebft, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng <strong>g\u1eedi th\u01b0 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Hyperlink<\/strong> trong Excel? N\u00f3i m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Hyperlink trong Excel \u0111\u1ec3 chu\u1ea9n b\u1ecb n\u1ed9i dung th\u01b0 v\u00e0 c\u00e1c y\u1ebfu t\u1ed1 k\u00e8m theo 1 email nh\u01b0 \u0111\u1ecba ch\u1ec9 g\u1eedi t\u1edbi, \u0111\u1ecba ch\u1ec9 cc, ti\u00eau \u0111\u1ec1 th\u01b0 v\u00e0 n\u1ed9i dung th\u01b0 ngay trong Excel th\u00f4ng qua h\u00e0m Hyperlink<\/em><\/p>\n<p>Sau khi th\u01b0 so\u1ea1n \u0111\u00e3 s\u1eb5n s\u00e0ng, b\u1ea1n ch\u1ec9 c\u1ea7n b\u1ea5m v\u00e0o Hyperlink n\u00e0y l\u00e0 t\u1ea5t c\u1ea3 nh\u1eefng th\u00f4ng tin \u0111\u01b0\u1ee3c chu\u1ea9n b\u1ecb s\u1eb5n s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n sang Outlook \u0111\u1ec3 s\u1eb5n s\u00e0ng g\u1eedi \u0111i. T\u1ea5t c\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn chi ti\u1ebft ngay sau \u0111\u00e2y.<\/p>\n<figure id=\"attachment_31712\" aria-describedby=\"caption-attachment-31712\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/gui-thu-bang-ham-hyperlink.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31712\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/gui-thu-bang-ham-hyperlink.png\" alt=\"G\u1eedi th\u01b0 b\u1eb1ng h\u00e0m Hyperlink trong Excel\" width=\"500\" height=\"216\" title=\"gui-thu-bang-ham-hyperlink\"><\/a><figcaption id=\"caption-attachment-31712\" class=\"wp-caption-text\">G\u1eedi th\u01b0 b\u1eb1ng h\u00e0m Hyperlink trong Excel<\/figcaption><\/figure>\n<p>N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng ch\u00e8n Hyperlink b\u00ecnh th\u01b0\u1eddng v\u00e0 ch\u1ecdn lo\u1ea1i li\u00ean k\u1ebft \/ lo\u1ea1i link l\u00e0 g\u1eedi Email th\u00ec th\u00f4ng qua giao di\u1ec7n c\u1ee7a Excel, b\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 c\u00f3 m\u1ed9t s\u1ed1 gi\u1edbi h\u1ea1n c\u00e1c l\u1ef1a ch\u1ecdn v\u00e0 v\u1edbi c\u00e1ch l\u00e0m n\u00e0y n\u1ed9i dung th\u01b0 v\u00e0 c\u00e1c th\u00f4ng tin li\u00ean quan s\u1ebd kh\u00f4ng th\u1ec3 linh ho\u1ea1t nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Hyperlink.<\/p>\n<figure id=\"attachment_31713\" aria-describedby=\"caption-attachment-31713\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/hop-thoai-edit-link.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31713\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/hop-thoai-edit-link.png\" alt=\"H\u1ed9p tho\u1ea1i edit link trong Excel\" width=\"500\" height=\"258\" title=\"hop-thoai-edit-link\"><\/a><figcaption id=\"caption-attachment-31713\" class=\"wp-caption-text\">H\u1ed9p tho\u1ea1i edit link trong Excel<\/figcaption><\/figure>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 t\u1ea1o ra \u0111\u01b0\u1eddng link gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 g\u1eedi email \u0111i nhanh ch\u00f3ng trong Excel b\u1eb1ng h\u00e0m Hyperlink, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y t\u1ea1i 1 \u00f4 b\u1ea5t k\u1ef3 m\u00e0 b\u1ea1n mu\u1ed1n d\u00f9ng \u00f4 \u0111\u00f3 l\u00e0m n\u00fat \u201cG\u1eedi th\u01b0\u201d:<\/p>\n<p><code class=\"excel-formula\">=HYPERLINK(\"mailto:\" &amp; A2 &amp; \"?cc=\" &amp; B2 &amp;\"&amp;subject=\" &amp; C2 &amp; \"&amp;body=\" &amp; D2,\"G\u1eedi th\u01b0\")<\/code><\/p>\n<p>V\u1edbi nh\u1eefng th\u00f4ng tin sau \u0111\u00e2y:<\/p>\n<ul style=\"list-style-type: square\">\n<li>A2 ch\u1ee9a Email ng\u01b0\u1eddi nh\u1eadn<\/li>\n<li>B2 ch\u1ee9a th\u00f4ng tin Email ch\u00fang ta s\u1ebd cc t\u1edbi<\/li>\n<li>C2 ch\u1ee9a th\u00f4ng tin v\u1ec1 ti\u00eau \u0111\u1ec1 c\u1ee7a Email<\/li>\n<li>D2 ch\u1ee9a th\u00f4ng tin v\u1ec1 n\u1ed9i dung Email.<\/li>\n<\/ul>\n<p>Trong \u00f4 D2 \u1edf h\u00ecnh minh ho\u1ea1 \u0111\u1ea7u b\u00e0i, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y c\u00f3 1 chu\u1ed7i l\u1ea1, \u0111\u00f3 l\u00e0 %0A (d\u1ea5u ph\u1ea7n tr\u0103m, s\u1ed1 kh\u00f4ng, ch\u1eef A), khi b\u1ea1n vi\u1ebft chu\u1ed7i n\u00e0y v\u00e0o trong ph\u1ea7n n\u1ed9i dung Email ch\u1ee9a trong \u00f4 D2, th\u00ec khi sang Outlook s\u1ebd hi\u1ec3u l\u00e0 t\u1ea1i v\u1ecb tr\u00ed \u0111\u00f3, b\u1ea1n s\u1ebd mu\u1ed1n xu\u1ed1ng d\u00f2ng v\u00e0 Outlook s\u1ebd t\u1ef1 \u0111\u1ed9ng thay chu\u1ed7i k\u00ed t\u1ef1 n\u00e0y b\u1eb1ng k\u00ed t\u1ef1 xu\u1ed1ng d\u00f2ng cho b\u1ea1n. Nh\u01b0 v\u1eady, ch\u1ec9 v\u1edbi 1 c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Hyperlink \u0111\u1ec3 gi\u00fap vi\u1ec7c g\u1eedi Email tr\u1edf n\u00ean nhanh ch\u00f3ng h\u01a1n v\u00e0 ti\u1ec7n l\u1ee3i h\u01a1n 1 ch\u00fat.<\/p>\n<p>C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd quan t\u00e2m t\u1edbi nh\u1eefng n\u1ed9i dung sau <a href=\"https:\/\/www.youtube.com\/watch?v=LWZdEMdr3wM\" target=\"_blank\" rel=\"noopener noreferrer\">video<\/a> sau \u0111\u00e2y:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-634.gif\" title=\"ex101_92019-nho-634\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/LWZdEMdr3wM\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe>\n<p>C\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/gui-thu-bang-hyperlink-trong-excel.html\"><strong>g\u1eedi th\u01b0 b\u1eb1ng Hyperlink<\/strong><\/a> do <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> h\u01b0\u1edbng d\u1eabn. H\u1eb9n g\u1eb7p l\u1ea1i c\u00e1c b\u1ea1n trong nh\u1eefng b\u00e0i h\u1ecdc t\u1edbi<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-634.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7037,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7036","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7036","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=7036"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7036\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7037"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}