{"id":1068,"date":"2024-12-02T04:01:12","date_gmt":"2024-12-02T04:01:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-chen-hyperlink-vao-bang-tinh-de-di-chuyen-giua-nhieu-trang-tinh\/"},"modified":"2024-12-02T04:01:12","modified_gmt":"2024-12-02T04:01:12","slug":"cach-chen-hyperlink-vao-bang-tinh-de-di-chuyen-giua-nhieu-trang-tinh","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-chen-hyperlink-vao-bang-tinh-de-di-chuyen-giua-nhieu-trang-tinh\/","title":{"rendered":"C\u00e1ch ch\u00e8n Hyperlink v\u00e0o b\u1ea3ng t\u00ednh \u0111\u1ec3 di chuy\u1ec3n gi\u1eefa nhi\u1ec1u trang t\u00ednh"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n 3 c\u00e1ch \u0111\u1ec3 th\u00eam <strong>Hyperlink <\/strong>v\u00e0o b\u1ea3ng t\u00ednh \u0111\u1ec3 di chuy\u1ec3n gi\u1eefa nhi\u1ec1u trang t\u00ednh. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecba ch\u1ec9 \u0111\u1ebfn c\u1ee7a m\u1ed9t \u0111\u01b0\u1eddng link, thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a n\u00f3 c\u0169ng nh\u01b0 c\u00e1ch x\u00f3a n\u00f3.<\/em><\/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-674d3107c76fe\" 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\/cach-chen-hyperlink-vao-bang-tinh-de-di-chuyen-giua-nhieu-trang-tinh.html#Chen_mot_Hyperlink_trong_Excel\" title=\"Ch\u00e8n m\u1ed9t Hyperlink trong Excel\">Ch\u00e8n m\u1ed9t Hyperlink trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-hyperlink-vao-bang-tinh-de-di-chuyen-giua-nhieu-trang-tinh.html#Chen_Hyperlink_vao_danh_muc_noi_dung\" title=\"Ch\u00e8n Hyperlink v\u00e0o danh m\u1ee5c n\u1ed9i dung\">Ch\u00e8n Hyperlink v\u00e0o danh m\u1ee5c n\u1ed9i dung<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-hyperlink-vao-bang-tinh-de-di-chuyen-giua-nhieu-trang-tinh.html#Ham_HYPERLINK\" title=\"H\u00e0m HYPERLINK\">H\u00e0m HYPERLINK<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-hyperlink-vao-bang-tinh-de-di-chuyen-giua-nhieu-trang-tinh.html#Chen_lien_ket_bang_cach_keo_va_tha_o_tinh\" title=\"Ch\u00e8n li\u00ean k\u1ebft b\u1eb1ng c\u00e1ch k\u00e9o v\u00e0 th\u1ea3 \u00f4 t\u00ednh\">Ch\u00e8n li\u00ean k\u1ebft b\u1eb1ng c\u00e1ch k\u00e9o v\u00e0 th\u1ea3 \u00f4 t\u00ednh<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-hyperlink-vao-bang-tinh-de-di-chuyen-giua-nhieu-trang-tinh.html#Sua_mot_Hyperlink\" title=\"S\u1eeda m\u1ed9t Hyperlink\">S\u1eeda m\u1ed9t Hyperlink<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-hyperlink-vao-bang-tinh-de-di-chuyen-giua-nhieu-trang-tinh.html#Thay_doi_dia_diem_den_cua_Hyperlink\" title=\"Thay \u0111\u1ed5i \u0111\u1ecba \u0111i\u1ec3m \u0111\u1ebfn c\u1ee7a Hyperlink\">Thay \u0111\u1ed5i \u0111\u1ecba \u0111i\u1ec3m \u0111\u1ebfn c\u1ee7a Hyperlink<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-hyperlink-vao-bang-tinh-de-di-chuyen-giua-nhieu-trang-tinh.html#Sua_doi_dinh_dang_hyperlink\" title=\"S\u1eeda \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng hyperlink\">S\u1eeda \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng hyperlink<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-chen-hyperlink-vao-bang-tinh-de-di-chuyen-giua-nhieu-trang-tinh.html#Loai_bo_Hyperlink\" title=\"Lo\u1ea1i b\u1ecf Hyperlink\">Lo\u1ea1i b\u1ecf Hyperlink<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Chen_mot_Hyperlink_trong_Excel\"><\/span><strong>Ch\u00e8n m\u1ed9t Hyperlink trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu b\u1ea1n c\u1ea7n ch\u00e8n <strong>Hyperlink <\/strong>v\u00e0o Excel t\u1eeb 2010 t\u1edbi 2016, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t trong nh\u1eefng ki\u1ec3u <strong>Hyperlink <\/strong>sau: link d\u1eabn t\u1edbi m\u1ed9t t\u1ec7p m\u1edbi, t\u1edbi m\u1ed9t trang web ho\u1eb7c m\u1ed9t \u0111\u1ecba ch\u1ec9 email. V\u00ec ti\u00eau \u0111\u1ec1 c\u1ee7a b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec1 c\u1eadp t\u1edbi vi\u1ec7c t\u1ea1o hyperlink d\u1eabn t\u1edbi m\u1ed9t trang t\u00ednh kh\u00e1c trong c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh, n\u00ean HEO\u00a0s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 3 c\u00e1ch \u0111\u1ec3 th\u1ef1c hi\u1ec7n n\u00f3.<\/p>\n<p>Xem th\u00eam: <strong>H\u01b0\u1edbng d\u1eabn t\u1ea1o <a href=\"http:\/\/blog.ezworkapp.com\/tao-menu-lien-ket-toi-cac-sheet-bang-ham-hyperlink.html\">li\u00ean k\u1ebft sheet trong excel<\/a> b\u1eb1ng h\u00e0m Hyperlink<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chen_Hyperlink_vao_danh_muc_noi_dung\"><\/span><strong>Ch\u00e8n Hyperlink v\u00e0o danh m\u1ee5c n\u1ed9i dung<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ea7u ti\u00ean \u0111\u1ec3 t\u1ea1o <strong>Hyperlink <\/strong>l\u00e0 s\u1eed d\u1ee5ng l\u1ec7nh <strong>Hyperlink<\/strong>.<\/p>\n<ol>\n<li>Ch\u1ecdn m\u1ed9t \u00f4 t\u00ednh b\u1ea1n mu\u1ed1n ch\u00e8n hyperlink.<\/li>\n<li>Nh\u1ea5p ph\u1ea3i v\u00e0o \u00f4 t\u00ednh v\u00e0 ch\u1ecdn <strong><em>Hyperlink <\/em><\/strong>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/hyperlink-option.png\" alt=\"Click on Hyperlink in the context menu to open the Insert Hyperlink dialog box\" title=\"hyperlink-option\"><\/p>\n<p>H\u1ed9p tho\u1ea1i <strong><em>Insert<\/em><\/strong> <strong><em>Hyperlink <\/em><\/strong>xu\u1ea5t hi\u1ec7n tr\u00ean m\u00e0n h\u00ecnh.<\/p>\n<ol start=\"3\">\n<li>Ch\u1ecdn <strong><em>Place in This Document <\/em><\/strong>trong ph\u1ea7n <strong><em>Link to <\/em><\/strong>n\u1ebfu b\u1ea1n mu\u1ed1n li\u00ean k\u1ebft c\u00e1c \u00f4 t\u00ednh t\u1edbi m\u1ed9t \u0111\u1ecba ch\u1ec9 c\u1ee5 th\u1ec3 trong b\u1ea3ng t\u00ednh.<\/li>\n<li>Ch\u1ecdn trang t\u00ednh b\u1ea1n mu\u1ed1n li\u00ean k\u1ebft trong ph\u1ea7n <strong><em>Or select a place in this document<\/em><\/strong><\/li>\n<li>Nh\u1eadp \u0111\u1ecba ch\u1ec9 \u00f4 t\u00ednh v\u00e0o h\u1ed9p <strong><em>Type the cell reference <\/em><\/strong>n\u1ebfu b\u1ea1n mu\u1ed1n li\u00ean k\u1ebft t\u1edbi m\u1ed9t \u00f4 c\u1ee5 th\u1ec3 \u1edf m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c.<\/li>\n<li>G\u00f5 gi\u00e1 tr\u1ecb ho\u1eb7c t\u00ean v\u00e0o h\u1ed9p <strong><em>Text to display <\/em><\/strong>\u0111\u1ea1i di\u1ec7n cho hyperlink trong \u00f4 t\u00ednh.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5636 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-21.png\" width=\"600\" height=\"312\" title=\"excel-dialog-box-launcher-1-21\"><\/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-22.gif\" title=\"vba101_92019-nho-22\"><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-74.gif\" title=\"ex101_92019-nho-74\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol start=\"7\">\n<li>Nh\u1ea5n OK.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cell-containing-hyperlink.png\" alt=\"Click OK to see a hyperlink in a cell\" title=\"cell-containing-hyperlink\"><\/p>\n<p>N\u1ed9i dung \u00f4 t\u00ednh s\u1ebd \u0111\u01b0\u1ee3c g\u1ea1ch ch\u00e2n v\u00e0 b\u00f4i m\u00e0u xanh, c\u00f3 ngh\u0129a l\u00e0 \u00f4 t\u00ednh \u0111ang ch\u1ee9a hyperlink. \u0110\u1ec3 ki\u1ec3m tra \u0111\u01b0\u1eddng link, tr\u1ecf con chu\u1ed9t v\u00e0o ph\u1ea7n v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c g\u1ea1ch ch\u00e2n v\u00e0 nh\u1ea5p v\u00e0o n\u00f3 \u0111\u1ec3 di chuy\u1ec3n \u0111\u1ebfn \u0111\u1ecba ch\u1ec9 c\u1ee5 th\u1ec3.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_HYPERLINK\"><\/span><strong>H\u00e0m HYPERLINK<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/use-excel-hyperlink-function-create-different-link-types.html\">H\u00e0m <strong>HYPERLINK <\/strong><\/a>\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o li\u00ean k\u1ebft gi\u1eefa nhi\u1ec1u trang t\u00ednh trong b\u1ea3ng t\u00ednh. N\u1ebfu b\u1ea1n kh\u00f4ng gi\u1ecfi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c, h\u00e3y thao t\u00e1c theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol>\n<li>Ch\u1ecdn \u00f4 t\u00ednh b\u1ea1n mu\u1ed1n ch\u00e8n hyperlink.<\/li>\n<li>Di chuy\u1ec3n \u0111\u1ebfn th\u1ebb <strong><em>FORMULAS &gt; Function Library<\/em><\/strong>.<\/li>\n<li>M\u1edf danh s\u00e1ch t\u00f9y ch\u1ecdn <strong><em>Lookup &amp; Reference <\/em><\/strong>v\u00e0 ch\u1ecdn <strong><em>HYPERLINK<\/em><\/strong>.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/hyperlink-function.png\" alt=\"Click on HYPERLINK in the Lookup &amp; Reference drop-down menu to start entering the formula\" title=\"hyperlink-function\"><\/p>\n<p>T\u00ean h\u00e0m <strong>HYPERLINK <\/strong>xu\u1ea5t hi\u1ec7n trong thanh c\u00f4ng th\u1ee9c, b\u1ea1n ch\u1ec9 c\u1ea7n g\u00f5 v\u00e0o hai gi\u00e1 tr\u1ecb tham s\u1ed1 trong h\u1ed9p tho\u1ea1i m\u1edf ra: <strong><em>link_location <\/em><\/strong>v\u00e0<strong><em> friendly_name.<\/em><\/strong><\/p>\n<p><strong><em>link_location: <\/em><\/strong>\u0111\u1ecba ch\u1ec9 \u00f4 t\u00ednh c\u1ee5 th\u1ec3 trong Excel<\/p>\n<p><strong><em>friendly_name: <\/em><\/strong>n\u1ed9i dung hi\u1ec3n th\u1ecb trong \u00f4 t\u00ednh \u0111\u00f3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5637 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-22.png\" width=\"600\" height=\"507\" title=\"excel-dialog-box-launcher-1-22\"><\/p>\n<ol start=\"4\">\n<li>\u0110i\u1ec1n v\u00e0p <strong><em>Link_location<\/em><\/strong>.<\/li>\n<\/ol>\n<p><strong>Ch\u00fa \u00fd. <\/strong>N\u1ebfu b\u1ea1n kh\u00f4ng bi\u1ebft \u0111\u1ecba ch\u1ec9 c\u1ea7n nh\u1eadp, s\u1eed d\u1ee5ng bi\u1ec3u t\u01b0\u1ee3ng <strong><em>Select range <\/em><\/strong>\u0111\u1ec3 th\u00eam \u0111\u1ecba ch\u1ec9 \u00f4 \u0111\u1ebfn.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-link-location.png\" alt=\"Click on the Select range icon to pick the destination cell\" title=\"select-link-location\"><\/p>\n<p>\u0110\u1ecba ch\u1ec9 th\u1ec3 hi\u1ec7n trong <strong>Link_location\u00a0<\/strong>trong h\u1ed9p tho\u1ea1i sau:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/link-location-address.png\" alt=\"Click Enter or the Select range icon again to display the address in the Link_location text box\" title=\"link-location-address\"><\/p>\n<ol start=\"5\">\n<li>Th\u00eam v\u00e0o k\u00fd hi\u1ec7u <strong><em># <\/em><\/strong>tr\u01b0\u1edbc \u0111\u1ecba ch\u1ec9 c\u1ee5 th\u1ec3.<\/li>\n<\/ol>\n<p><strong>Ch\u00fa \u00fd. <\/strong>B\u01b0\u1edbc n\u00e0y r\u1ea5t c\u1ea7n thi\u1ebft, nh\u1eb1m bi\u1ec3u th\u1ecb v\u1ecb tr\u00ed \u00f4 t\u00ednh n\u1eb1m trong b\u1ea3ng t\u00ednh \u0111ang l\u00e0m vi\u1ec7c. N\u1ebfu b\u1ea1n qu\u00ean them k\u00fd hi\u1ec7u n\u00e0y, \u0111\u01b0\u1eddng li\u00ean k\u1ebft s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng v\u00e0 xu\u1ea5t hi\u1ec7n l\u1ed7i khi b\u1ea1n nh\u1ea5p v\u00e0o n\u00f3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5638 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-23.png\" width=\"600\" height=\"532\" title=\"excel-dialog-box-launcher-1-23\"><\/p>\n<p>Khi b\u1ea1n di t\u1edbi h\u1ed9p <strong><em>Friendly_name<\/em><\/strong>, b\u1ea1n s\u1ebd th\u1ea5y k\u1ebft qu\u1ea3 c\u00f4ng th\u1ee9c n\u1eb1m \u1edf g\u00f3c tr\u00e1i b\u00ean d\u01b0\u1edbi c\u1ee7a h\u1ed9p tho\u1ea1i <strong><em>Function Arguments<\/em><\/strong>.<\/p>\n<ol start=\"6\">\n<li>G\u00f5 n\u1ed9i dung b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb trong \u00f4 t\u00ednh v\u00e0o h\u1ed9p <strong><em>Friendly_name<\/em><\/strong>.<\/li>\n<li>Nh\u1ea5n OK.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/hyperlink-formula.png\" alt=\"Click OK to insert a hyperlink into a cell and to see the hyperlink formula in the formula bar\" title=\"hyperlink-formula\"><\/p>\n<blockquote>\n<p>Xem ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">c\u00e1c h\u00e0m th\u00f4ng d\u1ee5ng trong excel<\/a><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Chen_lien_ket_bang_cach_keo_va_tha_o_tinh\"><\/span><strong>Ch\u00e8n li\u00ean k\u1ebft b\u1eb1ng c\u00e1ch k\u00e9o v\u00e0 th\u1ea3 \u00f4 t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u00ed d\u1ee5 t\u00f4i c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh g\u1ed3m hai trang t\u00ednh v\u00e0 t\u00f4i mu\u1ed1n t\u1ea1o li\u00ean k\u1ebft gi\u1eefa Sheet 1 v\u00e0 m\u1ed9t \u00f4 trong Sheet 2.<\/p>\n<p><strong>Ch\u00fa \u00fd<\/strong><em>. <\/em>\u0110\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n \u0111\u00e3 \u0111\u01b0\u1ee3c sao l\u01b0u v\u00ec ph\u01b0\u01a1ng ph\u00e1p n\u00e0y kh\u00f4ng \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c \u0111\u1ed1i v\u1edbi b\u1ea3ng t\u00ednh m\u1edbi.<\/p>\n<ol>\n<li>Ch\u1ecdn \u00f4 b\u1ea1n mu\u1ed1n d\u1eabn link t\u1edbi trong Sheet 2.<\/li>\n<li>Ch\u1ec9 v\u00e0o m\u1ed9t trong nh\u1eefng \u0111\u01b0\u1eddng vi\u1ec1n \u00f4 t\u00ednh v\u00e0 nh\u1ea5p ph\u1ea3i.<\/li>\n<li>Nh\u1ea5n gi\u1eef v\u00e0 di chuy\u1ec3n xu\u1ed1ng c\u00e1c th\u1ebb Sheet.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5639 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-24.png\" width=\"600\" height=\"483\" title=\"excel-dialog-box-launcher-1-24\"><\/p>\n<ol start=\"4\">\n<li>Nh\u1ea5n <strong><em>Alt <\/em><\/strong>v\u00e0 di chuy\u1ec3n chu\u1ed9t sang th\u1ebb Sheet 1. Ph\u00edm <strong><em>Alt <\/em><\/strong>s\u1ebd cho ph\u00e9p b\u1ea1n di chuy\u1ec3n qua m\u1ed9t trang t\u00ednh kh\u00e1c. M\u1ed9t khi Sheet 1 \u0111\u01b0\u1ee3c m\u1edf ra, b\u1ea1n kh\u00f4ng c\u1ea7n nh\u1ea5n gi\u1eef ph\u00edm n\u00e0y n\u1eefa.<\/li>\n<li>Ti\u1ebfp t\u1ee5c k\u00e9o \u00f4 t\u00ednh \u0111\u1ebfn n\u01a1i b\u1ea1n mu\u1ed1n ch\u00e8n hyperlink.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/switch-to-another-sheet.png\" alt=\"Have the Alt key pressed to switch to the other sheet\" title=\"switch-to-another-sheet\"><\/p>\n<ol start=\"6\">\n<li>Th\u1ea3 chu\u1ed9t ph\u1ea3i. Danh s\u00e1ch t\u00f9y ch\u1ecdn xu\u1ea5t hi\u1ec7n.<\/li>\n<li>Ch\u1ecdn <strong><em>Create Hyperlink Here<\/em><\/strong> t\u1eeb danh s\u00e1ch.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/create-hyperlink-here.png\" alt=\"Release the right mouse button and choose Create Hyperlink Here from the popup menu\" title=\"create-hyperlink-here\"><\/p>\n<p>Sau thao t\u00e1c n\u00e0y, Hyperlink s\u1ebd xu\u1ea5t hi\u1ec7n trong \u00f4 t\u00ednh. Khi b\u1ea1n nh\u1ea5p v\u00e0o n\u00f3, b\u1ea1n s\u1ebd di chuy\u1ec3n t\u1edbi \u00f4 t\u00ednh trong Sheet 2.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Sua_mot_Hyperlink\"><\/span><strong>S\u1eeda m\u1ed9t Hyperlink<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea1n c\u00f3 th\u1ec3 s\u1eeda \u0111\u1ed5i hyperlink hi\u1ec7n t\u1ea1i trong b\u1ea3ng t\u00ednh b\u1eb1ng c\u00e1ch thay \u0111\u1ed5i \u0111\u1ecba \u0111i\u1ec3m \u0111\u1ebfn c\u1ee7a n\u00f3, giao di\u1ec7n c\u1ee7a n\u00f3 ho\u1eb7c n\u1ed9i dung \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 bi\u1ec3u th\u1ecb cho n\u00f3.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thay_doi_dia_diem_den_cua_Hyperlink\"><\/span><strong>Thay \u0111\u1ed5i \u0111\u1ecba \u0111i\u1ec3m \u0111\u1ebfn c\u1ee7a Hyperlink<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>Nh\u1ea5p ph\u1ea3i v\u00e0o hyperlink b\u1ea1n mu\u1ed1n ch\u1ec9nh s\u1eeda.<\/li>\n<li>Ch\u1ecdn <strong><em>Edit Hyperlink<\/em><\/strong> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/edit-hyperlink.png\" alt=\"Right-click and choose Edit Hyperlink to open the Edit Hyperlink dialog box\" title=\"edit-hyperlink\"><\/p>\n<p>H\u1ed9p tho\u1ea1i <strong><em>Edit Hyperlink<\/em><\/strong> xu\u1ea5t hi\u1ec7n. B\u1ea1n s\u1ebd th\u1ea5y n\u00f3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u1ed9p tho\u1ea1i <strong><em>Insert Hyperlink<\/em><\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5640 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-25.png\" width=\"600\" height=\"312\" title=\"excel-dialog-box-launcher-1-25\"><\/p>\n<p><strong>Ch\u00fa \u00fd. <\/strong>C\u00f3 hai c\u00e1ch \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong><em>Edit Hyperlink<\/em><\/strong>. B\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n <strong><em>Ctrl + K <\/em><\/strong>ho\u1eb7c di chuy\u1ec3n \u0111\u1ebfn th\u1ebb <strong><em>INSERT &gt; <\/em><\/strong>nh\u1ea5p ch\u1ecdn <strong><em>Hyperlink <\/em><\/strong>trong nh\u00f3m <strong><em>Links. <\/em><\/strong>\u0110\u1eebng qu\u00ean ch\u1ecdn \u00f4 t\u00ednh c\u1ea7n ch\u1ec9nh s\u1eeda tr\u01b0\u1edbng khi m\u1edf h\u1ed9p tho\u1ea1i n\u00e0y.<\/p>\n<ol start=\"3\">\n<li>C\u1eadp nh\u1eadt th\u00f4ng tin trong v\u00f9ng ph\u00f9 h\u1ee3p c\u1ee7a h\u1ed9p tho\u1ea1i <strong><em>Edit Hyperlink<\/em><\/strong>.<\/li>\n<li>Nh\u1ea5n OK v\u00e0 ki\u1ec3m tra hyperlink.<\/li>\n<\/ol>\n<p><strong>Ch\u00fa \u00fd<\/strong><em>. <\/em>Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p 2 \u0111\u1ec3 ch\u00e8n hyperlink trong Excel, b\u1ea1n c\u1ea7n ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c \u0111\u1ec3 thay \u0111\u1ed5i \u0111i\u1ec3m \u0111\u1ebfn c\u1ee7a hyperlink. Ch\u1ecdn \u00f4 t\u00ednh ch\u1ee9a \u0111\u01b0\u1eddng li\u00ean k\u1ebft, ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c trong thanh c\u00f4ng th\u1ee9c.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Sua_doi_dinh_dang_hyperlink\"><\/span><strong>S\u1eeda \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng hyperlink<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u1ea7u h\u1ebft c\u00e1c hyperlink li\u00ean k\u1ebft th\u1eddi gian hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c g\u1ea1ch ch\u00e2n m\u00e0u xanh lam. N\u1ebfu s\u1ef1 xu\u1ea5t hi\u1ec7n \u0111i\u1ec3n h\u00ecnh n\u00e0y khi\u1ebfn b\u1ea1n nh\u00e0m ch\u00e1n, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i m\u1eb7c \u0111\u1ecbnh theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<ol>\n<li>Di chuy\u1ec3n t\u1edbi nh\u00f3m <strong><em>Styles<\/em><\/strong> trong th\u1ebb <strong><em>HOME<\/em><\/strong>.<\/li>\n<li>M\u1edf danh s\u00e1ch <strong><em>Cell Styles<\/em><\/strong>.<\/li>\n<li>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o <strong><em>Hyperlink<\/em><\/strong> \u0111\u1ec3 thay \u0111\u1ed5i giao di\u1ec7n c\u1ee7a li\u00ean k\u1ebft ch\u01b0a \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t, ho\u1eb7c b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o <strong><em>Followed Hyperlink <\/em><\/strong>n\u1ebfu si\u00eau li\u00ean k\u1ebft \u0111\u00e3 \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t.<\/li>\n<li>Ch\u1ecdn <strong><em>Modify\u2026<\/em><\/strong> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/modify-hyperlink-format.png\" alt=\"Right-click on Hyperlink or Followed Hyperlink and choose Modify to open the Styles dialog box\" title=\"modify-hyperlink-format\"><\/p>\n<ol start=\"5\">\n<li>Nh\u1ea5p v\u00e0o <strong><em>Format<\/em><\/strong> trong h\u1ed9p tho\u1ea1i <strong><em>Styles<\/em><\/strong>.<\/li>\n<li>Thi\u1ebft l\u1eadp thay \u0111\u1ed5i c\u1ea7n thi\u1ebft trong h\u1ed9p tho\u1ea1i <strong><em>Format Cells<\/em><\/strong>. T\u1ea1i \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i c\u0103n l\u1ec1, font ch\u1eef ho\u1eb7c m\u00e0u c\u1ee7a hyperlink.<\/li>\n<li>Nh\u1ea5n OK.<\/li>\n<li>\u0110\u1ea3m b\u1ea3o r\u1eb1ng t\u1ea5t c\u1ea3 thay \u0111\u1ed5i \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u ch\u1ecdn trong ph\u1ea7n <strong><em>Style includes<\/em><\/strong> c\u1ee7a h\u1ed9p tho\u1ea1i <strong><em>Style<\/em><\/strong>.<\/li>\n<li>Nh\u1ea5n OK.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-hyperlink-style.png\" alt=\"Make the changes in the Format Cells dialog window and have them marked in the Style dialog box\" title=\"change-hyperlink-style\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Loai_bo_Hyperlink\"><\/span><strong>Lo\u1ea1i b\u1ecf Hyperlink<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<li>Nh\u1ea5p ph\u1ea3i v\u00e0o hyperlink b\u1ea1n mu\u1ed1n x\u00f3a b\u1ecf.<\/li>\n<li>Ch\u1ecdn <strong><em>Remove Hyperlink <\/em><\/strong>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-hyperlink.png\" alt=\"Right-click on the cell and choose Remove Hyperlink to delete the hyperlink from the worksheet\" title=\"remove-hyperlink\"><\/p>\n<p>N\u1ed9i dung trong \u00f4 t\u00ednh \u0111\u01b0\u1ee3c gi\u1eef l\u1ea1i nh\u01b0ng n\u00f3 kh\u00f4ng \u1edf d\u1ea1ng hyperlink n\u1eefa.<\/p>\n<p><strong>Ch\u00fa \u00fd. <\/strong>N\u1ebfu b\u1ea1n mu\u1ed1n x\u00f3a m\u1ed9t hyperlink v\u00e0 n\u1ed9i dung \u0111\u1ea1i di\u1ec7n cho n\u00f3, nh\u1ea5p ph\u1ea3i v\u00e0o \u00f4 t\u00ednh ch\u1ee9a \u0111\u01b0\u1eddng li\u00ean k\u1ebft v\u00e0 ch\u1ecdn <strong><em>Clear Contents <\/em><\/strong>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/p>\n<p><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/em><\/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-22.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1069,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1068","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\/1068","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=1068"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1068\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1069"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}