{"id":9764,"date":"2025-01-02T21:18:18","date_gmt":"2025-01-02T21:18:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-dong-bang-cot-trong-excel\/"},"modified":"2025-01-02T21:18:18","modified_gmt":"2025-01-02T21:18:18","slug":"huong-dan-cach-dong-bang-cot-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-dong-bang-cot-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u00f3ng b\u0103ng c\u1ed9t trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p x\u1eed l\u00ed d\u1eef li\u1ec7u, vi\u1ec7c c\u1ed1 \u0111\u1ecbnh c\u1ed9t s\u1ebd gi\u00fap b\u1ea1n lu\u00f4n nh\u00ecn th\u1ea5y d\u1eef li\u1ec7u ti\u00eau \u0111\u1ec1 m\u1ed7i khi di chuy\u1ec3n sang b\u00ean. C\u1ee5 th\u1ec3, h\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y. H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u00f3ng b\u0103ng c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t.<\/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-67770299d73cf\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dong-bang-cot-trong-excel.html#Tinh_nang_Freeze_Panes\" title=\"T\u00ednh n\u0103ng Freeze Panes\">T\u00ednh n\u0103ng Freeze Panes<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dong-bang-cot-trong-excel.html#Su_dung_Freeze_Panes_dong_bang_cot_trong_Excel_theo_2_cach\" title=\"S\u1eed d\u1ee5ng Freeze Panes\u00a0\u0111\u00f3ng b\u0103ng c\u1ed9t trong Excel theo 2 c\u00e1ch\">S\u1eed d\u1ee5ng Freeze Panes\u00a0\u0111\u00f3ng b\u0103ng c\u1ed9t trong Excel theo 2 c\u00e1ch<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_nang_Freeze_Panes\"><\/span>T\u00ednh n\u0103ng Freeze Panes<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Freeze Panes\u00a0<\/strong>cho ph\u00e9p \u201c\u0111\u00f3ng b\u0103ng\u201d, hay ch\u00ednh x\u00e1c h\u01a1n ch\u1ee9c n\u0103ng n\u00e0y gi\u00fap c\u1ed1 \u0111\u1ecbnh m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u n\u1eb1m\u00a0<strong>b\u00ean tr\u00e1i, ph\u00eda tr\u00ean<\/strong>\u00a0<strong>\u00f4 \u0111\u00e3 ch\u1ecdn<\/strong>. Khi \u0111\u00f3, v\u00f9ng \u0111\u01b0\u1ee3c \u0111\u00f3ng b\u0103ng s\u1ebd lu\u00f4n c\u1ed1 \u0111\u1ecbnh m\u1ed7i khi ta cu\u1ed9n trang t\u00ednh.<\/p>\n<figure id=\"attachment_23572\" aria-describedby=\"caption-attachment-23572\" style=\"width: 921px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-23572\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/freeze-column-1.png\" width=\"921\" height=\"359\" title=\"freeze-column-1\"><figcaption id=\"caption-attachment-23572\" class=\"wp-caption-text\">\u1ee8ng d\u1ee5ng c\u1ee7a freeze pane, c\u1ed9t t\u1eeb A-H \u00e0 d\u00f2ng 1-10 \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean<\/figcaption><\/figure>\n<p>V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t?<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_Freeze_Panes_dong_bang_cot_trong_Excel_theo_2_cach\"><\/span>S\u1eed d\u1ee5ng Freeze Panes\u00a0\u0111\u00f3ng b\u0103ng c\u1ed9t trong Excel theo 2 c\u00e1ch<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 \u0111\u00f3ng b\u0103ng c\u1ed9t trong Excel v\u1edbi Freeze Panes, ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng 1 trong 2 c\u00e1ch sau \u0111\u00e2y:<\/p>\n<p>1. T\u00ednh n\u0103ng \u201c<strong>Freeze First Column\u201d\u00a0<\/strong>\u0111\u00f3ng b\u0103ng c\u1ed9t \u0111\u1ea7u ti\u00ean<\/p>\n<p><strong>Freeze First Column\u00a0<\/strong>gi\u00fap ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a trang t\u00ednh (c\u1ed9t A). Vi\u1ec7c n\u00e0y r\u1ea5t h\u1eefu d\u1ee5ng khi b\u1ea1n c\u00f3 m\u1ed9t ti\u00eau \u0111\u1ec1 c\u1ed9t v\u00e0 mu\u1ed1n \u0111\u1ed1i chi\u1ebfu tr\u1ef1c quan trong b\u1ea3ng d\u00e0i.<\/p>\n<figure id=\"attachment_23574\" aria-describedby=\"caption-attachment-23574\" style=\"width: 592px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-23574\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/freeze-column-2.png\" width=\"592\" height=\"286\" title=\"freeze-column-2\"><figcaption id=\"caption-attachment-23574\" class=\"wp-caption-text\">Freeze First Column<\/figcaption><\/figure>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng n\u00e0y, v\u00e0o th\u1ebb\u00a0<strong>View<\/strong>. Trong ch\u1ee9c n\u0103ng\u00a0<strong>Freeze Panes<\/strong>, ch\u1ecdn\u00a0<strong>Freeze First Column.<\/strong><\/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-88.gif\" title=\"ex101_92019-nho-88\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>2. S\u1eed d\u1ee5ng\u00a0<strong>Freeze Panes<\/strong> t\u1ea1i \u00f4\u00a0<strong>B2.<\/strong><\/p>\n<p>M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean, \u0111\u00f3 l\u00e0 ta s\u1ebd\u00a0<strong>c\u1ed1 \u0111\u1ecbnh c\u1ed9t<\/strong> v\u00e0\u00a0<strong>kh\u00f4ng c\u1ed1 \u0111\u1ecbnh h\u00e0ng<\/strong>. \u0110i\u1ec1u \u0111\u00f3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch ch\u1ecdn \u00f4\u00a0<strong>B2\u00a0<\/strong>nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23575\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/freeze-column-3.png\" width=\"954\" height=\"420\" title=\"freeze-column-3\"><\/p>\n<p>\u0110\u1eb7c bi\u1ec7t, v\u1edbi c\u00e1ch l\u00e0m n\u00e0y, ta c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u00f9ng l\u00fac nhi\u1ec1u c\u1ed9t t\u1eeb c\u1ed9t \u0111\u1ea7u ti\u00ean. R\u1ea5t ti\u1ec7n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>V\u00e0 kh\u00f4ng ch\u1ec9 c\u1ed9t \u0111\u00e2u, Freeze Panes c\u00f2n h\u1ed7 tr\u1ee3 vi\u1ec7c c\u1ed1 \u0111\u1ecbnh h\u00e0ng n\u1eefa \u0111\u00f3. D\u1ef1a v\u00e0o ki\u1ebfn th\u1ee9c ph\u1ea7n tr\u00ean, c\u00e1c b\u1ea1n h\u00e3y th\u1eed suy ngh\u0129 v\u00e0 t\u00ecm l\u1eddi gi\u1ea3i cho c\u00e2u h\u1ecfi: L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u201c\u0111\u00f3ng b\u0103ng\u201d h\u00e0ng trong Excel?<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t.<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/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-88.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9765,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9764","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\/9764","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=9764"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9764\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9765"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}