{"id":1615,"date":"2024-12-02T05:32:58","date_gmt":"2024-12-02T05:32:58","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-tinh-nang-freeze-trong-bai-thi-mos-excel\/"},"modified":"2024-12-02T05:32:58","modified_gmt":"2024-12-02T05:32:58","slug":"cach-dung-tinh-nang-freeze-trong-bai-thi-mos-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-tinh-nang-freeze-trong-bai-thi-mos-excel\/","title":{"rendered":"C\u00e1ch d\u00f9ng t\u00ednh n\u0103ng Freeze trong b\u00e0i thi MOS Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>S\u1ebd l\u00e0 m\u1ed9t s\u1ef1 b\u1ea5t ti\u1ec7n v\u1edbi c\u00e1c d\u1eef li\u1ec7u d\u00e0i trong Excel khi b\u1ea1n c\u1ee9 ph\u1ea3i k\u00e9o xu\u1ed1ng r\u1ed3i k\u00e9o l\u00ean hay k\u00e9o sang \u0111\u1ec3 xem ti\u00eau \u0111\u1ec1 li\u1ec7u c\u00f3 b\u1ecb l\u1ec7ch d\u00f2ng hay c\u1ed9t kh\u00f4ng. V\u1edbi t\u00ednh n\u0103ng Freeze, v\u1ea5n \u0111\u1ec1 \u0111\u00f3 s\u1ebd \u0111\u01b0\u1ee3c gi\u1ea3i quy\u1ebft d\u1ec5 d\u00e0ng. H\u00e3y xem b\u00e0i vi\u1ebft b\u00ean d\u01b0\u1edbi:<\/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-674d46892daa2\" 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\/tinh-nang-freeze-trong-bai-thi-mos-excel.html#Tinh_nang_Freeze\" title=\"T\u00ednh n\u0103ng Freeze\">T\u00ednh n\u0103ng Freeze<\/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\/tinh-nang-freeze-trong-bai-thi-mos-excel.html#Su_dung_tinh_nang_Freeze\" title=\"S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Freeze\">S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Freeze<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_nang_Freeze\"><\/span><strong>T\u00ednh n\u0103ng Freeze<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Freeze cho ph\u00e9p c\u1ed1 \u0111\u1ecbnh h\u00e0ng ho\u1eb7c c\u1ed9t d\u1eef li\u1ec7u nh\u1eb1m ph\u1ee5c v\u1ee5 nhu c\u1ea7u \u0111\u01b0\u1ee3c nh\u00ecn m\u1ed9t c\u00e1ch tr\u1ef1c quan c\u1ee7a ng\u01b0\u1eddi s\u1eed d\u1ee5ng. Sau khi c\u1ed1 \u0111\u1ecbnh, d\u00f9 d\u1eef li\u1ec7u c\u00f3 tr\u00e0n xu\u1ed1ng hay sang th\u00ec ph\u1ea7n \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh v\u1eabn lu\u00f4n hi\u1ec3n th\u1ecb tr\u00ean m\u00e0n h\u00ecnh trang t\u00ednh.<\/p>\n<p>V\u1ecb tr\u00ed: T\u1ea1i th\u1ebb <strong>View <\/strong>tr\u00ean th\u00e0nh Ribbon, trong nh\u00f3m <strong>Window<\/strong>, ch\u1ecdn <strong>Freeze Panes.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20710\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/mos-excel-2010-freeze-panes.png\" alt=\"t\u00ednh n\u0103ng freeze\" width=\"649\" height=\"118\" title=\"mos-excel-2010-freeze-panes\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_tinh_nang_Freeze\"><\/span><strong>S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Freeze<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><em>\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh h\u00e0ng \u0111\u1ea7u ti\u00ean ho\u1eb7c c\u1ed9t \u0111\u1ea7u ti\u00ean:<\/em><\/p>\n<p>T\u1ea1i nh\u00f3m <strong>Window<\/strong>, ch\u1ecdn <strong>Freeze Panes<\/strong>, ch\u1ecdn <strong>Freeze Top Row<\/strong> \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh h\u00e0ng \u0111\u1ea7u ti\u00ean,\u00a0<strong>Freeze First Column<\/strong> \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean.<\/p>\n<figure id=\"attachment_20711\" aria-describedby=\"caption-attachment-20711\" style=\"width: 459px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20711\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/mos-excel-2010-freeze.png\" width=\"459\" height=\"269\" title=\"mos-excel-2010-freeze\"><figcaption id=\"caption-attachment-20711\" class=\"wp-caption-text\">Freeze Top Row v\u00e0 Freeze First Column<\/figcaption><\/figure>\n<p><em>\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u h\u00e0ng ho\u1eb7c c\u1ed9t:<\/em><\/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-116.gif\" title=\"ex101_92019-nho-116\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol>\n<li>Ch\u1ecdn h\u00e0ng <strong>b\u00ean d\u01b0\u1edbi <\/strong>c\u00e1c h\u00e0ng ho\u1eb7c c\u1ed9t <strong>b\u00ean ph\u1ea3i<\/strong> c\u00e1c c\u1ed9t c\u1ea7n c\u1ed1 \u0111\u1ecbnh.<\/li>\n<li>Ch\u1ecdn <strong>Freeze Panes <\/strong>\u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh.<\/li>\n<\/ol>\n<figure id=\"attachment_20716\" aria-describedby=\"caption-attachment-20716\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-20716\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/mos-excel-2010-freeze-row-1024x399-1.png\" width=\"1024\" height=\"399\" title=\"mos-excel-2010-freeze-row-1024x399-1\"><figcaption id=\"caption-attachment-20716\" class=\"wp-caption-text\">C\u1ed1 \u0111\u1ecbnh h\u00e0ng b\u1eb1ng Freeze Panes<\/figcaption><\/figure>\n<p><em>\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh \u0111\u1ed3ng th\u1eddi c\u1ea3 h\u00e0ng v\u00e0 c\u1ed9t:<\/em><\/p>\n<ol>\n<li>Ch\u1ecdn \u00f4 b\u00ean d\u01b0\u1edbi, ph\u00eda b\u00ean ph\u1ea3i h\u00e0ng v\u00e0 c\u1ed9t mu\u1ed1n c\u1ed1 \u0111\u1ecbnh.<\/li>\n<li>Ch\u1ecdn <strong>Freeze Panes<\/strong> \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh.<\/li>\n<\/ol>\n<figure id=\"attachment_20718\" aria-describedby=\"caption-attachment-20718\" style=\"width: 954px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20718\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/mos-excel-2010-free-column.png\" width=\"954\" height=\"469\" title=\"mos-excel-2010-free-column\"><figcaption id=\"caption-attachment-20718\" class=\"wp-caption-text\">C\u1ed1 \u0111\u1ecbnh \u0111\u1ed3ng th\u1eddi h\u00e0ng v\u00e0 c\u1ed9t<\/figcaption><\/figure>\n<p><em>\u0110\u1ec3 b\u1ecf c\u1ed1 \u0111\u1ecbnh h\u00e0ng v\u00e0 c\u1ed9t:<\/em><\/p>\n<p>Sau khi \u0111\u00e3 c\u1ed1 \u0111\u1ecbnh, ch\u1ee9c n\u0103ng <strong>Freeze Panes<\/strong>\u00a0chuy\u1ec3n th\u00e0nh <strong>Unfreeze Panes. <\/strong>Click \u0111\u1ec3 b\u1ecf c\u1ed1 \u0111\u1ecbnh h\u00e0ng v\u00e0 c\u1ed9t.<\/p>\n<figure id=\"attachment_20719\" aria-describedby=\"caption-attachment-20719\" style=\"width: 404px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20719\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/mos-excel-2010-unfreeze.png\" width=\"404\" height=\"271\" title=\"mos-excel-2010-unfreeze\"><figcaption id=\"caption-attachment-20719\" class=\"wp-caption-text\">Unfreeze Panes<\/figcaption><\/figure>\n<p><strong>Xem th\u00eam<\/strong>: <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 v\u00e0 c\u1ed9t n\u00e2ng cao<\/a><\/p>\n<p>Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng? Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng Hocexcel.online. V\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo nh\u00e9!<\/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-116.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1616,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1615","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\/1615","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=1615"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1615\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1616"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}