{"id":2449,"date":"2024-12-02T07:50:19","date_gmt":"2024-12-02T07:50:19","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/thu-thuat-co-dinh-dong-co-dinh-cot-trong-excel\/"},"modified":"2024-12-02T07:50:19","modified_gmt":"2024-12-02T07:50:19","slug":"thu-thuat-co-dinh-dong-co-dinh-cot-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/thu-thuat-co-dinh-dong-co-dinh-cot-trong-excel\/","title":{"rendered":"Th\u1ee7 thu\u1eadt c\u1ed1 \u0111\u1ecbnh d\u00f2ng, c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><i>L\u00e0m vi\u1ec7c v\u1edbi Excel, m\u00ecnh lu\u00f4n ph\u1ea3i \u0111\u1ed1i m\u1eb7t v\u1edbi nh\u1eefng b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn v\u00e0 khi \u0111\u00f3 ch\u1eafc ch\u1eafn s\u1ebd g\u1eb7p nh\u1eefng v\u01b0\u1edbng m\u1eafc. Ch\u1eb3ng h\u1ea1n, khi xem d\u1eef li\u1ec7u \u1edf nh\u1eefng c\u1ed9t b\u00ean d\u01b0\u1edbi, ta s\u1ebd kh\u00f4ng th\u1ec3 n\u00e0o h\u00ecnh dung \u0111\u01b0\u1ee3c \u00fd ngh\u0129a c\u1ee7a n\u00f3 l\u00e0 g\u00ec. V\u00ec th\u1ebf \u0111\u1ec3 gi\u1ea3i quy\u1ebft \u0111i\u1ec1u n\u00e0y m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, \u00a0m\u00ecnh th\u01b0\u1eddng th\u1ef1c hi\u1ec7n m\u1ed9t s\u1ed1 b\u01b0\u1edbc \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh th\u00f4ng tin ngu\u1ed3n th\u01b0\u1eddng l\u00e0 <\/i><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel-nhieu-cach-moi-hay-va-la.html\"><strong><i>c\u1ed1 \u0111\u1ecbnh d\u00f2ng, c\u1ed9t<\/i><\/strong><\/a><i><strong>\u00a0<\/strong>\u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng. <\/i><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">Do \u0111\u00f3, b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y m\u00ecnh s\u1ebd chia s\u1ebb chi ti\u1ebft c\u00e1ch <\/span><b>c\u1ed1 \u0111\u1ecbnh d\u00f2ng<\/b><span style=\"font-weight: 400\"> v\u00e0 c\u1ed9t trong Excel 2010:<\/span><\/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-674d66ba5224f\" 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\/thu-thuat-co-dinh-dong-co-dinh-cot-trong-excel.html#Co_dinh_dong\" title=\"C\u1ed1 \u0111\u1ecbnh d\u00f2ng\">C\u1ed1 \u0111\u1ecbnh d\u00f2ng<\/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\/thu-thuat-co-dinh-dong-co-dinh-cot-trong-excel.html#Co_dinh_cot\" title=\"C\u1ed1 \u0111\u1ecbnh c\u1ed9t\">C\u1ed1 \u0111\u1ecbnh c\u1ed9t<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Co_dinh_dong\"><\/span><strong>C\u1ed1 \u0111\u1ecbnh d\u00f2ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u2013 X\u00e1c \u0111\u1ecbnh d\u00f2ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh l\u00e0 \u0111i\u1ec1u quan tr\u1ecdng \u0111\u1ea7u ti\u00ean.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u2013 Di chuy\u1ec3n chu\u1ed9t v\u00e0 \u0111\u1eb7t con tr\u1ecf chu\u1ed9t \u1edf \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a d\u00f2ng n\u1eb1m ph\u00eda d\u01b0\u1edbi d\u00f2ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh.<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3106 size-full aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-1.png\" width=\"600\" height=\"381\" title=\"1-1\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u2013 Ch\u1ecdn<\/span><b> View<\/b><span style=\"font-weight: 400\"> -&gt; <\/span><b>Freeze Panes<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3107 size-full aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-2-1.png\" width=\"600\" height=\"318\" title=\"1-2-1\"><\/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\/2024\/12\/ex101_92019-nho-189.gif\" title=\"ex101_92019-nho-189\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u2013 Sau khi \u0111\u01b0\u1ee3c <\/span><b>c\u1ed1 \u0111\u1ecbnh d\u00f2ng<\/b><span style=\"font-weight: 400\">, b\u1ea1n ch\u1ec9 c\u1ea7n k\u00e9o chu\u1ed9t di chuy\u1ec3n xu\u1ed1ng m\u1ed9t v\u00e0i d\u00f2ng b\u00ean d\u01b0\u1edbi th\u00ec d\u00f2ng ti\u00eau \u0111\u1ec1 v\u00e0 c\u00e1c thu\u1ed9c t\u00ednh c\u1ee7a c\u1ed9t v\u1eabn \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb \u0111\u1ea7y \u0111\u1ee7. \u0110i\u1ec1u n\u00e0y gi\u00fap quan s\u00e1t d\u1eef li\u1ec7u \u1edf nh\u1eefng d\u00f2ng b\u00ean d\u01b0\u1edbi \u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n.<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3108 size-full aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-3.png\" width=\"600\" height=\"320\" title=\"1-3\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">* N\u1ebfu kh\u00f4ng s\u1eed d\u1ee5ng <\/span><b>Freeze Panes, <\/b><span style=\"font-weight: 400\">ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 ch\u1ecdn v\u00e0o <\/span><b>Freeze Top Row<\/b><span style=\"font-weight: 400\"> c\u0169ng \u0111\u01b0\u1ee3c.<\/span><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Co_dinh_cot\"><\/span><b>C\u1ed1 \u0111\u1ecbnh c\u1ed9t<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u2013 T\u01b0\u01a1ng t\u1ef1 nh\u01b0 <\/span><b>c\u1ed1 \u0111\u1ecbnh d\u00f2ng<\/b><span style=\"font-weight: 400\">, \u0111\u1ea7u ti\u00ean, b\u1ea1n c\u0169ng c\u1ea7n x\u00e1c \u0111\u1ecbnh c\u1ed9t c\u1ea7n c\u1ed1 \u0111\u1ecbnh.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u2013 X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed \u0111\u1eb7t con tr\u1ecf chu\u1ed9t, th\u01b0\u1eddng c\u00f3 2 c\u00e1ch:<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">+ C\u00e1ch 1: \u0110\u1eb7t con tr\u1ecf chu\u1ed9t t\u1ea1i v\u1ecb tr\u00ed \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t sau c\u1ed9t \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh <\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">+ C\u00e1ch 2:<\/span> <span style=\"font-weight: 400\">B\u00f4i \u0111en to\u00e0n b\u1ed9 c\u1ed9t sau c\u1ed9t \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh.<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3110 size-full aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-4.png\" width=\"600\" height=\"377\" title=\"1-4\"><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">\u2013 <\/span><b>\u00a0<\/b><span style=\"font-weight: 400\">Ch\u1ecdn <\/span><b>View<\/b><span style=\"font-weight: 400\"> -&gt; <\/span><b>Freeze Panes<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<p style=\"text-align: justify\"><span style=\"font-weight: 400\">* N\u1ebfu mu\u1ed1n c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean thay v\u00ec ch\u1ecdn <\/span><b>Freeze Panes<\/b><span style=\"font-weight: 400\"> ta ch\u1ecdn <\/span><b>Freeze First Column<\/b><span style=\"font-weight: 400\">.<\/span><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3111 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-5.png\" width=\"600\" height=\"309\" title=\"1-5\"><\/p>\n<p style=\"text-align: justify\"><b><\/b>Excel lu\u00f4n c\u00f3 c\u00e1c c\u00f4ng c\u1ee5 gi\u00fap b\u1ea1n x\u1eed l\u00fd b\u1ea5t k\u1ef3 vi\u1ec7c g\u00ec. \u0110\u1ec3 th\u00e0nh th\u1ea1o Excel, ngo\u00e0i c\u00e1c c\u00f4ng c\u1ee5 x\u1eed l\u00fd th\u00ec b\u1ea1n ph\u1ea3i s\u1eed d\u1ee5ng c\u00e1c h\u00e0m m\u01b0\u1ee3t m\u00e0.<\/p>\n<p>Blog Ho\u0323c Excel Online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a> v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u1ec7u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o c\u00e1c c\u00f4ng c\u1ee5 Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u1ea7n tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a><\/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\/2024\/12\/ex101_92019-nho-189.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2450,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2449","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\/2449","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=2449"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2449\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2450"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}