{"id":9222,"date":"2025-01-01T22:07:29","date_gmt":"2025-01-01T22:07:29","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-co-dinh-cot-trong-excel\/"},"modified":"2025-01-01T22:07:29","modified_gmt":"2025-01-01T22:07:29","slug":"huong-dan-co-dinh-cot-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-co-dinh-cot-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>C\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel (v\u00e0 c\u1ea3 c\u1ed1 \u0111\u1ecbnh h\u00e0ng) l\u00e0 thao t\u00e1c gi\u00fap \u0111em l\u1ea1i m\u1ed9t c\u00e1i nh\u00ecn tr\u1ef1c quan h\u01a1n cho s\u1ed5 t\u00ednh, \u0111\u1ed3ng th\u1eddi r\u1ea5t c\u00f3 \u00edch khi b\u1ea1n c\u1ea7n quan s\u00e1t ti\u00eau \u0111\u1ec1 c\u1ee7a nh\u1eefng b\u1ea3ng t\u00ednh d\u00e0i.<\/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-6775bca06a941\" 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\/co-dinh-cot-trong-excel.html#Co_dinh_cot_va_hang_bang_Freeze_Panes\" title=\"C\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 h\u00e0ng b\u1eb1ng Freeze Panes\">C\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 h\u00e0ng b\u1eb1ng 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\/co-dinh-cot-trong-excel.html#Co_dinh_cot_trong_Excel_voi_Split\" title=\"C\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel v\u1edbi Split\">C\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel v\u1edbi Split<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Co_dinh_cot_va_hang_bang_Freeze_Panes\"><\/span>C\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 h\u00e0ng b\u1eb1ng Freeze Panes<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u1ee9c n\u0103ng Freeze Panes s\u1ebd cho ph\u00e9p ta \u201c\u0111\u00f3ng b\u0103ng\u201d h\u00e0ng ho\u1eb7c c\u1ed9t d\u1eef li\u1ec7u. \u0110i\u1ec1u n\u00e0y s\u1ebd r\u1ea5t ti\u1ec7n n\u1ebfu ta c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u d\u00e0i v\u00e0 ta c\u1ea7n theo d\u00f5i ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea3ng \u0111\u00f3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25225\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/co-dinh-cot-1.png\" width=\"502\" height=\"273\" title=\"co-dinh-cot-1\"><\/p>\n<p>V\u1edbi ch\u1ee9c n\u0103ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/tinh-nang-freeze-trong-bai-thi-mos-excel.html\">Freeze Pane<\/a><\/strong><strong>s<\/strong>, ta c\u00f3 3 l\u1ef1a ch\u1ecdn sau:<\/p>\n<p><strong>Freeze Panes:\u00a0<\/strong>c\u1ed1 \u0111\u1ecbnh \u0111\u1ed3ng th\u1eddi c\u1ea3 c\u1ed9t v\u00e0 h\u00e0ng. Ph\u1ea7n c\u1ed9t b\u1ecb c\u1ed1 \u0111\u1ecbnh \u1edf b\u00ean tr\u00e1i v\u00e0 ph\u00eda tr\u00ean s\u1ebd kh\u00f4ng di chuy\u1ec3n \u0111\u01b0\u1ee3c.<\/p>\n<p><strong>Freeze Top Row<\/strong>: c\u1ed1 \u0111\u1ecbnh h\u00e0ng \u0111\u1ea7u ti\u00ean trong trang t\u00ednh.<\/p>\n<p><strong>Freeze First Column<\/strong>: c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean trong trang t\u00ednh<\/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-24.gif\" title=\"ex101_92019-nho-24\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh m\u1ed9t s\u1ed1 c\u1ed9t trong b\u1ea3ng t\u00ednh, ta \u0111\u1eb7t v\u1ecb tr\u00ed \u00f4 l\u00ean d\u00f2ng \u0111\u1ea7u ti\u00ean, sau \u0111\u00f3 \u0111\u1eb7t v\u00e0o c\u1ed9t li\u1ec1n k\u1ec1 b\u00ean ph\u1ea3i c\u1ed9t cu\u1ed1i c\u00f9ng trong danh s\u00e1ch mu\u1ed1n c\u1ed1 \u0111\u1ecbnh.<\/p>\n<p>V\u00ed d\u1ee5: \u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh 3 c\u1ed9t A, B, C, ta ch\u1ecdn \u00f4 D1, sau \u0111\u00f3 \u1ea5n\u00a0<strong>Freeze Panes.<\/strong> K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25226\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/co-dinh-cot-2.png\" width=\"290\" height=\"304\" title=\"co-dinh-cot-2\"><\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 \u0111\u1ed1i v\u1edbi c\u1ed1 \u0111\u1ecbnh h\u00e0ng, ta \u0111\u1eb7t v\u1ecb tr\u00ed \u00f4 v\u00e0o c\u1ed9t \u0111\u1ea7u ti\u00ean, li\u1ec1n d\u01b0\u1edbi \u00f4 cu\u1ed1i c\u00f9ng trong danh s\u00e1ch r\u1ed3i \u1ea5n\u00a0<strong>Freeze Panes<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25227\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/co-dinh-cot-3.png\" width=\"281\" height=\"208\" title=\"co-dinh-cot-3\"><\/p>\n<p>L\u01b0u \u00fd: Thao t\u00e1c\u00a0<strong>Freeze Panes<\/strong> kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n nhi\u1ec1u l\u1ea7n cho nhi\u1ec1u v\u00f9ng kh\u00e1c nhau m\u00e0 ch\u1ec9 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng cho m\u1ed9t v\u00f9ng. N\u1ebfu b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh \u0111\u1ed3ng th\u1eddi h\u00e0ng v\u00e0 c\u1ed9t, h\u00e3y ch\u1ecdn v\u1ecb tri \u00f4 n\u1eb1m ph\u00eda d\u01b0\u1edbi, b\u00ean ph\u1ea3i h\u00e0ng v\u00e0 c\u1ed9t c\u1ea7n c\u1ed1 \u0111\u1ecbnh.<\/p>\n<p>V\u00ed d\u1ee5, \u0111\u1ec3 c\u1ed1 \u0111inh 8 h\u00e0ng v\u00e0 3 c\u1ed9t, ta t\u00ecm \u0111\u1ebfn giao \u0111i\u1ec3m:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25228\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/co-dinh-cot-4.png\" width=\"294\" height=\"210\" title=\"co-dinh-cot-4\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Co_dinh_cot_trong_Excel_voi_Split\"><\/span>C\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel v\u1edbi Split<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u1ee9c n\u0103ng <a href=\"http:\/\/blog.ezworkapp.com\/chuc-nang-split-arrange-hide-unhide.html\"><strong>Split<\/strong><\/a> s\u1ebd chia trang t\u00ednh c\u1ee7a b\u1ea1n th\u00e0nh c\u00e1c ph\u1ea7n, t\u01b0\u01a1ng t\u1ef1 nh\u01b0 vi\u1ec7c chia m\u00e0n h\u00ecnh m\u00e1y t\u00ednh v\u1eady. Kh\u00f4ng ch\u1ec9 c\u1ed1 \u0111\u1ecbnh m\u00e0 b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp \u0111\u1ec3 c\u00f3 m\u1ed9t ch\u1ebf \u0111\u1ed9 nh\u00ecn t\u1ed1t nh\u1ea5t<\/p>\n<figure id=\"attachment_25229\" aria-describedby=\"caption-attachment-25229\" style=\"width: 343px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25229\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/co-dinh-cot-5.png\" width=\"343\" height=\"127\" title=\"co-dinh-cot-5\"><figcaption id=\"caption-attachment-25229\" class=\"wp-caption-text\">th\u1ebb view, nh\u00f3m window<\/figcaption><\/figure>\n<p>T\u01b0\u01a1ng t\u1ef1 Freeze Panes, \u0111\u1ec3 chia t\u00e1ch h\u00e0ng v\u00e0 c\u1ed9t, ta \u0111\u1eb7t v\u1ecb tr\u00ed \u00f4 v\u00e0o b\u00ean ph\u1ea3i, ph\u00eda d\u01b0\u1edbi v\u00f9ng mu\u1ed1n chia.<\/p>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25230\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/co-dinh-cot-6.png\" width=\"333\" height=\"227\" title=\"co-dinh-cot-6\"><\/p>\n<p>\u00a0<\/p>\n<p>Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft li\u00ean quan t\u1edbi thao t\u00e1c v\u1edbi c\u1ed9t v\u00e0 h\u00e0ng t\u1ea1i \u0111\u00e2y:<\/p>\n<p><strong>C\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel-nhieu-cach-moi-hay-va-la.html\">c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong excel<\/a>, \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/chuyen-mot-cot-thanh-nhieu-cot-bang-cong-thuc.html\"><strong>Chuy\u1ec3n m\u1ed9t c\u1ed9t th\u00e0nh nhi\u1ec1u c\u1ed9t b\u1eb1ng c\u00f4ng th\u1ee9c Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/nhan-mot-cot-voi-mot-so-co-dinh-trong-excel.html\"><strong>Nh\u00e2n m\u1ed9t c\u1ed9t v\u1edbi m\u1ed9t s\u1ed1 trong Excel<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/doi-vi-tri-cot-trong-excel-2-cach.html\">C\u00e1ch \u0111\u1ed5i v\u1ecb tr\u00ed c\u1ed9t<\/a><\/strong><\/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-24.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9223,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9222","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\/9222","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=9222"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9222\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9223"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}