{"id":10253,"date":"2025-01-11T15:37:20","date_gmt":"2025-01-11T15:37:20","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/11\/huong-dan-su-dung-hyperlinks-lien-ket-du-lieu-hieu-qua\/"},"modified":"2025-01-11T15:37:20","modified_gmt":"2025-01-11T15:37:20","slug":"huong-dan-su-dung-hyperlinks-lien-ket-du-lieu-hieu-qua","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/11\/huong-dan-su-dung-hyperlinks-lien-ket-du-lieu-hieu-qua\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Hyperlinks li\u00ean k\u1ebft d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ng\u01b0\u1eddi d\u00f9ng Excel s\u1eed d\u1ee5ng <strong>Hyperlinks<\/strong> li\u00ean k\u1ebft d\u1eef li\u1ec7u nh\u01b0 m\u1ed9t \u0111\u01b0\u1eddng d\u1eabn t\u1eaft nhanh g\u1ecdn nh\u1eefng ngu\u1ed3n th\u00f4ng tin kh\u00e1c. \u0110\u1ec3 hi\u1ec3u r\u00f5 c\u00e1ch thi\u1ebft l\u1eadp v\u00e0 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y, h\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\">Hocexcel.online<\/a> xem b\u00e0i vi\u1ebft b\u00ean d\u01b0\u1edbi:<\/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-6782902fda46e\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/su-dung-hyperlinks-lien-ket-du-lieu-hieu-qua.html#Thiet_lap_su_dung_Hyperlinks_lien_ket_du_lieu\" title=\"Thi\u1ebft l\u1eadp s\u1eed d\u1ee5ng Hyperlinks li\u00ean k\u1ebft d\u1eef li\u1ec7u\">Thi\u1ebft l\u1eadp s\u1eed d\u1ee5ng Hyperlinks li\u00ean k\u1ebft d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/su-dung-hyperlinks-lien-ket-du-lieu-hieu-qua.html#Chinh_sua_Hyperlinks\" title=\"Ch\u1ec9nh s\u1eeda Hyperlinks\">Ch\u1ec9nh s\u1eeda Hyperlinks<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Thiet_lap_su_dung_Hyperlinks_lien_ket_du_lieu\"><\/span><strong>Thi\u1ebft l\u1eadp s\u1eed d\u1ee5ng Hyperlinks li\u00ean k\u1ebft d\u1eef li\u1ec7u<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Thi\u1ebft l\u1eadp <strong>Hyperlinks <\/strong>l\u00e0 thao t\u00e1c \u0111\u1eb7t li\u00ean k\u1ebft t\u1edbi c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng theo \u00fd mu\u1ed1n c\u1ee7a ng\u01b0\u1eddi s\u1eed d\u1ee5ng, gi\u00fap cho c\u00e1c trang t\u00ednh c\u00f3 m\u1ed1i li\u00ean h\u1ec7 m\u1ea1ch l\u1ea1c v\u1edbi nhau v\u00e0 kh\u00f4ng b\u1ecb b\u00f3 bu\u1ed9c.<\/p>\n<p><em>\u0110\u1ec3 t\u1ea1o Hyperlink t\u1edbi m\u1ed9t trang web:<\/em><\/p>\n<p><strong>C\u00e1ch 1:<\/strong> Nh\u1eadp tr\u1ef1c ti\u1ebfp url trang web v\u00e0o \u00f4 mu\u1ed1n \u0111\u1eb7t link, sau \u0111\u00f3 \u1ea5n Enter.<\/p>\n<p><strong>C\u00e1ch 2:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20329 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-hyperlink-web.png\" alt=\"hyperlink web\" width=\"654\" height=\"414\" title=\"mos-excel-2010-hyperlink-web\"><\/p>\n<ul>\n<li>Ch\u1ecdn \u00f4 mu\u1ed1n \u0111\u1eb7t Hyperlink. M\u1edf th\u1ebb Insert, trong nh\u00f3m Links ch\u1ecdn <strong>Hyperlink<\/strong>.<\/li>\n<li>T\u1ea1i h\u1ed9p tho\u1ea1i <strong>Insert Hyperlink<\/strong>, m\u1ee5c <strong>Link to<\/strong>, ch\u1ecdn <strong>Existing File or Web Page.<\/strong><\/li>\n<li>Trong m\u1ee5c <strong>Address<\/strong>, nh\u1eadp url t\u1edbi trang web.<\/li>\n<\/ul>\n<blockquote>\n<p><strong>Xem th\u00eam<\/strong>:\u00a0 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tao-hyperlink-den-website-trong-excel.html\">T\u1ea1o link t\u1edbi website trong Excel<\/a><\/p>\n<\/blockquote>\n<p><em>\u0110\u1ec3 t\u1ea1o Hyperlink t\u1edbi m\u1ed9t file c\u00f3 s\u1eb5n:<\/em><\/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\/2025\/01\/ex101_92019-nho-147.gif\" title=\"ex101_92019-nho-147\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol>\n<li>T\u1ea1i ch\u1ee9c n\u0103ng <strong>Hyperlink <\/strong>ch\u1ecdn <strong>Existing File or Web Page.<\/strong><\/li>\n<li>T\u00ecm ki\u1ebfm file mu\u1ed1n link trong b\u1ea3ng <strong>Look in<\/strong> ho\u1eb7c b\u1eb1ng ch\u1ee9c n\u0103ng <strong>Browse for File.<\/strong><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20327 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-hyperlink-file.png\" alt=\"hyperlink file\" width=\"654\" height=\"341\" title=\"mos-excel-2010-hyperlink-file\"><\/p>\n<p><em>\u0110\u1ec3 t\u1ea1o m\u1ed9t workbook Excel m\u1edbi v\u00e0 g\u1eafn hyperlink t\u1edbi \u0111\u00f3:<\/em><\/p>\n<ol>\n<li>Ch\u1ecdn \u00f4 mu\u1ed1n \u0111\u1eb7t link.<\/li>\n<li>T\u1ea1i ch\u1ee9c n\u0103ng <strong>Hyperlink, <\/strong>m\u1ee5c <strong>Link to<\/strong>, ch\u1ecdn <strong>Create New Document<\/strong>.<\/li>\n<li>Nh\u1eadp t\u00ean cho workbook v\u00e0o m\u1ee5c <strong>Name of new document.<\/strong><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20330 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-hyperlink-new-workbook.png\" alt=\"hyperlink new workbook\" width=\"654\" height=\"341\" title=\"mos-excel-2010-hyperlink-new-workbook\"><\/p>\n<p><em>\u0110\u1ec3 t\u1ea1o Hyperlink t\u1edbi trang t\u00ednh ho\u1eb7c v\u00f9ng \u0111\u00e3 \u0111\u1eb7t t\u00ean trong workbook:<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20325 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-hyperlink-cell.png\" alt=\"hyperlink cell\" width=\"737\" height=\"410\" title=\"mos-excel-2010-hyperlink-cell\"><\/p>\n<ol>\n<li>Ch\u1ecdn \u00f4 mu\u1ed1n \u0111\u1eb7t link.<\/li>\n<li>T\u1ea1i ch\u1ee9c n\u0103ng <strong>Hyperlink<\/strong>, m\u1ee5c <strong>Link to<\/strong>, ch\u1ecdn <strong>Place in this document.<\/strong><\/li>\n<li>G\u00f5 \u00f4 mu\u1ed1n link t\u1edbi trong m\u1ee5c <strong>Type the cell reference<\/strong> ho\u1eb7c ch\u1ecdn trang t\u00ednh hay v\u00f9ng \u0111\u1eb7t t\u00ean \u0111\u1ec3 link t\u1edbi \u1edf b\u00ean d\u01b0\u1edbi.<\/li>\n<\/ol>\n<p><em>\u0110\u1ec3 t\u1ea1o Hyperlink tr\u1ecf t\u1edbi \u0111\u1ecba ch\u1ec9 th\u01b0 c\u00f3 s\u1eb5n:<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20328 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-hyperlink-mail.png\" alt=\"hyperlink mail\" width=\"653\" height=\"340\" title=\"mos-excel-2010-hyperlink-mail\"><\/p>\n<ol>\n<li>Ch\u1ecdn \u00f4 mu\u1ed1n \u0111\u1eb7t link.<\/li>\n<li>T\u1ea1i ch\u1ee9c n\u0103n <strong>Hyperlink<\/strong>, m\u1ee5c <strong>Link to<\/strong>, ch\u1ecdn <strong>E-mail Address.<\/strong><\/li>\n<li>Trong m\u1ee5c <strong>E-mail address<\/strong>, nh\u1eadp \u0111\u1ecba ch\u1ec9 mail.<\/li>\n<li>Trong m\u1ee5c <strong>Subject<\/strong>, nh\u1eadp ch\u1ee7 \u0111\u1ec1 mail.<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"Chinh_sua_Hyperlinks\"><\/span><strong>Ch\u1ec9nh s\u1eeda Hyperlinks<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Sau khi \u0111\u00e3 t\u1ea1o l\u1eadp Hyperlink, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 thay \u0111\u1ed5i ho\u1eb7c x\u00f3a \u0111i m\u00e0 kh\u00f4ng g\u00e2y ra b\u1ea5t k\u00ec s\u1ef1 thay \u0111\u1ed5i n\u00e0o v\u1ec1 n\u1ed9i dung \u0111\u00e3 li\u00ean k\u1ebft.<\/p>\n<p><em>\u0110\u1ec3 thay \u0111\u1ed5i \u0111i\u1ec3m \u0111\u1ebfn c\u1ee7a Hyperlink:<\/em><\/p>\n<ol>\n<li>Click chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 ch\u1ee9a hyperlink, sau \u0111\u00f3 ch\u1ecdn <strong>Edit Hyperlink.<\/strong><\/li>\n<li>T\u1ea1i h\u1ed9p tho\u1ea1i <strong>Edit Hyperlink<\/strong> ti\u1ebfn h\u00e0nh thay \u0111\u1ed5i th\u00f4ng tin t\u00f9y \u00fd, sau \u0111\u00f3 click OK.<\/li>\n<\/ol>\n<p><em>\u0110\u1ec3 x\u00f3a m\u1ed9t Hyperlink:<\/em><\/p>\n<ul>\n<li>Click chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 ch\u1ee9a hyperlink, ch\u1ecdn <strong>Remove Hyperlink.<\/strong><\/li>\n<\/ul>\n<figure id=\"attachment_20326\" aria-describedby=\"caption-attachment-20326\" style=\"width: 326px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20326 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-hyperlink-edit-remove.png\" alt=\"s\u1eeda x\u00f3a hyperlink\" width=\"326\" height=\"223\" title=\"mos-excel-2010-hyperlink-edit-remove\"><figcaption id=\"caption-attachment-20326\" class=\"wp-caption-text\">S\u1eeda v\u00e0 x\u00f3a Hyperlink<\/figcaption><\/figure>\n<p><em>\u00a0<\/em><\/p>\n<p>Th\u1eadt l\u00e0 d\u1ec5 d\u00e0ng ph\u1ea3i kh\u00f4ng? Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\">Hocexcel.online<\/a>\u00a0v\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo v\u1ec1 k\u0129 n\u0103ng MOS Excel 2010 nh\u00e9!<\/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\/2025\/01\/ex101_92019-nho-147.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10254,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10253","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\/10253","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=10253"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10253\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10254"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}