{"id":1244,"date":"2024-12-02T04:31:40","date_gmt":"2024-12-02T04:31:40","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tao-menu-lien-ket-toi-cac-sheet-bang-ham-hyperlink\/"},"modified":"2024-12-02T04:31:40","modified_gmt":"2024-12-02T04:31:40","slug":"tao-menu-lien-ket-toi-cac-sheet-bang-ham-hyperlink","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tao-menu-lien-ket-toi-cac-sheet-bang-ham-hyperlink\/","title":{"rendered":"T\u1ea1o MENU li\u00ean k\u1ebft t\u1edbi c\u00e1c sheet b\u1eb1ng h\u00e0m Hyperlink"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o ch\u00fang ta c\u0169ng quen v\u1edbi vi\u1ec7c t\u1eadp h\u1ee3p t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u trong c\u00f9ng 1 sheet, m\u00e0 nhi\u1ec1u khi ch\u00fang ta c\u00f3 th\u00f3i quen t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u tr\u00ean nhi\u1ec1u sheet c\u00f3 c\u1ea5u tr\u00fac t\u01b0\u01a1ng t\u1ef1 nhau, ch\u1ec9 kh\u00e1c nhau v\u1ec1 T\u00ean \u0111\u1ed1i t\u01b0\u1ee3ng. H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u <strong>c\u00e1ch t\u1ea1o li\u00ean k\u1ebft c\u00e1c sheet b\u1eb1ng h\u00e0m Hyperlink.<\/strong><\/em><\/p>\n<p>Ch\u00fang ta c\u00f3 v\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p>C\u00f4ng ty A c\u00f3 10 kh\u00e1ch h\u00e0ng, v\u00e0 nh\u00e2n vi\u00ean c\u1ee7a c\u00f4ng ty th\u1ef1c hi\u1ec7n vi\u1ec7c theo d\u00f5i b\u00e1n h\u00e0ng cho 10 kh\u00e1ch h\u00e0ng n\u00e0y t\u1ea1i 10 sheet c\u00f3 c\u1ea5u tr\u00fac gi\u1ed1ng nhau trong 1\u00a0workbook:<\/p>\n<figure id=\"attachment_14656\" aria-describedby=\"caption-attachment-14656\" style=\"width: 768px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14656 size-full\" title=\"T\u1ea1o MENU li\u00ean k\u1ebft t\u1edbi c\u00e1c sheet b\u1eb1ng h\u00e0m Hyperlink\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-link-sheet-02.png\" alt=\"T\u1ea1o MENU li\u00ean k\u1ebft t\u1edbi c\u00e1c sheet b\u1eb1ng h\u00e0m Hyperlink\" width=\"768\" height=\"352\"><figcaption id=\"caption-attachment-14656\" class=\"wp-caption-text\">T\u1ea1o t\u1ea1o li\u00ean k\u1ebft c\u00e1c sheet b\u1eb1ng h\u00e0m Hyperlink<\/figcaption><\/figure>\n<p>V\u1edbi s\u1ed1 l\u01b0\u1ee3ng Sheet nhi\u1ec1u th\u00ec vi\u1ec7c thao t\u00e1c tr\u00ean SheetTab s\u1ebd khi\u1ebfn ch\u00fang ta g\u1eb7p nhi\u1ec1u kh\u00f3 kh\u0103n. Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng t\u1ea1o HyperLink (t\u1ea1o li\u00ean k\u1ebft) \u0111\u1ec3 <strong>li\u00ean k\u1ebft sheet trong Excel<\/strong> \u0111\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian thao t\u00e1c.<\/p>\n<p>Tuy nhi\u00ean vi\u1ec7c t\u1ea1o Hyperlink kh\u00e1 th\u1ee7 c\u00f4ng v\u00e0 m\u1ea5t th\u1eddi gian. Do\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p vi\u1ec7c l\u1ea5y t\u00ean Sheet\u00a0\u0111\u00e3 t\u00ecm hi\u1ec3u\u00a0\u1edf b\u00e0i h\u1ecdc tr\u01b0\u1edbc k\u1ebft h\u1ee3p v\u1edbi h\u00e0m\u00a0Hyperlink trong\u00a0Excel.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d382b7baef\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tao-menu-lien-ket-toi-cac-sheet-bang-ham-hyperlink.html#Buoc_1_Tao_danh_sach_cac_Sheet_co_trong_Workbook\" title=\"B\u01b0\u1edbc 1: T\u1ea1o danh s\u00e1ch c\u00e1c Sheet c\u00f3 trong\u00a0Workbook\">B\u01b0\u1edbc 1: T\u1ea1o danh s\u00e1ch c\u00e1c Sheet c\u00f3 trong\u00a0Workbook<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tao-menu-lien-ket-toi-cac-sheet-bang-ham-hyperlink.html#Buoc_2_Tao_lien_ket_voi_ham_Hyperlink\" title=\"B\u01b0\u1edbc 2: T\u1ea1o li\u00ean k\u1ebft v\u1edbi h\u00e0m Hyperlink\">B\u01b0\u1edbc 2: T\u1ea1o li\u00ean k\u1ebft v\u1edbi h\u00e0m Hyperlink<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_1_Tao_danh_sach_cac_Sheet_co_trong_Workbook\"><\/span><strong>B\u01b0\u1edbc 1: T\u1ea1o danh s\u00e1ch c\u00e1c Sheet c\u00f3 trong\u00a0Workbook<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 l\u00e0m\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111i\u1ec1u n\u00e0y, ch\u00fang ta h\u00e3y xem l\u1ea1i b\u00e0i\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-lay-ten-worksheet-dang-lam-viec.html\">H\u00e0m l\u1ea5y t\u00ean Worksheet \u0111ang l\u00e0m vi\u1ec7c<\/a><\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c nh\u01b0 sau (V\u00f9ng A1:B11)<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-31.gif\" title=\"vba101_92019-nho-31\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-87.gif\" title=\"ex101_92019-nho-87\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_14655\" aria-describedby=\"caption-attachment-14655\" style=\"width: 780px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14655 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-link-sheet-01.png\" alt=\"2 - T\u1ea1o li\u00ean k\u1ebft c\u00e1c sheet b\u1eb1ng h\u00e0m Hyperlink\" width=\"780\" height=\"352\" title=\"heo-link-sheet-01\"><figcaption id=\"caption-attachment-14655\" class=\"wp-caption-text\">2. T\u1ea1o li\u00ean k\u1ebft c\u00e1c sheet b\u1eb1ng h\u00e0m Hyperlink<\/figcaption><\/figure>\n<p>*<strong> Ch\u00fa\u00a0\u00fd<\/strong>: Ch\u00fang ta c\u1ea7n l\u1ea5y\u00a0\u0111\u01b0\u1ee3c t\u00ean Sheet, b\u1edfi v\u00ec c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ean sheet trong h\u00e0m Hyperlink<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_2_Tao_lien_ket_voi_ham_Hyperlink\"><\/span><strong>B\u01b0\u1edbc 2<\/strong>: T\u1ea1o li\u00ean k\u1ebft v\u1edbi h\u00e0m Hyperlink<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u1ea5u tr\u00fac h\u00e0m Hyperlink: li\u00ean k\u1ebft sheet trong Excel<\/p>\n<blockquote>\n<p>=HYPERLINK(link_location, [friendly_name])<\/p>\n<\/blockquote>\n<ul>\n<li>link_location l\u00e0\u00a0\u0111\u1ecba ch\u1ec9 c\u1ea7n li\u00ean k\u1ebft t\u1edbi.<\/li>\n<li>friendly_name l\u00e0 t\u00ean ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng cho d\u1ec5 g\u1ecdi, d\u1ec5 nh\u1edb<\/li>\n<\/ul>\n<p>Ch\u00fang ta bi\u1ebft r\u1eb1ng\u00a0Excel th\u1ec3 hi\u1ec7n tham chi\u1ebfu t\u1edbi 1 v\u1ecb tr\u00ed\u00a0\u1edf sheet kh\u00e1c nh\u01b0 sau:<\/p>\n<p>T\u00ean Sheet + D\u1ea5u ch\u1ea5m than + T\u1ecda\u00a0\u0111\u1ed9<\/p>\n<p><em>Ch\u00fa \u00fd: T\u00ean Sheet ph\u1ea3i\u00a0\u0111\u1eb7t trong d\u1ea5u nh\u00e1y\u00a0\u0111\u01a1n\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 bao g\u1ed3m c\u1ea3 nh\u1eefng t\u00ean sheet c\u00f3 s\u1eed d\u1ee5ng d\u1ea5u c\u00e1ch.<\/em><\/p>\n<figure id=\"attachment_14657\" aria-describedby=\"caption-attachment-14657\" style=\"width: 954px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14657 size-full\" title=\"T\u1ea1o li\u00ean k\u1ebft v\u1edbi h\u00e0m Hyperlink\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-link-sheet-03.png\" alt=\"T\u1ea1o li\u00ean k\u1ebft v\u1edbi h\u00e0m Hyperlink\" width=\"954\" height=\"378\"><figcaption id=\"caption-attachment-14657\" class=\"wp-caption-text\">T\u1ea1o li\u00ean k\u1ebft v\u1edbi h\u00e0m Hyperlink<\/figcaption><\/figure>\n<p>B\u1edfi v\u00ec t\u00ean c\u00e1c Sheet\u00a0\u0111\u00e3 l\u1ea5y\u00a0\u0111\u01b0\u1ee3c\u00a0\u1edf c\u1ed9t B, do\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 t\u1ea1o\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng cho <strong>link_location<\/strong> nh\u01b0 sau:<\/p>\n<ul>\n<li>Th\u00e0nh ph\u1ea7n 1: D\u1ea5u # v\u00e0 d\u1ea5u \u2018\u00a0\u0111\u1eb7t c\u1ea1nh nhau v\u00e0\u00a0\u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p<\/li>\n<li>Th\u00e0nh ph\u1ea7n 2: T\u00ean sheet l\u00e0 k\u1ebft qu\u1ea3\u00a0\u1edf c\u1ed9t B<\/li>\n<li>Th\u00e0nh ph\u1ea7n 3: D\u1ea5u nh\u00e1y\u00a0\u0111\u01a1n v\u00e0 d\u1ea5u ch\u1ea5m than, t\u1ecda\u00a0\u0111\u1ed9 A1\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1eb7t c\u1ea1nh nhau v\u00e0\u00a0\u0111\u1eb7t trong d\u1ea5u nh\u00e1y k\u00e9p<\/li>\n<\/ul>\n<p>=&gt; Ba th\u00e0nh ph\u1ea7n tr\u00ean\u00a0\u0111\u01b0\u1ee3c n\u1ed1i v\u1edbi nhau b\u1edfi d\u1ea5u &amp;<\/p>\n<p><strong>Friendly_name<\/strong> c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng tr\u1ef1c ti\u1ebfp t\u00ean Sheet ho\u1eb7c t\u00ean ch\u00fang ta t\u1ef1\u00a0\u0111\u1eb7t ra cho t\u1eebng sheet\u00a0\u0111\u1ec3 d\u1ec5 g\u1ecdi<\/p>\n<p>Nh\u01b0 v\u1eady v\u1edbi c\u00f4ng th\u1ee9c Hyperlink ch\u00fang ta c\u00f3 th\u1ec3 t\u1ea1o li\u00ean k\u1ebft t\u1edbi t\u1eebng Sheet trong Workbook m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, \u0111i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t c\u00f3 \u00edch khi l\u00e0m vi\u1ec7c tr\u00ean nh\u1eefng workbook c\u00f3 nhi\u1ec1u sheet, c\u00f3 t\u00ean Sheet d\u00e0i, kh\u00f3 s\u1eed d\u1ee5ng thanh SheetTab. C\u00e1c b\u1ea1n \u0111\u00e3 n\u1eafm r\u00f5 c\u00e1ch t\u1ea1o li\u00ean k\u1ebft sheet trong Excel r\u1ed3i \u0111\u1ea5y<\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc.<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-31.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1245,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1244","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1244","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=1244"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1244\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1245"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}