{"id":12042,"date":"2025-01-15T06:48:23","date_gmt":"2025-01-15T06:48:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-hyperlink-trong-excel\/"},"modified":"2025-01-15T06:48:23","modified_gmt":"2025-01-15T06:48:23","slug":"cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-hyperlink-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-hyperlink-trong-excel\/","title":{"rendered":"C\u00e1ch t\u1ea1o m\u1edbi, ch\u1ec9nh s\u1eeda v\u00e0 x\u00f3a b\u1ecf c\u00e1c lo\u1ea1i li\u00ean k\u1ebft Hyperlink trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>V\u1edbi b\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng li\u00ean k\u1ebft trong Excel theo 3 c\u00e1ch kh\u00e1c nhau. B\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u1ecdc c\u00e1ch ch\u00e8n li\u00ean k\u1ebft, thay \u0111\u1ed5i v\u00e0 x\u00f3a b\u1ecf li\u00ean k\u1ebft c\u0169ng nh\u01b0 kh\u1eafc ph\u1ee5c nh\u1eefng li\u00ean k\u1ebft l\u1ed7i trong b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh.<\/em><\/p>\n<p style=\"text-align: justify\">C\u00e1c li\u00ean k\u1ebft \u0111\u01b0\u1ee3c ch\u00e8n\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i tr\u00ean Internet \u0111\u1ec3 \u0111i\u1ec1u h\u01b0\u1edbng gi\u1eefa c\u00e1c trang web. Trong b\u1ea3ng t\u00ednh Excel c\u1ee7a m\u00ecnh, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u1ea1o l\u1eadp nh\u1eefng li\u00ean k\u1ebft nh\u01b0 v\u1eady. Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ch\u00e8n th\u00eam c\u00e1c li\u00ean k\u1ebft t\u1edbi m\u1ed9t c\u1ed9t, m\u1ed9t trang t\u00ednh ho\u1eb7c m\u1ed9t t\u1ec7p tin Excel \u0111\u1ec3 m\u1edf t\u1ec7p ho\u1eb7c vi\u1ebft email. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch th\u1ef1c hi\u1ec7n m\u1ed9t c\u00e1ch chi ti\u1ebft \u0111\u1ed1i v\u1edbi c\u00e1c phi\u00ean b\u1ea3n Excel 2016, 2013, 2010 v\u00e0 c\u1ea3 nh\u1eefng phi\u00ean b\u1ea3n tr\u01b0\u1edbc \u0111\u00f3 n\u1eefa.<\/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-67875a336b0cc\" 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-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Lien_ket_duoc_chen_trong_Excel_la_gi\" title=\"Li\u00ean k\u1ebft \u0111\u01b0\u1ee3c ch\u00e8n trong Excel l\u00e0 g\u00ec\u00a0\">Li\u00ean k\u1ebft \u0111\u01b0\u1ee3c ch\u00e8n trong Excel l\u00e0 g\u00ec\u00a0<\/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\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Cac_lien_ket_tuong_doi_va_lien_ket_tuyet_doi\" title=\"C\u00e1c li\u00ean k\u1ebft t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 li\u00ean k\u1ebft tuy\u1ec7t \u0111\u1ed1i\">C\u00e1c li\u00ean k\u1ebft t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 li\u00ean k\u1ebft tuy\u1ec7t \u0111\u1ed1i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Cach_chen_lien_ket_trong_Excel\" title=\"C\u00e1ch ch\u00e8n li\u00ean k\u1ebft trong Excel\">C\u00e1ch ch\u00e8n li\u00ean k\u1ebft trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Tao_lien_ket_toi_mot_van_ban_khac\" title=\"T\u1ea1o li\u00ean k\u1ebft t\u1edbi m\u1ed9t v\u0103n b\u1ea3n kh\u00e1c\">T\u1ea1o li\u00ean k\u1ebft t\u1edbi m\u1ed9t v\u0103n b\u1ea3n kh\u00e1c<\/a><\/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-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Chen_lien_ket_toi_trang_web_URL\" title=\"Ch\u00e8n li\u00ean k\u1ebft t\u1edbi trang web (URL)\">Ch\u00e8n li\u00ean k\u1ebft t\u1edbi trang web (URL)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Tao_lien_ket_toi_mot_trang_tinh_hoac_mot_o_tinh_trong_Bang_tinh_dang_hoat_dong\" title=\"T\u1ea1o li\u00ean k\u1ebft t\u1edbi m\u1ed9t trang t\u00ednh ho\u1eb7c m\u1ed9t \u00f4 t\u00ednh trong B\u1ea3ng t\u00ednh \u0111ang ho\u1ea1t \u0111\u1ed9ng\">T\u1ea1o li\u00ean k\u1ebft t\u1edbi m\u1ed9t trang t\u00ednh ho\u1eb7c m\u1ed9t \u00f4 t\u00ednh trong B\u1ea3ng t\u00ednh \u0111ang ho\u1ea1t \u0111\u1ed9ng<\/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-7\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Tao_lien_ket_de_mo_mot_bang_tinh_Excel_moi\" title=\"T\u1ea1o li\u00ean k\u1ebft \u0111\u1ec3 m\u1edf m\u1ed9t b\u1ea3ng t\u00ednh Excel m\u1edbi.\">T\u1ea1o li\u00ean k\u1ebft \u0111\u1ec3 m\u1edf m\u1ed9t b\u1ea3ng t\u00ednh Excel m\u1edbi.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Tao_lien_ket_toi_dia_chi_email\" title=\"T\u1ea1o li\u00ean k\u1ebft t\u1edbi \u0111\u1ecba ch\u1ec9 email\">T\u1ea1o li\u00ean k\u1ebft t\u1edbi \u0111\u1ecba ch\u1ec9 email<\/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-9\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Cach_tao_lien_ket_bang_ham_HYPERLINK\" title=\"C\u00e1ch t\u1ea1o li\u00ean k\u1ebft b\u1eb1ng h\u00e0m HYPERLINK\">C\u00e1ch t\u1ea1o li\u00ean k\u1ebft b\u1eb1ng h\u00e0m HYPERLINK<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Tao_lien_ket_bang_ma_VBA\" title=\"T\u1ea1o li\u00ean k\u1ebft\u00a0b\u1eb1ng m\u00e3 VBA\">T\u1ea1o li\u00ean k\u1ebft\u00a0b\u1eb1ng m\u00e3 VBA<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Cach_chinh_sua_lien_ket_trong_Excel\" title=\"C\u00e1ch ch\u1ec9nh s\u1eeda li\u00ean k\u1ebft trong Excel\">C\u00e1ch ch\u1ec9nh s\u1eeda li\u00ean k\u1ebft trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Cach_thay_doi_dinh_dang_lien_ket_duoc_chen\" title=\"C\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng li\u00ean k\u1ebft \u0111\u01b0\u1ee3c ch\u00e8n\">C\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng li\u00ean k\u1ebft \u0111\u01b0\u1ee3c ch\u00e8n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Cach_xoa_lien_ket_da_duoc_chen_trong_Excel\" title=\"C\u00e1ch x\u00f3a li\u00ean k\u1ebft \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u00e8n trong Excel\">C\u00e1ch x\u00f3a li\u00ean k\u1ebft \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u00e8n trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Loi_khuyen_su_dung_lien_ket_trong_Excel\" title=\"L\u1eddi khuy\u00ean s\u1eed d\u1ee5ng li\u00ean k\u1ebft trong Excel\">L\u1eddi khuy\u00ean s\u1eed d\u1ee5ng li\u00ean k\u1ebft 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-15\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Cach_de_chon_o_co_chua_lien_ket\" title=\"C\u00e1ch \u0111\u1ec3 ch\u1ecdn \u00f4 c\u00f3 ch\u1ee9a li\u00ean k\u1ebft \">C\u00e1ch \u0111\u1ec3 ch\u1ecdn \u00f4 c\u00f3 ch\u1ee9a li\u00ean k\u1ebft <\/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-16\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Cach_thuc_de_trich_xuat_mot_dia_chi_web_tu_lien_ket_trong_Excel\" title=\"C\u00e1ch th\u1ee9c \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t \u0111\u1ecba ch\u1ec9 web t\u1eeb li\u00ean k\u1ebft trong Excel\">C\u00e1ch th\u1ee9c \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t \u0111\u1ecba ch\u1ec9 web t\u1eeb li\u00ean k\u1ebft trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Trich_xuat_dia_chi_web_thu_cong_tu_lien_ket\" title=\"Tr\u00edch xu\u1ea5t \u0111\u1ecba ch\u1ec9 web th\u1ee7 c\u00f4ng t\u1eeb li\u00ean k\u1ebft\">Tr\u00edch xu\u1ea5t \u0111\u1ecba ch\u1ec9 web th\u1ee7 c\u00f4ng t\u1eeb li\u00ean k\u1ebft<\/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-18\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Trich_xuat_nhieu_dia_chi_lien_ket_bang_ma_VBA\" title=\"Tr\u00edch xu\u1ea5t nhi\u1ec1u \u0111\u1ecba ch\u1ec9 li\u00ean k\u1ebft b\u1eb1ng m\u00e3 VBA\">Tr\u00edch xu\u1ea5t nhi\u1ec1u \u0111\u1ecba ch\u1ec9 li\u00ean k\u1ebft b\u1eb1ng m\u00e3 VBA<\/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-19\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Lien_ket_trong_Excel_bi_loi_cac_nguyen_nhan_va_cach_khac_phuc\" title=\"Li\u00ean k\u1ebft trong Excel b\u1ecb l\u1ed7i, c\u00e1c nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c\">Li\u00ean k\u1ebft trong Excel b\u1ecb l\u1ed7i, c\u00e1c nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/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-20\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Tham_chieu_khong_hop_le_Reference_isnt_valid\" title=\"Tham chi\u1ebfu kh\u00f4ng h\u1ee3p l\u1ec7 (Reference isn\u2019t valid) \">Tham chi\u1ebfu kh\u00f4ng h\u1ee3p l\u1ec7 (Reference isn\u2019t valid) <\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Lien_ket_xuat_hien_duoi_dang_van_ban_thuan_tuy\" title=\"Li\u00ean k\u1ebft xu\u1ea5t hi\u1ec7n d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n thu\u1ea7n t\u00fay\">Li\u00ean k\u1ebft xu\u1ea5t hi\u1ec7n d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n thu\u1ea7n t\u00fay<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Lien_ket_khong_hoat_dong_khi_mo_lai_bang_tinh\" title=\"Li\u00ean k\u1ebft kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng khi m\u1edf l\u1ea1i b\u1ea3ng t\u00ednh\">Li\u00ean k\u1ebft kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng khi m\u1edf l\u1ea1i b\u1ea3ng 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-23\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-moi-chinh-sua-va-xoa-bo-cac-loai-lien-ket-trong-excel.html#Cac_lien_ket_duoc_tao_boi_ham_HYPERLINK_khong_hoat_dong\" title=\"C\u00e1c li\u00ean k\u1ebft \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi h\u00e0m HYPERLINK kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng\">C\u00e1c li\u00ean k\u1ebft \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi h\u00e0m HYPERLINK kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lien_ket_duoc_chen_trong_Excel_la_gi\"><\/span><strong>Li\u00ean k\u1ebft \u0111\u01b0\u1ee3c ch\u00e8n trong Excel l\u00e0 g\u00ec\u00a0<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Li\u00ean k\u1ebft \u0111\u01b0\u1ee3c ch\u00e8n\u00a0trong excel s\u1ebd gi\u00fap ng\u01b0\u1eddi d\u00f9ng di chuy\u1ec3n \u0111\u1ebfn \u00a0m\u1ed9t v\u1ecb tr\u00ed c\u1ee5 th\u1ec3, t\u00e0i li\u1ec7u ho\u1eb7c trang web \u0111\u01b0\u1ee3c tham chi\u1ebfu ch\u1ec9 b\u1eb1ng m\u1ed9t c\u00fa k\u00edch chu\u1ed9t.<\/p>\n<p style=\"text-align: justify\">Excel cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u1ea1o c\u00e1c li\u00ean k\u1ebft cho nhi\u1ec1u m\u1ee5c \u0111\u00edch kh\u00e1c nhau nh\u01b0:<\/p>\n<ul style=\"text-align: justify\">\n<li>Di chuy\u1ec3n t\u1edbi m\u1ed9t v\u1ecb tr\u00ed c\u1ee5 th\u1ec3 trong b\u1ea3ng t\u00ednh\u00a0\u0111ang s\u1eed d\u1ee5ng<\/li>\n<li>M\u1edf m\u1ed9t v\u0103n b\u1ea3n ho\u1eb7c \u0111i t\u1edbi m\u1ed9t v\u1ecb tr\u00ed x\u00e1c \u0111\u1ecbnh trong v\u0103n b\u1ea3n \u0111\u00f3, v\u00ed d\u1ee5 nh\u01b0: m\u1ed9t b\u1ea3ng t\u00ednh c\u1ee7a m\u1ed9t\u00a0th\u01b0 m\u1ee5c Excel hay m\u1ed9t trang \u0111\u00e1nh d\u1ea5u trong v\u0103n b\u1ea3n Word.<\/li>\n<li>\u0110i\u1ec1u h\u01b0\u1edbng t\u1edbi m\u1ed9t trang web tr\u00ean m\u1ea1ng Internet ho\u1eb7c m\u1ea1ng n\u1ed9i b\u1ed9<\/li>\n<li>T\u1ea1o l\u1eadp m\u1ed9t t\u1ec7p Excel\u00a0m\u1edbi<\/li>\n<li>G\u1eedi email t\u1edbi \u0111\u1ecba ch\u1ec9\u00a0email ch\u1ec9 \u0111\u1ecbnh<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Li\u00ean k\u1ebft\u00a0trong Excel r\u1ea5t d\u1ec5 nh\u1eadn di\u1ec7n \u2013 th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng m\u00e0u ch\u1eef xanh, c\u00f3 g\u1ea1ch ch\u00e2n nh\u01b0 trong minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/hyperlinks-excel.png\" alt=\"Hyperlinks in Excel\" title=\"hyperlinks-excel\"><\/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<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\/2025\/01\/vba101_92019-nho-71.gif\" title=\"vba101_92019-nho-71\"><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\/2025\/01\/ex101_92019-nho-345.gif\" title=\"ex101_92019-nho-345\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cac_lien_ket_tuong_doi_va_lien_ket_tuyet_doi\"><\/span><strong>C\u00e1c li\u00ean k\u1ebft t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 li\u00ean k\u1ebft tuy\u1ec7t \u0111\u1ed1i<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Microsoft Excel h\u1ed7 tr\u1ee3 hay \u0111\u01b0\u1eddng li\u00ean k\u1ebft: t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 tuy\u1ec7t \u0111\u1ed1i,\u00a0t\u00f9y thu\u1ed9c v\u00e0o b\u1ea1n ch\u1ec9 \u0111\u1ecbnh t\u1edbi m\u1ed9t \u0111\u1ecba ch\u1ec9 \u0111\u1ea7y \u0111\u1ee7 hay ch\u1ec9 m\u1ed9t ph\u1ea7n.<\/p>\n<p style=\"text-align: justify\">M\u1ed9t <strong>li\u00ean k\u1ebft\u00a0t\u01b0\u01a1ng \u0111\u1ed1i<\/strong> ch\u1ee9a\u00a0m\u1ed9t \u0111\u1ecba ch\u1ec9 \u0111\u1ea7y \u0111\u1ee7, bao g\u1ed3m c\u1ea3 giao th\u1ee9c v\u00e0 t\u00ean mi\u1ec1n cho URLs, v\u00e0 to\u00e0n b\u1ed9 \u0111\u01b0\u1eddng d\u1eabn v\u00e0 t\u00ean t\u1eadp tin cho t\u00e0i li\u1ec7u \u0111\u00f3. V\u00ed d\u1ee5 nh\u01b0:<\/p>\n<p style=\"text-align: justify\">URL tuy\u1ec7t \u0111\u1ed1i:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/blog.hocexcel.online<\/a><\/p>\n<p style=\"text-align: justify\">\u0110\u01b0\u1eddng d\u1eabn tuy\u1ec7t \u0111\u1ed1i trong Excel: <code>C:Excel filesSource DataBook1.xlsx<\/code><\/p>\n<p style=\"text-align: justify\">M\u1ed9t <strong>li\u00ean k\u1ebft<\/strong><strong>\u00a0t\u01b0\u01a1ng \u0111\u1ed1i<\/strong> ch\u1ec9 bao g\u1ed3m m\u1ed9t ph\u1ea7n \u0111\u1ecba ch\u1ec9. V\u00ed d\u1ee5 nh\u01b0:<\/p>\n<p style=\"text-align: justify\">URL t\u01b0\u01a1ng \u0111\u1ed1i: <code>excel-lookup-tables\/index.php<\/code><\/p>\n<p style=\"text-align: justify\">\u0110\u01b0\u1eddng d\u1eabn t\u01b0\u01a1ng\u00a0\u0111\u1ed1i trong Excel: <code>Source dataBook3.xlsx<\/code><\/p>\n<p style=\"text-align: justify\">Tr\u00ean m\u1ed7i trang web th\u01b0\u1eddng s\u1eed d\u1ee5ng \u0111\u01b0\u1eddng d\u1eabn URLs t\u01b0\u01a1ng \u0111\u1ed1i. Trong li\u00ean k\u1ebft\u00a0c\u1ee7a Excel, b\u1ea1n n\u00ean s\u1eed d\u1ee5ng \u0111\u01b0\u1eddng li\u00ean k\u1ebft URLs \u0111\u1ea7y \u0111\u1ee7 cho m\u1ed7i trang web. Nh\u1edd v\u1eady,\u00a0Microsoft Excel c\u00f3 th\u1ec3 \u0111\u1ecdc \u0111\u01b0\u1eddng d\u1eabn \u0111\u00f3 m\u00e0 kh\u00f4ng c\u1ea7n \u0111\u1ebfn giao th\u1ee9c. V\u00ed d\u1ee5 nh\u01b0, n\u1ebfu b\u1ea1n g\u00f5\u00a0\u201cwww.blog.hocexcel.online\u201d trong m\u1ed9t c\u1ed9t, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng th\u00eam\u00a0giao th\u1ee9c m\u1eb7c \u0111\u1ecbnh \u201chttp\u201d v\u00e0 chuy\u1ec3n h\u00f3a ch\u00fang th\u00e0nh \u0111\u01b0\u1eddng li\u00ean k\u1ebft hyperlink \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i.<\/p>\n<p style=\"text-align: justify\">Khi t\u1ea1o l\u1eadp \u0111\u01b0\u1eddng d\u1eabn li\u00ean k\u1ebft t\u1edbi c\u00e1c th\u01b0 m\u1ee5c\u00a0Excel hay nh\u1eefng trang v\u0103n b\u1ea3n kh\u00e1c \u0111\u01b0\u1ee3c l\u01b0u tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ecba ch\u1ec9 t\u01b0\u01a1ng \u0111\u1ed1i ho\u1eb7c tuy\u1ec7t \u0111\u1ed1i. \u0110\u1ed1i v\u1edbi m\u1ed9t li\u00ean k\u1ebft\u00a0t\u01b0\u01a1ng \u0111\u1ed1i, ph\u1ea7n b\u1ecb khuy\u1ebft s\u1ebd mang t\u00ednh t\u01b0\u01a1ng \u0111\u1ed1i \u0111\u1ed1i v\u1edbi b\u1ea3ng t\u00ednh \u0111ang ho\u1ea1t \u0111\u1ed9ng. \u01afu \u0111i\u1ec3m ch\u00ednh c\u1ee7a ph\u01b0\u01a1ng ph\u00e1p n\u00e0y l\u00e0 b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i ch\u1ec9nh s\u1eeda l\u1ea1i \u0111\u1ecba ch\u1ec9 li\u00ean k\u1ebft khi\u00a0di chuy\u1ec3n th\u01b0 m\u1ee5c\u00a0sang m\u1ed9t \u0111\u1ecba ch\u1ec9 kh\u00e1c. V\u00ed d\u1ee5 nh\u01b0 n\u1ebfu b\u1ea3ng t\u00ednh \u0111ang ho\u1ea1t \u0111\u1ed9ng v\u00e0 d\u1ef1 ki\u1ebfn \u0111\u01b0\u1ee3c \u0111\u1eb7t \u1edf \u1ed5 C, sau \u0111\u00f3 b\u1ea1n chuy\u1ec3n ch\u00fang sang \u1ed5 D, li\u00ean k\u1ebft hyperlink t\u01b0\u01a1ng \u0111\u1ed1i s\u1ebd v\u1eabn ti\u1ebfp t\u1ee5c ho\u1ea1t \u0111\u1ed9ng mi\u1ec5n sao \u0111\u01b0\u1eddng d\u1eabn t\u01b0\u01a1ng \u0111\u1ed1i t\u1edbi th\u01b0 m\u1ee5c\u00a0m\u1ee5c ti\u00eau kh\u00f4ng thay \u0111\u1ed5i. Trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a li\u00ean k\u1ebft \u00a0t\u01b0\u01a1ng \u0111\u1ed1i, \u0111\u01b0\u1eddng d\u1eabn c\u1ea7n ph\u1ea3i \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt m\u1ed7i khi di chuy\u1ec3n th\u01b0 m\u1ee5c sang \u0111\u1ecba ch\u1ec9 kh\u00e1c.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_chen_lien_ket_trong_Excel\"><\/span><strong>C\u00e1ch ch\u00e8n li\u00ean k\u1ebft trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">S\u1eed d\u1ee5ng tr\u1ef1c ti\u1ebfp h\u1ed9p tho\u1ea1i\u00a0<strong>Insert Hyperlink\u00a0<\/strong>l\u00e0 c\u00e1ch ph\u1ed5 bi\u1ebfn nh\u1ea5t \u0111\u1ec3 ch\u00e8n m\u1ed9t li\u00ean k\u1ebft\u00a0v\u00e0o m\u1ed9t c\u1ed9t, c\u00f3 th\u1ec3 ti\u1ebfp c\u1eadn b\u1eb1ng ba c\u00e1ch kh\u00e1ch nhau. Ch\u1ecdn m\u1ed9t c\u1ed9t c\u1ea7n ch\u00e8n li\u00ean k\u1ebft v\u00e0 thao t\u00e1c theo m\u1ed9t trong nh\u1eefng b\u01b0\u1edbc sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>\u1ede thanh c\u00f4ng c\u1ee5\u00a0<em>Insert<\/em>, trong nh\u00f3m\u00a0<em>Links<\/em>, ch\u1ecdn\u00a0<strong>Hyperlink.<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-hyperlink-button.png\" alt=\"Insert a hyperlink in Excel by clicking the ribbon button.\" title=\"excel-hyperlink-button\"><\/p>\n<ul style=\"text-align: justify\">\n<li>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 c\u1ea7n ch\u00e8n li\u00ean k\u1ebft, ch\u1ecdn <strong>Hyperlink\u2026<\/strong> trong danh s\u00e1ch.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/hyperlink-context-menu.png\" alt=\"Create a hyperlink by using the right-click menu.\" title=\"hyperlink-context-menu\"><\/p>\n<ul style=\"text-align: justify\">\n<li>S\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Ctrl+K.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">T\u00f9y thu\u1ed9c v\u00e0o lo\u1ea1i li\u00ean k\u1ebft b\u1ea1n mu\u1ed1n ch\u00e8n, h\u00e3y c\u00f9ng thao t\u00e1c theo nh\u1eefng v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_lien_ket_toi_mot_van_ban_khac\"><\/span>T\u1ea1o li\u00ean k\u1ebft t\u1edbi m\u1ed9t v\u0103n b\u1ea3n kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 ch\u00e8n li\u00ean k\u1ebft t\u1edbi m\u1ed9t v\u0103n b\u1ea3n kh\u00e1c nh\u01b0 Excel, Word ho\u1eb7c PowerPoint, m\u1edf h\u1ed9p tho\u1ea1i <em>Insert Hyperlink<\/em> v\u00e0 th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>B\u00ean tr\u00e1i c\u1eeda s\u1ed5, ngay d\u01b0\u1edbi ph\u1ea7n <em>Link to<\/em>, nh\u1ea5p chu\u1ed9t v\u00e0o<strong> Existing File or Web Page<\/strong><\/li>\n<li>Trong danh s\u00e1ch <em>Look in<\/em>, nh\u1eadp \u0111\u1ecba ch\u1ec9 t\u1ec7p tin \u0111\u00edch sau \u0111\u00f3 ch\u1ecdn t\u1ec7p tin.<\/li>\n<li>Trong h\u1ed9p tho\u1ea1i <em>Text to display, nh\u1eadp n\u1ed9i dung mu\u1ed1n hi\u1ec3n th\u1ecb trong \u00f4 ( trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 \u201cBook 3\u201d)<\/em><\/li>\n<li>B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp n\u1ed9i dung hi\u1ec7n th\u1ecb khi di chu\u1ed9t t\u1edbi li\u00ean k\u1ebft n\u1ebfu mu\u1ed1n b\u1eb1ng n\u00fat <em>ScreenTip\u2026 ph\u00eda tr\u00ean b\u00ean ph\u1ea3i m\u00e0n h\u00ecnh. Trong v\u00ed d\u1ee5 n\u00e0y s\u1ebd l\u00e0 \u201c<\/em>Goto Book3 in My Documents\u201d<\/li>\n<li>Ch\u1ecdn OK.<\/li>\n<\/ol>\n<figure style=\"width: 602px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"1 - li\u00ean k\u1ebft Hyperlink trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/hyperlink-existing-file.png\" alt=\"1 - li\u00ean k\u1ebft Hyperlink trong Excel\" width=\"602\" height=\"341\"><figcaption class=\"wp-caption-text\">1 \u2013 li\u00ean k\u1ebft Hyperlink trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Li\u00ean k\u1ebft \u0111\u01b0\u1ee3c ch\u00e8n s\u1ebd hi\u1ec3n th\u1ecb nh\u01b0 sau:<\/p>\n<figure style=\"width: 258px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"2 - li\u00ean k\u1ebft Hyperlink trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/hyperlink-existing-file-created.png\" alt=\"2 - li\u00ean k\u1ebft Hyperlink trong Excel\" width=\"258\" height=\"62\"><figcaption class=\"wp-caption-text\">2 \u2013 li\u00ean k\u1ebft Hyperlink trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o li\u00ean k\u1ebft t\u1edbi m\u1ed9t trang t\u00ednh ho\u1eb7c m\u1ed9t \u00f4 c\u1ee5 th\u1ec3, nh\u1ea5p chu\u1ed9t v\u00e0o n\u00fat <strong>Bookmark\u2026 \u1edf ph\u00eda tr\u00ean b\u00ean ph\u1ea3i h\u1ed9p tho\u1ea1i <\/strong><em>Insert Hyperlink<\/em>, nh\u1eadp t\u00ean trang t\u00ednh v\u00e0 g\u00f5 \u0111\u1ecba ch\u1ec9 \u00f4 t\u00ednh v\u00e0o h\u1ed9p tho\u1ea1i <em>\u00a0Type in the cell reference<\/em>\u00a0, sau \u0111\u00f3 ch\u1ecdn OK:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/hyperlink-to-cell.png\" alt=\"Creating a hyperlink to a specific cell\" title=\"hyperlink-to-cell\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o li\u00ean k\u1ebft t\u1edbi m\u1ed9t t\u00ean mi\u1ec1n, ch\u1ecdn <em>Defined names nh\u01b0 h\u00ecnh d\u01b0\u1edbi:<\/em><\/p>\n<figure style=\"width: 391px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"3 - li\u00ean k\u1ebft Hyperlink trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/hyperlink-named-range.png\" alt=\"3 - li\u00ean k\u1ebft Hyperlink trong Excel\" width=\"391\" height=\"401\"><figcaption class=\"wp-caption-text\">3 \u2013 li\u00ean k\u1ebft Hyperlink trong Excel<\/figcaption><\/figure>\n<blockquote>\n<p style=\"text-align: justify\">T\u1ed5ng h\u1ee3p ki\u1ebfn th\u1ee9c v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">Excel c\u01a1 b\u1ea3n<\/a> hay nh\u1ea5t<\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chen_lien_ket_toi_trang_web_URL\"><\/span>Ch\u00e8n li\u00ean k\u1ebft t\u1edbi trang web (URL)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o li\u00ean k\u1ebft t\u1edbi m\u1ed9t trang web, m\u1edf h\u1ed9p tho\u1ea1i\u00a0<em>Insert Hyperlink,\u00a0<\/em>v\u00e0 l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn <strong>Existing File or Web Page<\/strong>, ngay d\u01b0\u1edbi <em>Link to<\/em>.<\/li>\n<li>Nh\u1ea5p chu\u1ed9t v\u00e0o n\u00fat <strong>Browse the Web, <\/strong>m\u1edf trang web c\u1ea7n li\u00ean k\u1ebft t\u1edbi, sau \u0111\u00f3 quay l\u1ea1i Excel m\u00e0 kh\u00f4ng t\u1eaft c\u1eeda s\u1ed5 tr\u00ecnh duy\u1ec7t web<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng ch\u00e8n \u0111\u1ecba ch\u1ec9 trang web v\u00e0o <strong>Address <\/strong>v\u00e0 <strong>Text to display. <\/strong>B\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda \u0111o\u1ea1n v\u0103n b\u1ea3n hi\u1ec3n th\u1ecb t\u00f9y \u00fd, th\u00eam ghi ch\u00fa n\u1ebfu mu\u1ed1n, sau \u0111\u00f3 ch\u1ecdn <em>OK <\/em>\u0111\u1ec3 ch\u00e8n li\u00ean k\u1ebft.<\/p>\n<figure style=\"width: 602px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"4 - li\u00ean k\u1ebft Hyperlink trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/insert-hyperlink-webpage.png\" alt=\"4 - li\u00ean k\u1ebft Hyperlink trong Excel\" width=\"602\" height=\"341\"><figcaption class=\"wp-caption-text\">4 \u2013 li\u00ean k\u1ebft Hyperlink trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p URL c\u1ee7a trang web tr\u01b0\u1edbc khi m\u1edf h\u1ed9p tho\u1ea1i <em>Insert Hyperlink<\/em>, sau \u0111\u00f3 d\u00e1n li\u00ean k\u1ebft URL v\u00e0o \u00f4 <strong>Address<\/strong><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_lien_ket_toi_mot_trang_tinh_hoac_mot_o_tinh_trong_Bang_tinh_dang_hoat_dong\"><\/span><strong>T\u1ea1o li\u00ean k\u1ebft t\u1edbi m\u1ed9t trang t\u00ednh ho\u1eb7c m\u1ed9t \u00f4 t\u00ednh trong B\u1ea3ng t\u00ednh \u0111ang ho\u1ea1t \u0111\u1ed9ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o li\u00ean k\u1ebft t\u1edbi m\u1ed9t trang t\u00ednh c\u1ee5 th\u1ec3 trong b\u1ea3ng t\u00ednh \u0111ang ho\u1ea1t \u0111\u1ed9ng, ch\u1ecdn\u00a0 <strong>Place in this Document<\/strong> . Ch\u1ecdn trang t\u00ednh d\u01b0\u1edbi ph\u1ea7n <em>Cell <\/em>Reference, nh\u1ea5n <em>OK<\/em><\/p>\n<figure style=\"width: 602px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"5 - li\u00ean k\u1ebft Hyperlink trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/hyperlink-this-document.png\" alt=\"5 - li\u00ean k\u1ebft Hyperlink trong Excel\" width=\"602\" height=\"341\"><figcaption class=\"wp-caption-text\">5 \u2013 li\u00ean k\u1ebft Hyperlink trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o li\u00ean k\u1ebft trong Excel t\u1edbi m\u1ed9t \u00f4, nh\u1eadp th\u00f4ng tin \u00f4 trong h\u1ed9p <em>Type in the cell reference<\/em>.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 li\u00ean k\u1ebft t\u1edbi m\u1ed9t mi\u1ec1n t\u00ean, ch\u1ecdn m\u1ee5c <em>Defined Names<\/em>.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_lien_ket_de_mo_mot_bang_tinh_Excel_moi\"><\/span><strong>T\u1ea1o li\u00ean k\u1ebft \u0111\u1ec3 m\u1edf m\u1ed9t b\u1ea3ng t\u00ednh Excel m\u1edbi.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Kh\u00f4ng ch\u1ec9 li\u00ean k\u1ebft t\u1edbi m\u1ed9t t\u1ec7p tin c\u00f3 s\u1eb5n, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u1ea1o li\u00ean k\u1ebft t\u1edbi m\u1ed9t t\u1ec7p tin Excel m\u1edbi. C\u00e1ch th\u1ee9c th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng <strong>Create New Document<\/strong>, d\u01b0\u1edbi ph\u1ea7n <em>Link to<\/em><\/li>\n<li>Nh\u1eadp n\u1ed9i dung hi\u1ec3n th\u1ecb li\u00ean k\u1ebft trong h\u1ed9p tho\u1ea1i <em>Text to display<\/em><\/li>\n<li>Nh\u1eadp t\u00ean B\u1ea3ng t\u00ednh m\u1edbi trong h\u1ed9p tho\u1ea1i <em>Name of new document<\/em><\/li>\n<li>Ch\u1ecdn n\u01a1i l\u01b0u tr\u1eef t\u1ec7p tin m\u1edbi t\u1ea1o trong m\u1ee5c <em>Full path<\/em>. N\u1ebfu mu\u1ed1n thay \u0111\u1ed5i \u0111\u1ecba ch\u1ec9 m\u1eb7c \u0111\u1ecbnh, ch\u1ecdn n\u00fat <em>Change<\/em>.<\/li>\n<li>Trong m\u1ee5c <em>When to edit<\/em>, l\u1ef1a ch\u1ecdn t\u00f9y ch\u1ecdn ch\u1ec9nh s\u1eeda mong mu\u1ed1n<\/li>\n<li>Ch\u1ecdn OK<\/li>\n<\/ol>\n<figure style=\"width: 602px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"6 - li\u00ean k\u1ebft Hyperlink trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/create-hyperlink-new-file.png\" alt=\"6 - li\u00ean k\u1ebft Hyperlink trong Excel\" width=\"602\" height=\"341\"><figcaption class=\"wp-caption-text\">6 \u2013 li\u00ean k\u1ebft Hyperlink trong Excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_lien_ket_toi_dia_chi_email\"><\/span><strong>T\u1ea1o li\u00ean k\u1ebft t\u1edbi \u0111\u1ecba ch\u1ec9 email<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ngo\u00e0i vi\u1ec7c c\u00f3 th\u1ec3 li\u00ean k\u1ebft \u0111\u1ebfn nhi\u1ec1u v\u0103n b\u1ea3n kh\u00e1c nhau, t\u00ednh n\u0103ng ch\u00e8n li\u00ean k\u1ebft trong Excel cho ph\u00e9p b\u1ea1n g\u1eedi email tr\u1ef1c ti\u1ebfp t\u1eeb b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh. Thao t\u00e1c theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng <strong>E-mail Address, <\/strong>b\u00ean d\u01b0\u1edbi ph\u1ea7n <em>Link to.<\/em><\/li>\n<li>Trong h\u1ed9p tho\u1ea1i <em>E-mail address, <\/em>nh\u1eadp \u0111\u1ecba ch\u1ec9 email m\u1ed9t ho\u1eb7c nhi\u1ec1u ng\u01b0\u1eddi nh\u1eadn, t\u00e1ch bi\u1ec7t b\u1edfi d\u1ea5u ch\u1ea5m ph\u1ea9y.<\/li>\n<li>Nh\u1eadp ti\u00eau \u0111\u1ec1 tin nh\u1eafn n\u1ebfu mu\u1ed1n trong h\u1ed9p tho\u1ea1i Tuy nhi\u00ean, h\u00e3y l\u01b0u \u00fd r\u1eb1ng m\u1ed9t v\u00e0i tr\u00ecnh duy\u1ec7t v\u00e0 email ng\u01b0\u1eddi nh\u1eadn s\u1ebd kh\u00f4ng nh\u1eadn di\u1ec7n \u0111\u01b0\u1ee3c d\u00f2ng ti\u00eau \u0111\u1ec1.<\/li>\n<li>Nh\u1eadp n\u1ed9i dung li\u00ean k\u1ebft mong mu\u1ed1n trong h\u1ed9p tho\u1ea1i <em>Text to display. <\/em><\/li>\n<li>Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u00eam n\u1ed9i dung b\u1eb1ng c\u00e1ch nh\u1ea5p n\u00fat <em>ScreenTip\u2026 <\/em>( ghi ch\u00fa s\u1ebd hi\u1ec3n th\u1ecb khi b\u1ea1n di chu\u1ed9t \u0111\u1ebfn li\u00ean k\u1ebft)<\/li>\n<li>Nh\u1ea5n OK<\/li>\n<\/ol>\n<figure style=\"width: 602px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"7 - li\u00ean k\u1ebft Hyperlink trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/hyperlink-email-address.png\" alt=\"7 - li\u00ean k\u1ebft Hyperlink trong Excel\" width=\"602\" height=\"341\"><figcaption class=\"wp-caption-text\">7 \u2013 li\u00ean k\u1ebft Hyperlink trong Excel<\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tao_lien_ket_bang_ham_HYPERLINK\"><\/span><strong>C\u00e1ch t\u1ea1o li\u00ean k\u1ebft b\u1eb1ng h\u00e0m HYPERLINK<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n l\u00e0 ng\u01b0\u1eddi th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng c\u00e1c h\u00e0m\u00a0trong Excel \u0111\u1ec3 x\u1eed l\u00fd h\u1ea7u h\u1ebft c\u00e1c c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng HYPERLINK, \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf ri\u00eang \u0111\u1ec3 ch\u00e8n li\u00ean k\u1ebft trong Excel. \u0110i\u1ec1u n\u00e0y s\u1ebd \u0111\u1eb7c bi\u1ec7t h\u1eefu d\u1ee5ng khi b\u1ea1n mu\u1ed1n t\u1ea1o l\u1eadp, ch\u1ec9nh s\u1eeda ho\u1eb7c lo\u1ea1i b\u1ecf nhi\u1ec1u li\u00ean k\u1ebft m\u1ed9t l\u00fac.<\/p>\n<p style=\"text-align: justify\">C\u00fa ph\u00e1p h\u00e0m HYPERLINK nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">HYPERLINK(link_location, [friendly_name])<\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>Link_location <\/strong>l\u00e0 \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ebfn v\u0103n b\u1ea3n ho\u1eb7c trang web<\/li>\n<li><strong>Friendly_name <\/strong>l\u00e0 n\u1ed9i dung hi\u1ec3n th\u1ecb li\u00ean k\u1ebft trong \u00f4<\/li>\n<\/ul>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 nh\u01b0, \u0111\u1ec3 t\u1ea1o li\u00ean k\u1ebft c\u00f3 ti\u00eau \u0111\u1ec1 \u201cSource data\u201d \u0111ang \u0111\u01b0\u1ee3c m\u1edf s\u1eb5n \u1edf Sheet2 trong b\u1ea3ng t\u00ednh c\u00f3 t\u00ean \u201cSource data\u201d, \u0111\u01b0\u1ee3c l\u01b0u trong th\u01b0 m\u1ee5c \u201cExcel files\u201d tr\u00ean \u1ed5 D, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\">=HYPERLINK(\u201c[D:Excel filesSource data.xlsx]Sheet2!A1\u201d, \u201cSource data\u201d)<\/p>\n<p style=\"text-align: justify\">Chi ti\u1ebft c\u00e1c ph\u1ea7n trong h\u00e0m HYPERINK v\u00e0 c\u00e1c h\u00e0m v\u00ed d\u1ee5 \u0111\u1ec3 t\u1ea1o c\u00e1c lo\u1ea1i li\u00ean k\u1ebft kh\u00e1c nhau, tham kh\u1ea3o b\u00e0i vi\u1ebft <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tao-hyperlink-den-website-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Hyperlink trong Excel<\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_lien_ket_bang_ma_VBA\"><\/span><strong>T\u1ea1o li\u00ean k\u1ebft\u00a0b\u1eb1ng m\u00e3 VBA<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o m\u1ed9t li\u00ean k\u1ebft \u00a0t\u1ef1 \u0111\u1ed9ng trong b\u1ea3ng t\u00ednh, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u00e3 VBA sau:<\/p>\n<div style=\"text-align: justify\">\n<div id=\"highlighter_992643\" class=\"syntaxhighlighter nogutter vb\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"vb keyword\">Public<\/code> <code class=\"vb keyword\">Sub<\/code> <code class=\"vb plain\">AddHyperlink()<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">Sheets(<\/code><code class=\"vb string\">\"Sheet1\"<\/code><code class=\"vb plain\">).Hyperlinks.Add Anchor:=Sheets(<\/code><code class=\"vb string\">\"Sheet1\"<\/code><code class=\"vb plain\">).Range(<\/code><code class=\"vb string\">\"A1\"<\/code><code class=\"vb plain\">), Address:=<\/code><code class=\"vb string\">\"\"<\/code><code class=\"vb plain\">, SubAddress:=<\/code><code class=\"vb string\">\"Sheet3!B5\"<\/code><code class=\"vb plain\">, TextToDisplay:=<\/code><code class=\"vb string\">\"My hyperlink\"<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">Sub<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><em>Sheets<\/em> \u2013 T\u00ean trang t\u00ednh ch\u00e8n li\u00ean k\u1ebft (Trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 Sheet 1).Trong \u0111\u00f3:<\/p>\n<ul style=\"text-align: justify\">\n<li><em>Range<\/em> \u2013 T\u00ean \u00f4 ch\u00e8n li\u00ean k\u1ebft (Trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 A1).<\/li>\n<li><em>SubAddress<\/em> \u2013 li\u00ean k\u1ebft \u0111\u00edch \u0111\u1ebfn, v\u00ed d\u1ee5 hyperlink s\u1ebd di chuy\u1ec3n \u0111\u1ebfn \u0111\u00e2u ( trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 Sheet3!B5).<\/li>\n<li><em>TextToDisplay<\/em> \u2013 n\u1ed9i dung hi\u1ec3n th\u1ecb trong \u00f4 ( trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 \u201cMy hyperlink\u201d).<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Theo \u0111\u00f3, m\u00e1y t\u00ednh s\u1ebd ch\u00e8n m\u1ed9t li\u00ean k\u1ebft \u00a0c\u00f3 ti\u00eau \u0111\u1ec1 \u201cMy hyperlink\u201d v\u00e0o \u00f4 A1 t\u1ea1i trang t\u00ednh Sheet1 trong b\u1ea3ng t\u00ednh n\u00e0y. Nh\u1ea5p chu\u1ed9t v\u00e0o li\u00ean k\u1ebft \u0111\u1ec3 di chuy\u1ec3n t\u1edbi \u00f4 B5 trong Sheet3 c\u1ee7a b\u1ea3ng t\u00ednh.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu kh\u00f4ng c\u00f3 nhi\u1ec1u kinh nghi\u1ec7p v\u1edbi l\u1eadp tr\u00ecnh Excel, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c h\u01b0\u1edbng d\u1eabn sau: <a href=\"http:\/\/blog.ezworkapp.com\/bat-dau-voi-lap-trinh-vba-tu-dong-hoa-excel-voi-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener noreferrer\">B\u1eaft \u0111\u1ea7u v\u1edbi l\u1eadp tr\u00ecnh VBA<\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_chinh_sua_lien_ket_trong_Excel\"><\/span><strong>C\u00e1ch ch\u1ec9nh s\u1eeda li\u00ean k\u1ebft trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n t\u1ea1o li\u00ean k\u1ebft b\u1eb1ng h\u1ed9p tho\u1ea1i Insert Hyperlink dialog th\u00ec s\u1ebd s\u1eed d\u1ee5ng ch\u00ednh h\u1ed9p tho\u1ea1i n\u00e0y \u0111\u1ec3 s\u1eeda ch\u00fang. Nh\u1ea5p chu\u1ed9t ph\u1ea3i \u1edf \u00f4 ch\u00e8n li\u00ean k\u1ebft, ch\u1ecdn <strong>Edit Hyperlink\u2026<\/strong> ho\u1eb7c s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Crtl+K ho\u1eb7c nh\u1ea5p chu\u1ed9t v\u00e0o n\u00fat \u00a0<em>Hyperlink <\/em>tr\u00ean thanh c\u00f4ng c\u1ee5.<\/p>\n<figure style=\"width: 251px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"8 - li\u00ean k\u1ebft Hyperlink trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/edit-hyperlink-excel.png\" alt=\"8 - li\u00ean k\u1ebft Hyperlink trong Excel\" width=\"251\" height=\"388\"><figcaption class=\"wp-caption-text\">8 \u2013 li\u00ean k\u1ebft Hyperlink trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">D\u00f9 thao t\u00e1c theo c\u00e1ch n\u00e0o, h\u1ed9p tho\u1ea1i <strong>Edit Hyperlink <\/strong>s\u1ebd hi\u1ec7n ra. T\u1eeb \u0111\u00e2y b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ch\u1ec9nh s\u1eeda n\u1ebfu mu\u1ed1n trong n\u1ed9i dung li\u00ean k\u1ebft ho\u1eb7c \u0111\u1ecba ch\u1ec9 li\u00ean k\u1ebft ho\u1eb7c c\u1ea3 hay, sau \u0111\u00f3 nh\u1ea5p <em>OK.<\/em><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c hyperlink, ch\u1ecdn \u00f4 ch\u1ee9a h\u00e0m Hyperlink v\u00e0 ch\u1ec9nh s\u1eeda. C\u00e1c m\u1eb9o ti\u1ebfp theo \u0111\u01b0\u1ee3c gi\u1ea3i th\u00edch c\u1ee5 th\u1ec3 trong c\u00e1ch ch\u1ecdn m\u1ed9t \u00f4 m\u00e0 kh\u00f4ng b\u1ecb \u0111i\u1ec1u h\u01b0\u1edbng t\u1edbi \u0111\u1ecba ch\u1ec9 li\u00ean k\u1ebft.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_thay_doi_dinh_dang_lien_ket_duoc_chen\"><\/span><strong>C\u00e1ch thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng li\u00ean k\u1ebft \u0111\u01b0\u1ee3c ch\u00e8n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00e1c li\u00ean k\u1ebft \u0111\u01b0\u1ee3c ch\u00e8n trong Excel \u0111\u01b0\u01a1c m\u1eb7c \u0111\u1ecbnh c\u00f3 \u0111\u1ecbnh d\u1ea1ng ch\u1eef g\u1ea1ch ch\u00e2n m\u00e0u xanh. C\u00e1c b\u01b0\u1edbc \u0111\u1ec3 ch\u1ec9nh s\u1eeda \u0111\u1ecbnh d\u1ea1ng n\u00e0y nh\u01b0 sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Trong tab <em>Home<\/em>, nh\u00f3m <em>Styles<\/em>:<\/li>\n<\/ol>\n<ul style=\"text-align: justify\">\n<li>Nh\u1ea5p chu\u1ed9t ph\u1ea3i <strong>Hyperlink<\/strong>, sau \u0111\u00f3 ch\u1ecdn <strong>Modify\u2026<\/strong> \u0111\u1ec3 ch\u1ec9nh s\u1eeda \u0111\u1ecbnh d\u1ea1ng li\u00ean k\u1ebft \u0111\u00e3 s\u1eed d\u1ee5ng<\/li>\n<li>Nh\u1ea5p chu\u1ed9t ph\u1ea3i <strong>Followed<\/strong> <strong>Hyperlink<\/strong>, sau \u0111\u00f3 ch\u1ecdn <strong>Modify\u2026<\/strong> \u0111\u1ec3 ch\u1ec9nh s\u1eeda li\u00ean k\u1ebft \u0111\u00e3 \u0111\u01b0\u1ee3c d\u00f9ng tr\u01b0\u1edbc \u0111\u00f3<\/li>\n<\/ul>\n<ol style=\"text-align: justify\">\n<li style=\"list-style-type: none\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/change-hyperlinks-excel.png\" alt=\"Select whether to change the appearance of followed or non-followed hyperlinks.\" title=\"change-hyperlinks-excel\"><\/li>\n<li>Trong h\u1ed9p tho\u1ea1i <em>Style<\/em>, ch\u1ecdn <strong>Format\u2026<\/strong>\n<p><figure style=\"width: 287px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"9 - li\u00ean k\u1ebft Hyperlink trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/hyperlink-format.png\" alt=\"9 - li\u00ean k\u1ebft Hyperlink trong Excel\" width=\"287\" height=\"357\"><figcaption class=\"wp-caption-text\">9 \u2013 li\u00ean k\u1ebft Hyperlink trong Excel<\/figcaption><\/figure>\n<\/p>\n<\/li>\n<li>Trong h\u1ed9p tho\u1ea1i <em>Format Cells<\/em>, chuy\u1ec3n sang tab <strong>Font<\/strong> ho\u1eb7c <strong>Fill<\/strong>, s\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn b\u1ea1n mu\u1ed1n v\u00e0 ch\u1ecdn <em>OK<\/em> . V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i ki\u1ec3u ch\u1eef v\u00e0 m\u00e0u ch\u1eef nh\u01b0 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/img-blog\/change-hyperlink-font-color.png\" alt=\"Select the formatting options of your choosing.\"><\/li>\n<li>Thay \u0111\u1ed5i s\u1ebd hi\u1ec7n th\u1ecb ngay l\u1eadp t\u1ee9c trong h\u1ed9p tho\u1ea1i Styles. N\u1ebfu b\u1ea1n quy\u1ebft \u0111\u1ecbnh kh\u00f4ng \u00e1p d\u1ee5ng m\u1ed9t s\u1ed1 ch\u1ec9nh s\u1eeda c\u1ed1 \u0111\u1ecbnh th\u00ec h\u00e3y xo\u00e1c c\u00e1c h\u1ed9p ki\u1ec3m cho c\u00e1c t\u00f9y ch\u1ecdn \u0111\u00f3.\n<p><figure style=\"width: 287px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"10 - li\u00ean k\u1ebft Hyperlink trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-hyperlink-style.png\" alt=\"10 - li\u00ean k\u1ebft Hyperlink trong Excel\" width=\"287\" height=\"357\"><figcaption class=\"wp-caption-text\">10 \u2013 li\u00ean k\u1ebft Hyperlink trong Excel<\/figcaption><\/figure>\n<\/p>\n<\/li>\n<li>Cu\u1ed1i c\u00f9ng ch\u1ecdn <em>OK <\/em>\u0111\u1ec3 l\u01b0u thay \u0111\u1ed5i.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd. <\/strong>M\u1ecdi thay \u0111\u1ed5i \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n cho \u0111\u1ecbnh d\u1ea1ng li\u00ean k\u1ebft \u0111\u01b0\u1ee3c ch\u00e8n s\u1ebd \u00e1p d\u1ee5ng cho t\u1ea5t c\u1ea3 c\u00e1c li\u00ean k\u1ebft \u0111\u01b0\u1ee3c ch\u00e8n kh\u00e1c trong b\u1ea3ng t\u00ednh hi\u1ec7n t\u1ea1i. B\u1ea1n s\u1ebd kh\u00f4ng th\u1ec3 ch\u1ec9nh s\u1eeda \u0111\u1ecbnh d\u1ea1ng ri\u00eang bi\u1ec7t cho t\u1eebng li\u00ean k\u1ebft.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_xoa_lien_ket_da_duoc_chen_trong_Excel\"><\/span><strong>C\u00e1ch x\u00f3a li\u00ean k\u1ebft \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u00e8n trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 x\u00f3a li\u00ean k\u1ebft trong Excel c\u1ea7n th\u1ef1c hi\u1ec7n qua hai thao t\u00e1c sau. Nh\u1ea5p chu\u1ed9t ph\u1ea3i t\u1ea1i li\u00ean k\u1ebft \u0111\u00f3, ch\u1ecdn <strong>Remove Hyperlink.<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/remove-hyperlink-excel.png\" alt=\"Removing a hyperlink in Excel\" title=\"remove-hyperlink-excel\"><\/p>\n<p style=\"text-align: justify\">Li\u00ean k\u1ebft s\u1ebd \u0111\u01b0\u1ee3c x\u00f3a v\u00e0 gi\u1eef nguy\u00ean n\u1ed9i dung li\u00ean k\u1ebft trong \u00f4 \u0111\u00f3. \u0110\u1ec3 x\u00f3a c\u1ea3 n\u1ed9i dung li\u00ean k\u1ebft, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4, ch\u1ecdn <strong>Clear Contents<\/strong>.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Loi_khuyen_su_dung_lien_ket_trong_Excel\"><\/span><strong>L\u1eddi khuy\u00ean s\u1eed d\u1ee5ng li\u00ean k\u1ebft trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u00ean c\u1ea1nh vi\u1ec7c h\u1ecdc c\u00e1ch t\u1ea1o m\u1edbi, ch\u1ec9nh s\u1eeda v\u00e0 x\u00f3a li\u00ean k\u1ebft \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u00e8n kh\u1ecfi Excel, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 tham kh\u1ea3o nh\u1eefng l\u1eddi khuy\u00ean h\u1eefu \u00edch sau \u0111\u1ec3 s\u1eed d\u1ee5ng li\u00ean k\u1ebft m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_de_chon_o_co_chua_lien_ket\"><\/span><strong>C\u00e1ch \u0111\u1ec3 ch\u1ecdn \u00f4 c\u00f3 ch\u1ee9a li\u00ean k\u1ebft <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Excel m\u1eb7c \u0111\u1ecbnh s\u1ebd di chuy\u1ec3n b\u1ea1n t\u1edbi li\u00ean k\u1ebft \u0111\u01b0\u1ee3c ch\u00e8n khi nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 c\u00f3 ch\u1ee9a li\u00ean k\u1ebft, nh\u01b0 m\u1ed9t b\u1ea3n ho\u1eb7c m\u1ed9t trang web. Tuy nhi\u00ean, \u0111\u1ec3 c\u00f3 th\u1ec3 ch\u1ecdn \u00f4 t\u00ednh m\u00e0 kh\u00f4ng di chuy\u1ec3n t\u1edbi \u0111\u1ecba ch\u1ec9 \u0111\u00f3, nh\u1ea5p v\u00e0o \u00f4 v\u00e0 gi\u1eef n\u00fat chu\u1ed9t cho \u0111\u1ebfn khi con tr\u1ecf bi\u1ebfn th\u00e0nh ch\u1eef th\u1eadp <img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-cross.png\" alt=\"Excel selection cursor\" title=\"excel-cross\">\u00a0sau \u0111\u00f3 th\u1ea3 ra.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu li\u00ean k\u1ebft ch\u1ec9 chi\u1ebfm m\u1ed9t ph\u1ea7n c\u1ee7a m\u1ed9t \u00f4 t\u00ednh, di chuy\u1ec3n con tr\u1ecf chu\u1ed9t l\u00ean v\u00f9ng tr\u1ed1ng, v\u00e0 ngay khi n\u00f3 thay \u0111\u1ed5i t\u1eeb h\u00ecnh con tr\u1ecf sang h\u00ecnh ch\u1eef th\u1eadp, h\u00e3y nh\u1ea5p v\u00e0o \u00f4:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/select-cell-hyperlink.png\" alt=\"Select a cell containing a hyperlink without jumping to the link destination\" title=\"select-cell-hyperlink\"><\/p>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 ch\u1ecdn m\u1ed9t \u00f4 m\u00e0 kh\u00f4ng c\u1ea7n m\u1edf li\u00ean k\u1ebft l\u00e0 ch\u1ecdn m\u1ed9t \u00f4 l\u00e2n c\u1eadn, v\u00e0 s\u1eed d\u1ee5ng c\u00e1c ph\u00edm m\u0169i t\u00ean \u0111\u1ec3 t\u1edbi \u00f4 li\u00ean k\u1ebft.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_thuc_de_trich_xuat_mot_dia_chi_web_tu_lien_ket_trong_Excel\"><\/span><strong>C\u00e1ch th\u1ee9c \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t \u0111\u1ecba ch\u1ec9 web t\u1eeb li\u00ean k\u1ebft trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">C\u00f3 hai c\u00e1ch \u0111\u1ec3 tr\u00edch xu\u1ea5t \u0111\u1ecba ch\u1ec9 web t\u1eeb li\u00ean trong Excel \u0111\u00f3 l\u00e0: th\u1ee7 c\u00f4ng ho\u1eb7c l\u1eadp tr\u00ecnh.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Trich_xuat_dia_chi_web_thu_cong_tu_lien_ket\"><\/span><strong>Tr\u00edch xu\u1ea5t \u0111\u1ecba ch\u1ec9 web th\u1ee7 c\u00f4ng t\u1eeb li\u00ean k\u1ebft<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu mu\u1ed1n xu\u1ea5t nhi\u1ec1u li\u00ean k\u1ebft m\u1ed9t l\u00fac, h\u00e3y thao t\u00e1c theo nh\u1eefng b\u01b0\u1edbc sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn \u00f4 t\u00ednh ch\u1ee9a li\u00ean k\u1ebft<\/li>\n<li>M\u1edf h\u1ed9p tho\u1ea1i <em>Edit Hyperlink<\/em> b\u1eb1ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl + K, ho\u1eb7c nh\u1eadp chu\u1ed9t ph\u1ea3i v\u00e0o li\u00ean k\u1ebft hyperlink sau \u0111\u00f3 ch\u1ecdn <strong>Edit hyperlink\u2026<\/strong>.<\/li>\n<li>Trong m\u1ee5c <em>Address field<\/em>, ch\u1ecdn \u0111\u1ecba ch\u1ec9 li\u00ean k\u1ebft v\u00e0 d\u00f9ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl + C \u0111\u1ec3 sao ch\u00e9p.<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/copy-hyperlink-address.png\" alt=\"Copy the hyperlink address\" title=\"copy-hyperlink-address\"><\/li>\n<li>Nh\u1ea5p Esc ho\u1eb7c ch\u1ecdn <em>OK<\/em> \u0111\u1ec3 \u0111\u00f3ng h\u1ed9p tho\u1ea1i <em>Edit Hyperlink<\/em><\/li>\n<li>D\u00e1n \u0111\u1ecba ch\u1ec9 li\u00ean k\u1ebft URL v\u00e0o m\u1ed9t \u00f4 t\u00ednh tr\u1ed1ng b\u1ea5t k\u00ec. V\u00e0 th\u1ebf l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 \u0111\u01b0\u1ee3c \u0111\u1ecba ch\u1ec9 web!<\/li>\n<\/ol>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Trich_xuat_nhieu_dia_chi_lien_ket_bang_ma_VBA\"><\/span><strong>Tr\u00edch xu\u1ea5t nhi\u1ec1u \u0111\u1ecba ch\u1ec9 li\u00ean k\u1ebft b\u1eb1ng m\u00e3 VBA<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u00f3 nhi\u1ec1u li\u00ean k\u1ebft trong m\u1ed9t b\u1ea3ng t\u00ednh Excel th\u00ec vi\u1ec7c tr\u00edch xu\u1ea5t ch\u00fang th\u1ee7 c\u00f4ng s\u1ebd r\u1ea5t t\u1ed1n th\u1eddi gian. Ch\u00ednh v\u00ec v\u1eady, \u0111o\u1ea1n m\u00e3 d\u01b0\u1edbi \u0111\u00e2y c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian b\u1eb1ng c\u00e1ch tr\u00edch xu\u1ea5t t\u1ea5t c\u1ea3 \u0111\u1ecba ch\u1ec9 li\u00ean k\u1ebft m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng:<\/p>\n<table>\n<tbody>\n<tr>\n<td>Sub ExtractHL()<\/p>\n<p>Dim HL As Hyperlink<\/p>\n<p>Dim OverwriteAll As Boolean<\/p>\n<p>OverwriteAll = False<\/p>\n<p>For Each HL In ActiveSheet.Hyperlinks<\/p>\n<p>If Not OverwriteAll Then<\/p>\n<p>If HL.Range.Offset(0, 1).Value &lt;&gt; \u201c\u201d Then<\/p>\n<p>If MsgBox(\u201cOne or more of the target cells is not empty. Do you want to overwrite all cells?\u201d, vbOKCancel, \u201cTarget cells are not empty\u201d) = vbCancel Then<\/p>\n<p>Exit For<\/p>\n<p>Else<\/p>\n<p>OverwriteAll = True<\/p>\n<p>End If<\/p>\n<p>End If<\/p>\n<p>End If<\/p>\n<p>HL.Range.Offset(0, 1).Value = HL.Address<\/p>\n<p>Next<\/p>\n<p>End Sub<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">H\u00ecnh minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y th\u1ec3 hi\u1ec7n m\u00e3 VBA tr\u00edch xu\u1ea5t t\u1ea5t c\u1ea3 \u0111\u1ecba ch\u1ec9 li\u00ean k\u1ebft t\u1eeb c\u1ed9t c\u00f3 ch\u1ee9a li\u00ean k\u1ebft hyperlink v\u00e0 \u0111\u01b0a ra k\u1ebft qu\u1ea3 \u1edf c\u1ed9t b\u00ean c\u1ea1nh.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/extract-multiple-urls.png\" alt=\"Multiples URLs are extracted at a time\" title=\"extract-multiple-urls\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">\u0110\u0103ng k\u00fd ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">kho\u0301a ho\u0323c l\u00e2\u0323p tri\u0300nh VBA trong excel<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>Chuy\u1ec3n \u0111\u1ed5i b\u1ea3ng t\u00ednh th\u00e0nh d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a li\u00ean k\u1ebft \u0111\u01b0\u1ee3c ch\u00e8n<\/strong><\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i v\u0103n b\u1ea3n, nhi\u1ec1u b\u1ea3ng t\u00ednh c\u00f3 ch\u1ee9a c\u1ea3 nh\u1eefng \u0111\u1ed3 th\u1ecb, h\u00ecnh \u1ea3nh, v\u0103n b\u1ea3n ho\u1eb7c c\u00e1c h\u00ecnh d\u1ea1ng c\u00f3 th\u1ec3 chuy\u1ec3n sang d\u1ea1ng li\u00ean k\u1ebft. Ch\u1ec9 b\u1eb1ng c\u00fa nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n chuy\u1ec3n \u0111\u1ed5i ( nh\u01b0 h\u00ecnh minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y), ch\u1ecdn <strong>Hyperlink\u2026<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/link-worksheet-object.png\" alt=\"Use the object's context menu to make it a hyperlink.\" title=\"link-worksheet-object\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u00e1ch b\u1ea1n. <\/strong>M\u1ed9t s\u1ed1 bi\u1ec3u \u0111\u1ed3 khi nh\u1ea5p chu\u1ed9t ph\u1ea3i s\u1ebd kh\u00f4ng c\u00f3 ph\u1ea7n l\u1ef1a ch\u1ecdn <em>Hyperlink. <\/em>\u0110\u1ec3 chuy\u1ec3n m\u1ed9t bi\u1ec3u \u0111\u1ed3 trong Excel th\u00e0nh li\u00ean k\u1ebft, ch\u1ecdn bi\u1ec3u \u0111\u1ed3 v\u00e0 s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl+K.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lien_ket_trong_Excel_bi_loi_cac_nguyen_nhan_va_cach_khac_phuc\"><\/span><strong>Li\u00ean k\u1ebft trong Excel b\u1ecb l\u1ed7i, c\u00e1c nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu c\u00e1c li\u00ean k\u1ebft kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng trong b\u1ea3ng t\u00ednh, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1 d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ecm ra nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c ch\u00fang.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tham_chieu_khong_hop_le_Reference_isnt_valid\"><\/span><strong><em>Tham chi\u1ebfu kh\u00f4ng h\u1ee3p l\u1ec7 (<\/em><\/strong><em>Reference isn\u2019t valid) <\/em><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><em>D\u1ea5u hi\u1ec7u<\/em>: Khi nh\u1ea5p chu\u1ed9t v\u00e0o li\u00ean k\u1ebft trong Excel, ng\u01b0\u1eddi d\u00f9ng s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c di chuy\u1ec3n t\u1edbi \u0111\u00edch li\u00ean k\u1ebft v\u00e0 h\u1ed9p tho\u1ea1i b\u00e1o l\u1ed7i <em>\u201cReference isn\u2019t valid\u201d (Tham chi\u1ebfu kh\u00f4ng h\u1ee3p l\u1ec7)<\/em> hi\u1ec7n l\u00ean.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/reference-is-not-valid.png\" alt=\"Reference isn't valid.\" title=\"reference-is-not-valid\"><\/p>\n<p style=\"text-align: justify\"><em>C\u00e1ch kh\u1eafc ph\u1ee5c<\/em>: Khi t\u1ea1o li\u00ean k\u1ebft t\u1edbi m\u1ed9t trang t\u00ednh kh\u00e1c, t\u00ean c\u1ee7a trang t\u00ednh ch\u00ednh l\u00e0 m\u1ee5c ti\u00eau li\u00ean k\u1ebft. N\u1ebfu sau \u0111\u00f3 b\u1ea1n \u0111\u1ed5i t\u00ean trang t\u00ednh, Excel s\u1ebd kh\u00f4ng x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ee7a m\u1ee5c ti\u00eau, v\u00e0 li\u00ean k\u1ebft s\u1ebd ng\u1eebng ho\u1ea1t \u0111\u1ed9ng. \u0110\u1ec3 kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1 n\u00e0y, b\u1ea1n c\u1ea7n thay \u0111\u1ed5i t\u00ean c\u1ee7a trang t\u00ednh v\u1ec1 nguy\u00ean b\u1ea3n ho\u1eb7c ch\u1ec9nh s\u1eeda li\u00ean k\u1ebft ch\u00e8n \u0111\u1ec3 li\u00ean k\u1ebft l\u1ea1i v\u1edbi trang t\u00ednh \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ed5i t\u00ean.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111\u00e3 t\u1ea1o li\u00ean k\u1ebft v\u1edbi m\u1ed9t t\u1ec7p tin nh\u01b0ng sau \u0111\u00f3 l\u1ea1i di chuy\u1ec3n t\u1ec7p tin \u0111\u00f3 t\u1edbi m\u1ed9t v\u1ecb tr\u00ed kh\u00e1c, b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i ch\u1ec9nh s\u1eeda l\u1ea1i \u0111\u01b0\u1eddng d\u1eabn m\u1edbi t\u1edbi t\u1ec7p tin n\u00e0y.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lien_ket_xuat_hien_duoi_dang_van_ban_thuan_tuy\"><\/span><strong>Li\u00ean k\u1ebft xu\u1ea5t hi\u1ec7n d\u01b0\u1edbi d\u1ea1ng v\u0103n b\u1ea3n thu\u1ea7n t\u00fay<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><em>D\u1ea5u hi\u1ec7u: <\/em>\u0110\u1ecba ch\u1ec9 web \u0111\u00e3 nh\u1eadp, sao ch\u00e9p v\u00e0o b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n nh\u01b0ng kh\u00f4ng t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n th\u00e0nh d\u1ea1ng li\u00ean k\u1ebft, ho\u1eb7c kh\u00f4ng c\u00f3 \u0111\u1ecbnh d\u1ea1ng n\u1ed5i b\u1eadt l\u00ean v\u1edbi ch\u1eef m\u00e0u xanh v\u00e0 c\u00f3 g\u1ea1ch ch\u00e2n. Ho\u1eb7c li\u00ean k\u1ebft v\u1eabn \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng nh\u01b0ng l\u1ea1i kh\u00f4ng di chuy\u1ec3n t\u1edbi m\u1ee5c ti\u00eau khi nh\u1ea5p chu\u1ed9t v\u00e0o.<\/p>\n<p style=\"text-align: justify\"><em>C\u00e1ch kh\u1eafc ph\u1ee5c<\/em>: Nh\u1eadp \u0111\u00fap chu\u1ed9t v\u00e0o \u00f4 t\u00ednh ho\u1eb7c nh\u1ea5n F2 \u0111\u1ec3 ch\u1ec9nh s\u1eeda, \u0111i \u0111\u1ebfn cu\u1ed1i \u0111\u1ecba ch\u1ec9 URL v\u00e0 \u1ea5n Enter. Excel s\u1ebd chuy\u1ec3n d\u1ea1ng v\u0103n b\u1ea3n \u0111\u00f3 sang d\u1ea1ng li\u00ean k\u1ebft. N\u1ebfu nhi\u1ec1u li\u00ean k\u1ebft c\u0169ng g\u1eb7p l\u1ed7i t\u01b0\u01a1ng t\u1ef1, c\u1ea7n ki\u1ec3m tra l\u1ea1i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 t\u00ednh. \u0110\u00f4i khi l\u1ed7i n\u1eb1m \u1edf \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 t\u00ednh khi \u1edf \u0111\u1ecbnh d\u1ea1ng <em>General. <\/em>Trong tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3, h\u00e3y th\u1eed thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 t\u00ednh sang d\u1ea1ng <em>Text.<\/em><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lien_ket_khong_hoat_dong_khi_mo_lai_bang_tinh\"><\/span><strong>Li\u00ean k\u1ebft kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng khi m\u1edf l\u1ea1i b\u1ea3ng t\u00ednh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><em>D\u1ea5u hi\u1ec7u:<\/em> Li\u00ean k\u1ebft c\u1ee7a Excel tr\u01b0\u1edbc \u0111\u00f3 v\u1eabn ho\u1ea1t \u0111\u1ed9ng b\u00ecnh th\u01b0\u1eddng nh\u01b0ng sau khi m\u1edf l\u1ea1i b\u1ea3ng t\u00ednh, ch\u00fang chuy\u1ec3n sang m\u00e0u x\u00e1m v\u00e0 kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng.<\/p>\n<p style=\"text-align: justify\"><em>C\u00e1ch kh\u1eafc ph\u1ee5c<\/em>: \u00a0\u0110\u1ea7u ti\u00ean, ki\u1ec3m tra l\u1ea1i li\u00ean k\u1ebft \u0111\u00edch xem c\u00f3 thay \u0111\u1ed5i n\u00e0o hay kh\u00f4ng, v\u00ed d\u1ee5 v\u0103n b\u1ea3n \u0111\u00edch \u0111\u00e3 b\u1ecb \u0111\u1ed5i t\u00ean ho\u1eb7c x\u00f3a b\u1ecf. N\u1ebfu kh\u00f4ng, b\u1ea1n c\u00e2n nh\u1eafc t\u1eaft t\u00f9y ch\u1ecdn bu\u1ed9c Excel ph\u1ea3i ki\u1ec3m tra c\u00e1c li\u00ean k\u1ebft Hyperlink m\u1ed7i khi b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c l\u01b0u l\u1ea1i. Nh\u1eefng t\u00f9y ch\u1ecdn n\u00e0y \u0111\u00e3 th\u00f4ng b\u00e1o v\u1edbi Excel \u0111\u1ec3 v\u00f4 hi\u1ec7u h\u00f3a c\u00e1c li\u00ean k\u1ebft ( v\u00ed d\u1ee5, li\u00ean k\u1ebft t\u1edbi c\u00e1c t\u1ec7p tin \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong m\u1ea1ng n\u1ed9i b\u1ed9 c\u00f3 th\u1ec3 b\u1ecb v\u00f4 hi\u1ec7u b\u1edfi l\u1ed7i m\u00e1y ch\u1ee7). \u0110\u1ec3 t\u1eaft t\u00f9y ch\u1ecdn n\u00e0y, h\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Trong Excel 2010, Excel 2013 and Excel 2016, ch\u1ecdn <em>File<\/em> &gt; <em>Options<\/em>. Trong Excel 2007, ch\u1ecdn n\u00fat Office &gt; <em>Excel Options<\/em>.<\/li>\n<li>Tr\u00ean g\u00f3c tr\u00e1i, ch\u1ecdn <em>Advanced<\/em>.<\/li>\n<li>K\u00e9o xu\u1ed1ng t\u1edbi ph\u1ea7n <em>General<\/em>, ch\u1ecdn ph\u1ea7n <em>Web Options\u2026<\/em><\/li>\n<li>Trong h\u1ed9p tho\u1ea1i <em>Web Options<\/em>, \u0111\u1ed5i sang tab <em>Files<\/em>, b\u1ecf l\u1ef1a ch\u1ecdn <strong>Update links on save<\/strong>, sau \u0111\u00f3 ch\u1ecdn <em>OK<\/em>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/update-links.png\" alt=\"Clear the Update links on save box.\" title=\"update-links\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cac_lien_ket_duoc_tao_boi_ham_HYPERLINK_khong_hoat_dong\"><\/span><strong>C\u00e1c li\u00ean k\u1ebft \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi h\u00e0m HYPERLINK kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><em>D\u1ea5u hi\u1ec7u<\/em>: M\u1ed9t li\u00ean k\u1ebft \u0111\u01b0\u1ee3c t\u1ea1o ra b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m HYPERLINK kh\u00f4ng m\u1edf ho\u1eb7c hi\u1ec3n th\u1ecb m\u1ed9t gi\u00e1 tr\u1ecb l\u1ed7i trong m\u1ed9t \u00f4.<\/p>\n<p style=\"text-align: justify\"><em>C\u00e1ch kh\u1eafc ph\u1ee5c<\/em>: H\u1ea7u h\u1ebft v\u1ea5n \u0111\u1ec1 c\u1ee7a li\u00ean k\u1ebft \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi h\u00e0m HYPERLINK b\u1ecb l\u1ed7i do \u0111\u01b0\u1eddng d\u1eabn sai ho\u1eb7c kh\u00f4ng t\u1ed3n t\u1ea1i, trong ph\u1ea7n <em>link_location<\/em> .<\/p>\n<p style=\"text-align: justify\">Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1ch t\u1ea1o, ch\u1ec9nh s\u1eeda v\u00e0 x\u00f3a li\u00ean k\u1ebft ch\u00e8n trong Excel. C\u1ea3m \u01a1n s\u1ef1 quan t\u00e2m v\u00e0 h\u1eb9n g\u1eb7p b\u1ea1n trong nh\u1eefng b\u00e0i ti\u1ebfp theo.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 n\u00e2ng cao ki\u1ebfn th\u1ee9c v\u1ec1 Excel, b\u1ea1n c\u00f3 th\u1ec3 tham gia ngay\u00a0kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2wauPZX\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia\u00a0<\/a>c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap cung c\u1ea5p ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, b\u00e0i b\u1ea3n, c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Th\u00f4ng qua kh\u00f3a h\u1ecdc n\u00e0y b\u1ea1n s\u1ebd bi\u1ebft c\u00e1ch \u0111\u1ec3 l\u00e0m ra 1 b\u1ea3ng b\u00e1o c\u00e1o ch\u00ednh x\u00e1c, \u0111\u00fang chu\u1ea9n, t\u1eeb \u0111\u00f3 c\u00f3 th\u1ec3\u00a0c\u00f3 nh\u1eefng d\u1eef li\u1ec7u\u00a0theo \u00fd mu\u1ed1n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i h\u1ea5p d\u1eabn d\u00e0nh cho b\u1ea1n khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/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\/2025\/01\/vba101_92019-nho-71.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12043,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12042","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\/12042","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=12042"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12042\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12043"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12042"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12042"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}