{"id":10269,"date":"2025-01-12T03:16:15","date_gmt":"2025-01-12T03:16:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/12\/huong-dan-cach-sua-cac-loi-lien-quan-toi-co-dinh-bang-tinh-bang-freeze-panes\/"},"modified":"2025-01-12T03:16:15","modified_gmt":"2025-01-12T03:16:15","slug":"huong-dan-cach-sua-cac-loi-lien-quan-toi-co-dinh-bang-tinh-bang-freeze-panes","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/12\/huong-dan-cach-sua-cac-loi-lien-quan-toi-co-dinh-bang-tinh-bang-freeze-panes\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eeda c\u00e1c l\u1ed7i li\u00ean quan t\u1edbi c\u1ed1 \u0111\u1ecbnh b\u1ea3ng t\u00ednh b\u1eb1ng Freeze Panes"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Nh\u01b0 ch\u00fang ta \u0111\u00e3 bi\u1ebft, ch\u1ee9c n\u0103ng Freeze Panes trong Excel s\u1ebd gi\u00fap c\u1ed1 \u0111\u1ecbnh c\u00e1c d\u00f2ng, c\u00e1c c\u1ed9t trong 1 Sheet. Tuy nhi\u00ean vi\u1ec7c s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng n\u00e0y \u0111\u00f4i khi t\u1ea1o ra nh\u1eefng \u201cl\u1ed7i\u201d khi\u1ebfn ch\u00fang ta b\u1ed1i r\u1ed1i. H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi th\u1ef1c hi\u1ec7n c\u1ed1 \u0111\u1ecbnh d\u00f2ng c\u1ed9t trong Excel v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c nh\u00e9.<\/p>\n<p>N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Freeze Panes \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh d\u00f2ng, c\u1ed9t trong b\u1ea3ng t\u00ednh th\u00ec c\u00f3 th\u1ec3 xem l\u1ea1i b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel-nhieu-cach-moi-hay-va-la.html\">H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e2ng cao trong Excel, nhi\u1ec1u c\u00e1ch m\u1edbi hay v\u00e0 l\u1ea1<\/a><\/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-678333fef0b96\" 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\/huong-dan-cach-sua-cac-loi-lien-quan-toi-co-dinh-bang-tinh-bang-freeze-panes.html#Khong_hien_ra_cac_cong_cu_trong_nhom_chuc_nang_Freeze_Panes\" title=\"Kh\u00f4ng hi\u1ec7n ra c\u00e1c c\u00f4ng c\u1ee5 trong nh\u00f3m ch\u1ee9c n\u0103ng Freeze Panes\">Kh\u00f4ng hi\u1ec7n ra c\u00e1c c\u00f4ng c\u1ee5 trong nh\u00f3m ch\u1ee9c n\u0103ng Freeze Panes<\/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\/huong-dan-cach-sua-cac-loi-lien-quan-toi-co-dinh-bang-tinh-bang-freeze-panes.html#Tinh_trang\" title=\"T\u00ecnh tr\u1ea1ng\">T\u00ecnh tr\u1ea1ng<\/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\/huong-dan-cach-sua-cac-loi-lien-quan-toi-co-dinh-bang-tinh-bang-freeze-panes.html#Cach_khac_phuc\" title=\"C\u00e1ch kh\u1eafc ph\u1ee5c\">C\u00e1ch kh\u1eafc ph\u1ee5c<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-sua-cac-loi-lien-quan-toi-co-dinh-bang-tinh-bang-freeze-panes.html#Chuc_nang_Freeze_Panes_hoat_dong_khong_nhu_mong_muon\" title=\"Ch\u1ee9c n\u0103ng Freeze Panes\u00a0ho\u1ea1t \u0111\u1ed9ng kh\u00f4ng nh\u01b0 mong mu\u1ed1n\">Ch\u1ee9c n\u0103ng Freeze Panes\u00a0ho\u1ea1t \u0111\u1ed9ng kh\u00f4ng nh\u01b0 mong mu\u1ed1n<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-sua-cac-loi-lien-quan-toi-co-dinh-bang-tinh-bang-freeze-panes.html#Tinh_trang-2\" title=\"T\u00ecnh tr\u1ea1ng\">T\u00ecnh tr\u1ea1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-sua-cac-loi-lien-quan-toi-co-dinh-bang-tinh-bang-freeze-panes.html#Cach_khac_phuc-2\" title=\"C\u00e1ch kh\u1eafc ph\u1ee5c\">C\u00e1ch kh\u1eafc ph\u1ee5c<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Khong_hien_ra_cac_cong_cu_trong_nhom_chuc_nang_Freeze_Panes\"><\/span>Kh\u00f4ng hi\u1ec7n ra c\u00e1c c\u00f4ng c\u1ee5 trong nh\u00f3m ch\u1ee9c n\u0103ng Freeze Panes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>T\u00ecnh tr\u1ea1ng n\u00e0y \u0111\u01b0\u1ee3c m\u00f4 t\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20554\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/loi-freeze-panes-khong-su-dung-duoc.png\" width=\"1106\" height=\"330\" title=\"loi-freeze-panes-khong-su-dung-duoc\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_trang\"><\/span><strong>T\u00ecnh tr\u1ea1ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Kh\u00f4ng b\u1ea5m v\u00e0o m\u1ee5c Freeze Panes trong th\u1ebb View \u0111\u01b0\u1ee3c, ho\u1eb7c b\u1ea5m v\u00e0o nh\u01b0ng kh\u00f4ng hi\u1ec7n ra c\u1eeda s\u1ed5 c\u00e1c\u00a0ch\u1ee9c n\u0103ng\u00a0trong Freeze Panes<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_khac_phuc\"><\/span><strong>C\u00e1ch kh\u1eafc ph\u1ee5c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li><strong>C\u00e1ch th\u1ee9 1<\/strong>: L\u01b0u file l\u1ea1i &gt; \u0110\u00f3ng file &gt; M\u1edf l\u1ea1i file l\u00ean l\u00e0 c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng b\u00ecnh th\u01b0\u1eddng. Trong qu\u00e1 tr\u00ecnh ch\u1ea1y \u1ee9ng d\u1ee5ng Microsoft Excel \u0111\u00f4i khi x\u1ea3y ra l\u1ed7i n\u00e0y. Ch\u00fang ta c\u00f3 th\u1ec3 kh\u1edfi \u0111\u1ed9ng l\u1ea1i \u1ee9ng d\u1ee5ng \u0111\u1ec3 tr\u00e1nh l\u1ed7i.<\/li>\n<li><strong>C\u00e1ch th\u1ee9 2<\/strong>: G\u1ecdi ri\u00eang c\u00f4ng c\u1ee5 Freeze Panes \/ Unfreeze Panes ra ngo\u00e0i thanh c\u00f4ng c\u1ee5 b\u1eb1ng thao t\u00e1c Customize the Ribbon. Khi \u0111\u01b0a c\u00f4ng c\u1ee5 n\u00e0y ra ngo\u00e0i th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 m\u1ed9t c\u00e1ch tr\u1ef1c ti\u1ebfp m\u00e0 kh\u00f4ng c\u1ea7n m\u1edf nh\u00f3m c\u00f4ng c\u1ee5 Freeze Panes n\u1eefa.<\/li>\n<\/ul>\n<p>Xem chi ti\u1ebft t\u1ea1i: <a href=\"http:\/\/blog.ezworkapp.com\/quan-ly-thiet-lap-co-ban-voi-hop-thoai-excel-options.html\">H\u01b0\u1edbng d\u1eabn qu\u1ea3n l\u00fd thi\u1ebft l\u1eadp c\u01a1 b\u1ea3n v\u1edbi h\u1ed9p tho\u1ea1i Excel Options<\/a><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-149.gif\" title=\"ex101_92019-nho-149\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Chuc_nang_Freeze_Panes_hoat_dong_khong_nhu_mong_muon\"><\/span>Ch\u1ee9c n\u0103ng Freeze Panes\u00a0ho\u1ea1t \u0111\u1ed9ng kh\u00f4ng nh\u01b0 mong mu\u1ed1n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>T\u00ecnh tr\u1ea1ng n\u00e0y \u0111\u01b0\u1ee3c m\u00f4 t\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20555\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/loi-freeze-panes-chi-co-dinh-tieu-de-o-giua.png\" width=\"540\" height=\"279\" title=\"loi-freeze-panes-chi-co-dinh-tieu-de-o-giua\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_trang-2\"><\/span><strong>T\u00ecnh tr\u1ea1ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong b\u1ea3ng d\u1eef li\u1ec7u m\u00e0 ph\u1ea7n ti\u00eau \u0111\u1ec1 n\u1eb1m \u1edf v\u1ecb tr\u00ed kh\u00f4ng ph\u1ea3i d\u00f2ng 1, v\u00ed d\u1ee5 l\u00e0 \u1edf d\u00f2ng 6. Khi c\u1ed1 \u0111\u1ecbnh b\u1eb1ng Freeze Panes th\u00ec c\u1ed1 \u0111\u1ecbnh c\u1ea3 c\u00e1c d\u00f2ng t\u1eeb 1 \u0111\u1ebfn 6. Trong khi \u0111\u00f3 ch\u00fang ta ch\u1ec9 mu\u1ed1n c\u1ed1 \u0111\u1ecbnh d\u00f2ng 6 khi xem c\u00e1c n\u1ed9i dung b\u00ean d\u01b0\u1edbi, nh\u01b0ng kh\u00f4ng ph\u1ea3i \u1ea9n c\u00e1c d\u00f2ng t\u1eeb 1 \u0111\u1ebfn 5. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y Freeze Panes kh\u00f4ng \u0111\u1ea1t \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_khac_phuc-2\"><\/span><strong>C\u00e1ch kh\u1eafc ph\u1ee5c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u01b0\u1eddng h\u1ee3p n\u00e0y kh\u00f4ng s\u1eed d\u1ee5ng Freeze Panes \u0111\u01b0\u1ee3c. Thay v\u00e0o \u0111\u00f3 ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng t\u1edbi Table. C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng d\u1eef li\u1ec7u. C\u00f3 th\u1ec3 ch\u1ecdn nhi\u1ec1u h\u01a1n s\u1ed1 d\u00f2ng trong b\u1ea3ng \u0111\u1ec3 d\u1ef1 tr\u00f9 cho nh\u1eefng n\u1ed9i dung ph\u00e1t sinh th\u00eam<\/li>\n<li>B\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm Ctrl v\u00e0 ph\u00edm T (Ctrl + T) \u0111\u1ec3 chuy\u1ec3n b\u1ea3ng d\u1eef li\u1ec7u v\u1ec1 d\u1ea1ng Table trong Excel.<\/li>\n<li>Khi chuy\u1ec3n v\u1ec1 d\u1ea1ng Table, ph\u1ea7n ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea3ng s\u1ebd lu\u00f4n hi\u1ec3n th\u1ecb tr\u00ean thanh ti\u00eau \u0111\u1ec1, thay cho c\u00e1c t\u00ean c\u1ed9t A, B, C, D<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5 nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20556\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/co-dinh-tieu-de-theo-table.png\" width=\"635\" height=\"184\" title=\"co-dinh-tieu-de-theo-table\"><\/p>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-chuyen-doi-vung-du-lieu-thanh-bang-va-nguoc-lai-trong-excel.html\">C\u00e1ch chuy\u1ec3n \u0111\u1ed5i v\u00f9ng d\u1eef li\u1ec7u th\u00e0nh b\u1ea3ng v\u00e0 ng\u01b0\u1ee3c l\u1ea1i trong Excel<\/a><\/p>\n<p>Nh\u01b0 v\u1eady qua b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta \u0111\u00e3 c\u00f3 th\u1ec3 hi\u1ec3u th\u00eam v\u1ec1 c\u00f4ng c\u1ee5 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel-nhieu-cach-moi-hay-va-la.html\">Freeze Panes<\/a> c\u1ee7a Excel r\u1ed3i. Hy v\u1ecdng c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng nhi\u1ec1u h\u01a1n ch\u1ee9c n\u0103ng Freeze Panes v\u00e0 Table v\u00e0o c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y. N\u1ebfu c\u00f3 th\u1eafc m\u1eafc g\u00ec v\u1ec1 ki\u1ebfn th\u1ee9c n\u00e0y, b\u1ea1n \u0111\u1eebng ng\u1ea1i chia s\u1ebb c\u00f9ng H\u1ecdc Excel Online nh\u00e9.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam nhi\u1ec1u ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch kh\u00e1c khi tham gia kh\u00f3a h\u1ecdc <a href=\"http:\/\/bit.ly\/2LeBrQl\">Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao c\u1ee7a H\u1ecdc Excel Online<\/a>. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc r\u1ea5t b\u1ed5 \u00edch, gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong Excel, \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t h\u1ea5p d\u1eabn d\u00e0nh cho b\u1ea1n khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. 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\/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-149.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10270,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10269","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\/10269","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=10269"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10269\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10270"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}