{"id":6842,"date":"2024-12-21T16:18:33","date_gmt":"2024-12-21T16:18:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel-cach-moi-va-hieu-qua\/"},"modified":"2024-12-21T16:18:33","modified_gmt":"2024-12-21T16:18:33","slug":"huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel-cach-moi-va-hieu-qua","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel-cach-moi-va-hieu-qua\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e2ng cao trong Excel, C\u00e1ch M\u1edbi v\u00e0 Hi\u1ec7u qu\u1ea3"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"c\u1ed1-\u0111\u1ecbnh-c\u1ed9t-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel-nhieu-cach-moi-hay-va-la.html?co-dinh-cot-trong-excel\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a>\u00a0<\/strong>s\u1ebd h\u01b0\u1edbng d\u1eabn cho c\u00e1c b\u1ea1n <strong>c\u1ed1 \u0111\u1ecbnh d\u00f2ng c\u1ed9t Excel<\/strong> hay <span class=\"keyword _ngcontent-bzk-106\" aria-hidden=\"false\"><strong>freeze panes<\/strong>\u00a0<\/span>trong Excel m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n m\u00e0 hi\u1ec7u qu\u1ea3. <\/em><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">B\u1ea1n s\u1ebd bi\u1ebft c\u00e1ch kh\u00f3a d\u00f2ng ho\u1eb7c c\u1ed9t ti\u00eau \u0111\u1ec1 m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. B\u1ea1n c\u0169ng s\u1ebd bi\u1ebft c\u00e1ch c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u khung m\u1ed9t l\u00fac \u0111\u1ec3 l\u00e0m cho Excel lu\u00f4n hi\u1ec3n th\u1ecb c\u00e1c h\u00e0ng v\u00e0 \/ ho\u1eb7c c\u1ed9t nh\u1ea5t \u0111\u1ecbnh khi b\u1ea1n cu\u1ed9n xu\u1ed1ng ho\u1eb7c k\u00e9o qua ph\u1ea3i. C\u00e1c m\u1eb9o n\u00e0y c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n hi\u1ec7n \u0111\u1ea1i c\u1ee7a Excel 2019, 2016, 2013, 2010 v\u00e0 2007.<\/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-6766ea588ae53\" 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-co-dinh-dong-va-cot-nang-cao-trong-excel.html#Lam_the_nao_de_co_dinh_dong_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel:<\/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-co-dinh-dong-va-cot-nang-cao-trong-excel.html#1_Lam_the_nao_de_dong_bang_dong_dau_trong_Excel\" title=\"1. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u00f3ng b\u0103ng d\u00f2ng \u0111\u1ea7u trong Excel:\">1. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u00f3ng b\u0103ng d\u00f2ng \u0111\u1ea7u trong Excel:<\/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-co-dinh-dong-va-cot-nang-cao-trong-excel.html#2_Lam_the_nao_de_co_dinh_nhieu_dong_Excel\" title=\"2. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng Excel\">2. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng Excel<\/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-co-dinh-dong-va-cot-nang-cao-trong-excel.html#Lam_the_nao_de_co_dinh_cot_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel:<\/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-co-dinh-dong-va-cot-nang-cao-trong-excel.html#1_Co_dinh_cot_dau_tien_trong_mot_bang_tinh\" title=\"1. C\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean trong m\u1ed9t b\u1ea3ng t\u00ednh:\">1. C\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean trong m\u1ed9t b\u1ea3ng t\u00ednh:<\/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-co-dinh-dong-va-cot-nang-cao-trong-excel.html#2_Lam_the_nao_de_co_dinh_nhieu_cot_trong_Excel\" title=\"2. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t trong Excel\">2. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel.html#3_Co_dinh_cot_trong_Excel_voi_Split\" title=\"3. C\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel v\u1edbi Split\">3. C\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel v\u1edbi Split<\/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-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel.html#Lam_the_nao_de_co_dinh_nhieu_vung_trong_Excel_cac_hang_va_cot\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u v\u00f9ng trong Excel (c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t):\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u v\u00f9ng trong Excel (c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t):<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel.html#Lam_the_nao_de_xoa_bo_co_dinh_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 x\u00f3a b\u1ecf c\u1ed1 \u0111\u1ecbnh trong Excel:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 x\u00f3a b\u1ecf c\u1ed1 \u0111\u1ecbnh trong Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel.html#Meo_khi_su_dung_Excel_Freeze_Panes\" title=\"M\u1eb9o khi s\u1eed d\u1ee5ng Excel Freeze Panes\">M\u1eb9o khi s\u1eed d\u1ee5ng Excel 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-11\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel.html#1_Truoc_khi_thuc_hien_Tranh_hangcot_bi_an\" title=\"1. Tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n: Tr\u00e1nh h\u00e0ng\/c\u1ed9t b\u1ecb \u1ea9n\">1. Tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n: Tr\u00e1nh h\u00e0ng\/c\u1ed9t b\u1ecb \u1ea9n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel.html#2_Excel_co_the_co_dinh_bang_hoan_toan_khac_voi_nhung_gi_ban_mong_doi\" title=\"2. Excel c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh b\u1ea3ng ho\u00e0n to\u00e0n kh\u00e1c v\u1edbi nh\u1eefng g\u00ec b\u1ea1n mong \u0111\u1ee3i\">2. Excel c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh b\u1ea3ng ho\u00e0n to\u00e0n kh\u00e1c v\u1edbi nh\u1eefng g\u00ec b\u1ea1n mong \u0111\u1ee3i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel.html#3_Meo_Lam_the_nao_de_nguy_trang_dong_Freeze_Panes\" title=\"3. M\u1eb9o: L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ng\u1ee5y trang d\u00f2ng Freeze Panes:\">3. M\u1eb9o: L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ng\u1ee5y trang d\u00f2ng Freeze Panes:<\/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-14\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel.html#Huong_dan_cach_sua_cac_loi_lien_quan_toi_co_dinh_bang_tinh_bang_Freeze_Panes\" title=\"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\">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<\/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-15\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel.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-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel.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-4\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel.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-3\"><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel.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-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel.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-4\"><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel.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<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_co_dinh_dong_trong_Excel\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Th\u00f4ng th\u01b0\u1eddng, b\u1ea1n s\u1ebd mu\u1ed1n\u00a0 <strong>c\u1ed1 \u0111\u1ecbnh d\u00f2ng \u0111\u1ea7u ti\u00ean trong excel<\/strong> \u0111\u1ec3 xem ti\u00eau \u0111\u1ec1 c\u1ed9t khi b\u1ea1n k\u00e9o trang t\u00ednh xu\u1ed1ng. Nh\u01b0ng \u0111\u00f4i khi b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n ch\u1ee9a th\u00f4ng tin quan tr\u1ecdng \u1edf m\u1ed9t s\u1ed1 d\u00f2ng \u0111\u1ea7u v\u00e0 b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh t\u1ea5t c\u1ea3. D\u01b0\u1edbi \u0111\u00e2y s\u1ebd l\u00e0 c\u00e1ch l\u00e0m cho c\u1ea3 hai tr\u01b0\u1eddng h\u1ee3p.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_Lam_the_nao_de_dong_bang_dong_dau_trong_Excel\"><\/span><strong>1. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u0111\u00f3ng b\u0103ng d\u00f2ng \u0111\u1ea7u trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 lu\u00f4n hi\u1ec3n th\u1ecb h\u00e0ng ti\u00eau \u0111\u1ec1, ch\u1ec9 c\u1ea7n \u0111i t\u1edbi tab View, v\u00e0 nh\u1ea5p v\u00e0o <strong>Freeze Panes &gt; Freeze Top Row.<\/strong> Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng \ud83d\ude0a<\/p>\n<figure id=\"attachment_4786\" aria-describedby=\"caption-attachment-4786\" style=\"width: 447px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-100.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4786 size-full\" title=\"co-dinh-dong-cot-excel-1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-100.bmp\" alt=\"co-dinh-dong-cot-excel-1\" width=\"447\" height=\"262\"><\/a><figcaption id=\"caption-attachment-4786\" class=\"wp-caption-text\">1- H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e2ng cao trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Microsoft Excel s\u1ebd \u0111\u00e1nh d\u1ea5u h\u00e0ng \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh b\u1edfi m\u1ed9t \u0111\u01b0\u1eddng vi\u1ec1n d\u00e0y h\u01a1n v\u00e0 t\u1ed1i h\u01a1n b\u00ean d\u01b0\u1edbi n\u00f3:<\/p>\n<figure id=\"attachment_4787\" aria-describedby=\"caption-attachment-4787\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-101.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4787 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-101.bmp\" alt=\"co-dinh-dong-cot-excel-2\" width=\"600\" height=\"200\" title=\"new-bitmap-image-2-101\"><\/a><figcaption id=\"caption-attachment-4787\" class=\"wp-caption-text\">2 -H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e2ng cao trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">M\u1eb9o: N\u1ebfu b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi <strong>Excel Tables\u00a0<\/strong>thay v\u00ec ch\u1ec9 l\u00e0 v\u00f9ng d\u1eef li\u1ec7u, b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i kh\u00f3a d\u00f2ng \u0111\u1ea7u ti\u00ean, b\u1edfi v\u00ec ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea3ng lu\u00f4n lu\u00f4n c\u1ed1 \u0111\u1ecbnh \u1edf tr\u00ean c\u00f9ng, cho d\u00f9 b\u1ea1n c\u00f3 k\u00e9o xu\u1ed1ng bao nhi\u00eau h\u00e0ng.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Lam_the_nao_de_co_dinh_nhieu_dong_Excel\"><\/span><strong>2. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 mu\u1ed1n c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng trong b\u1ea3ng t\u00ednh kh\u00f4ng? Kh\u00f4ng c\u00f3 v\u1ea5n \u0111\u1ec1, b\u1ea1n c\u00f3 th\u1ec3 kh\u00f3a bao nhi\u00eau h\u00e0ng h\u00e0ng c\u0169ng \u0111\u01b0\u1ee3c, mi\u1ec5n l\u00e0 b\u1ea1n lu\u00f4n b\u1eaft \u0111\u1ea7u v\u1edbi h\u00e0ng tr\u00ean c\u00f9ng.<\/p>\n<p style=\"text-align: justify\">1. B\u1eaft \u0111\u1ea7u b\u1eb1ng c\u00e1ch ch\u1ecdn h\u00e0ng ph\u00eda d\u01b0\u1edbi c\u1ee7a h\u00e0ng cu\u1ed1i c\u00f9ng v\u00f9ng b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-272.gif\" title=\"vba101_92019-nho-272\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-614.gif\" title=\"ex101_92019-nho-614\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n mu\u1ed1n kh\u00f3a hai h\u00e0ng \u0111\u1ea7u, h\u00e3y \u0111\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o \u00f4 A3 ho\u1eb7c ch\u1ecdn to\u00e0n b\u1ed9 h\u00e0ng 3.<\/p>\n<p style=\"text-align: justify\">2. T\u1ea1i tab <strong>View<\/strong> nh\u1ea5p v\u00e0o <strong>Freeze Panes&gt; Freeze Panes<\/strong>.<\/p>\n<figure id=\"attachment_4789\" aria-describedby=\"caption-attachment-4789\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-103.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4789 size-full\" title=\"co-dinh-dong-cot-excel-3\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-103.bmp\" alt=\"co-dinh-dong-cot-excel-3\" width=\"600\" height=\"351\"><\/a><figcaption id=\"caption-attachment-4789\" class=\"wp-caption-text\">3- H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e2ng cao trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 s\u1ebd t\u01b0\u01a1ng t\u1ef1 nh\u01b0 nh\u1eefng g\u00ec b\u1ea1n th\u1ea5y trong h\u00ecnh b\u00ean d\u01b0\u1edbi \u2013 2 h\u00e0ng \u0111\u1ea7u trong b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n \u0111\u00e3 c\u1ed1 \u0111\u1ecbnh v\u00e0 s\u1ebd lu\u00f4n hi\u1ec3n th\u1ecb.<\/p>\n<figure id=\"attachment_4790\" aria-describedby=\"caption-attachment-4790\" style=\"width: 454px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-104.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4790 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-104.bmp\" alt=\"co-dinh-dong-cot-excel-4\" width=\"454\" height=\"203\" title=\"new-bitmap-image-2-104\"><\/a><figcaption id=\"caption-attachment-4790\" class=\"wp-caption-text\">4- H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e2ng cao trong Excel<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_co_dinh_cot_trong_Excel\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote id=\"c\u1ed1-\u0111\u1ecbnh-c\u1ed9t-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel-nhieu-cach-moi-hay-va-la.html?co-dinh-cot-trong-excel\">\n<p>B\u1ea1n mu\u1ed1n <strong>c\u1ed1 \u0111\u1ecbnh c\u00e1c c\u1ed9t trong Excel<\/strong> theo c\u00e1ch b\u1ea1n kh\u00f3a h\u00e0ng. V\u00e0 m\u1ed9t l\u1ea7n n\u1eefa, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean ho\u1eb7c nhi\u1ec1u c\u1ed9t. C\u00f9ng H\u1ecdc Excel Online th\u1ef1c hi\u1ec7n ngay sau \u0111\u00e2y.<\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"1_Co_dinh_cot_dau_tien_trong_mot_bang_tinh\"><\/span><strong>1. C\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean trong m\u1ed9t b\u1ea3ng t\u00ednh:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u1ed1 \u0111\u1ecbnh c\u1ed9t trong excel v\u1edbi ch\u1ee9c n\u0103ng <strong>Freeze Pane<\/strong><strong>s<\/strong>, ta c\u00f3 3 l\u1ef1a ch\u1ecdn sau:<\/p>\n<ul>\n<li><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.<\/li>\n<li><strong>Freeze Top Row<\/strong>: c\u1ed1 \u0111\u1ecbnh h\u00e0ng \u0111\u1ea7u ti\u00ean trong trang t\u00ednh.<\/li>\n<li><strong>Freeze First Column<\/strong>: c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean trong trang t\u00ednh<\/li>\n<\/ul>\n<p style=\"text-align: justify\">C\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o <strong><em>View&gt; Freeze Panes&gt; Freeze First Column<\/em><\/strong><strong><em>.<\/em><\/strong><\/p>\n<figure id=\"attachment_4791\" aria-describedby=\"caption-attachment-4791\" style=\"width: 543px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-105.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4791 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-105.bmp\" alt=\"co-dinh-dong-cot-excel-5\" width=\"543\" height=\"262\" title=\"new-bitmap-image-2-105\"><\/a><figcaption id=\"caption-attachment-4791\" class=\"wp-caption-text\">5- H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e2ng cao trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">M\u1ed9t \u0111\u01b0\u1eddng vi\u1ec1n t\u1ed1i v\u00e0 d\u00e0y h\u01a1n b\u00ean ph\u1ea3i c\u1ed9t A ngh\u0129a l\u00e0 ph\u1ea7n b\u00ean tr\u00e1i \u0111\u00e3 c\u1ed1 \u0111\u1ecbnh.<\/p>\n<figure id=\"attachment_4792\" aria-describedby=\"caption-attachment-4792\" style=\"width: 502px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-106.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4792 size-full\" title=\"co-dinh-dong-cot-excel-6\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-106.bmp\" alt=\"co-dinh-dong-cot-excel-6\" width=\"502\" height=\"243\"><\/a><figcaption id=\"caption-attachment-4792\" class=\"wp-caption-text\">6- H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e2ng cao trong Excel<\/figcaption><\/figure>\n<blockquote>\n<p style=\"text-align: justify\">Microsoft Excel l\u00e0 c\u00f4ng c\u1ee5 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn nh\u1ea5t tr\u00ean th\u1ebf gi\u1edbi t\u1ea1i c\u00e1c doanh nghi\u1ec7p, tuy nhi\u00ean n\u00f3 l\u1ea1i kh\u00f4ng \u0111\u01b0\u1ee3c coi tr\u1ecdng, kh\u00f4ng \u0111\u01b0\u1ee3c coi l\u00e0 k\u1ef9 n\u0103ng b\u1eaft bu\u1ed9c t\u1ea1i Vi\u1ec7t Nam n\u00ean khi \u0111i l\u00e0m ch\u00fang ta m\u1ea5t r\u1ea5t nhi\u1ec1u th\u1eddi gian tra c\u1ee9u v\u00e0 t\u00ecm hi\u1ec3u. V\u00ec v\u1eady \u0111\u1ec3 gi\u00fap ng\u01b0\u1eddi \u0111i l\u00e0m c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng th\u00e0nh th\u1ea1o c\u00e1c h\u00e0m Excel, th\u00e0nh th\u1ea1o c\u00e1c t\u00ednh t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao, b\u00e1o c\u00e1o si\u00eau t\u1ed1c v\u1edbi Pivot Table, v\u1ebd bi\u1ec3u \u0111\u1ed3, x\u1eed l\u00fd d\u1eef li\u1ec7u \u2026 ti\u1ebft ki\u1ec7m th\u1eddi gian tra c\u1ee9u, th\u1eddi gian t\u00ecm hi\u1ec3u, th\u00ec H\u1ecdc Excel Online \u0111\u00e3 thi\u1ebft k\u1ebf ra ch\u01b0\u01a1ng tr\u00ecnh Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m. V\u1edbi kho\u00e1 h\u1ecdc n\u00e0y h\u1ecdc vi\u00ean s\u1ebd h\u1ecdc online linh ho\u1ea1t m\u1ecdi l\u00fac m\u1ecdi n\u01a1i, trao \u0111\u1ed5i v\u1edbi h\u1ecdc vi\u00ean v\u1ec1 c\u00e1c v\u1ea5n \u0111\u1ec1 trong b\u00e0i gi\u1ea3ng trong su\u1ed1t q\u00faa tr\u00ecnh h\u1ecdc, \u0111\u1eb7c bi\u1ec7t h\u1ecdc ph\u00ed kho\u00e1 h\u1ecdc si\u00eau ti\u1ebft ki\u1ec7m v\u00e0 ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 ho\u00e0n tr\u1ea3 n\u1ebfu b\u1ea1n kh\u00f4ng h\u00e0i l\u00f2ng v\u1ec1 kho\u00e1 h\u1ecdc.<\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"2_Lam_the_nao_de_co_dinh_nhieu_cot_trong_Excel\"><\/span><strong>2. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n kh\u00f3a nhi\u1ec1u h\u01a1n m\u1ed9t c\u1ed9t trong m\u1ed9t trang t\u00ednh, h\u00e3y l\u00e0m nh\u01b0 sau.<\/p>\n<p style=\"text-align: justify\">1. Ch\u1ecdn c\u1ed9t \u1edf b\u00ean ph\u1ea3i c\u1ed9t cu\u1ed1i c\u00f9ng b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh. V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n mu\u1ed1n kh\u00f3a 3 c\u1ed9t \u0111\u1ea7u ti\u00ean (A \u2013 C), h\u00e3y ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t D ho\u1eb7c \u00f4 D1.<\/p>\n<p style=\"text-align: justify\">Ch\u1ec9 c\u1ea7n nh\u1edb r\u1eb1ng c\u1ed9t c\u1ed1 \u0111\u1ecbnh s\u1ebd lu\u00f4n lu\u00f4n b\u1eaft \u0111\u1ea7u t\u1eeb c\u1ed9t A b\u1ea1n kh\u00f4ng th\u1ec3 kh\u00f3a nhi\u1ec1u c\u1ed9t \u1edf gi\u1eefa b\u1ea3ng.<\/p>\n<p style=\"text-align: justify\">2. V\u00e0 b\u00e2y gi\u1edd, v\u00e0o tab <strong>View&gt; Freeze panes&gt; Freeze panes.<\/strong><\/p>\n<figure id=\"attachment_4793\" aria-describedby=\"caption-attachment-4793\" style=\"width: 631px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-107.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4793 size-full\" title=\"co-dinh-dong-cot-excel-7\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-107.bmp\" alt=\"co-dinh-dong-cot-excel-7\" width=\"631\" height=\"350\"><\/a><figcaption id=\"caption-attachment-4793\" class=\"wp-caption-text\">7- H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e2ng cao trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd:<\/strong> H\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng c\u00e1c c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n kh\u00f3a \u0111\u1ec1u hi\u1ec3n th\u1ecb t\u1ea1i th\u1eddi \u0111i\u1ec3m th\u1ef1c hi\u1ec7n thao t\u00e1c. N\u1ebfu m\u1ed9t s\u1ed1 c\u1ed9t kh\u00f4ng th\u1ec3 hi\u1ec7n l\u00fac \u0111\u00f3, b\u1ea1n v\u1eabn s\u1ebd kh\u00f4ng nh\u00ecn th\u1ea5y ch\u00fang sau khi c\u1ed1 \u0111\u1ecbnh.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Co_dinh_cot_trong_Excel_voi_Split\"><\/span>3. 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\/2024\/12\/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\/2024\/12\/co-dinh-cot-6.png\" width=\"333\" height=\"227\" title=\"co-dinh-cot-6\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_co_dinh_nhieu_vung_trong_Excel_cac_hang_va_cot\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u v\u00f9ng trong Excel (c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t):<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 mu\u1ed1n kh\u00f3a nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t kh\u00f4ng? Kh\u00f4ng c\u00f3 v\u1ea5n \u0111\u1ec1 g\u00ec, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y v\u1edbi \u0111i\u1ec1u ki\u1ec7n l\u00e0 b\u1ea1n lu\u00f4n b\u1eaft \u0111\u1ea7u v\u1edbi h\u00e0ng v\u00e0 c\u1ed9t \u0111\u1ea7u ti\u00ean.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 kh\u00f3a nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t c\u00f9ng m\u1ed9t l\u00fac, h\u00e3y ch\u1ecdn m\u1ed9t \u00f4 b\u00ean d\u01b0\u1edbi h\u00e0ng cu\u1ed1i c\u00f9ng v\u00e0 \u1edf b\u00ean ph\u1ea3i c\u1ed9t cu\u1ed1i c\u00f9ng b\u1ea1n mu\u1ed1n kh\u00f3a.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh h\u00e0ng v\u00e0 c\u1ed9t \u0111\u1ea7u ti\u00ean, h\u00e3y ch\u1ecdn \u00f4 B2, v\u00e0o tab View v\u00e0 nh\u1ea5p v\u00e0o Freeze panes \u00a0b\u00ean d\u01b0\u1edbi Freeze panes:<\/p>\n<figure id=\"attachment_4795\" aria-describedby=\"caption-attachment-4795\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-109.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4795 size-full\" title=\"co-dinh-dong-cot-excel-8\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-109.bmp\" alt=\"co-dinh-dong-cot-excel-8\" width=\"600\" height=\"309\"><\/a><figcaption id=\"caption-attachment-4795\" class=\"wp-caption-text\">8- H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e2ng cao trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">Theo c\u00f9ng c\u00e1ch \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u v\u00f9ng trong Excel theo \u00fd mu\u1ed1n. V\u00ed d\u1ee5, \u0111\u1ec3 kh\u00f3a 2 h\u00e0ng v\u00e0 2 c\u1ed9t \u0111\u1ea7u ti\u00ean, b\u1ea1n ch\u1ecdn cell C3; \u0110\u1ec3 kh\u00f3a 3 h\u00e0ng v\u00e0 3 c\u1ed9t, ch\u1ecdn \u00f4 D4 vv\u2026<\/p>\n<p style=\"text-align: justify\">\u0110\u01b0\u01a1ng nhi\u00ean, s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t b\u1ecb kh\u00f3a kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i gi\u1ed1ng nhau. V\u00ed d\u1ee5, \u0111\u1ec3 \u0111\u00f3ng b\u0103ng 2 h\u00e0ng v\u00e0 3 c\u1ed9t, b\u1ea1n ch\u1ecdn \u2026 \u0111o\u00e1n \u00f4 n\u00e0o? Ph\u1ea3i, \u0111\u00f3 l\u00e0 D3:)<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_xoa_bo_co_dinh_trong_Excel\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 x\u00f3a b\u1ecf c\u1ed1 \u0111\u1ecbnh trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 b\u1ecf kh\u00f3a c\u00e1c khung, ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau: \u0111i \u0111\u1ebfn tab <strong>View<\/strong>, nh\u1ea5p <strong>Unfreeze Panes<\/strong>.<\/p>\n<figure id=\"attachment_4796\" aria-describedby=\"caption-attachment-4796\" style=\"width: 282px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-110.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4796 size-full\" title=\"co-dinh-dong-cot-excel-9\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-110.bmp\" alt=\"co-dinh-dong-cot-excel-9\" width=\"282\" height=\"256\"><\/a><figcaption id=\"caption-attachment-4796\" class=\"wp-caption-text\">9- H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e2ng cao trong Excel<\/figcaption><\/figure>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Meo_khi_su_dung_Excel_Freeze_Panes\"><\/span><strong>M\u1eb9o khi s\u1eed d\u1ee5ng Excel Freeze Panes<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n v\u1eeba th\u1ea5y, c\u1ed1 \u0111\u1ecbnh khung trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng vi\u1ec7c \u0111\u01a1n gi\u1ea3n nh\u1ea5t. Tuy nhi\u00ean, ph\u1ea3i ch\u00fa \u00fd nh\u1eefng \u0111i\u1ec1u sau<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"1_Truoc_khi_thuc_hien_Tranh_hangcot_bi_an\"><\/span><strong>1. Tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n: Tr\u00e1nh h\u00e0ng\/c\u1ed9t b\u1ecb \u1ea9n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Khi b\u1ea1n kh\u00f3a nhi\u1ec1u h\u00e0ng ho\u1eb7c c\u1ed9t trong m\u1ed9t b\u1ea3ng t\u00ednh, b\u1ea1n c\u00f3 th\u1ec3 v\u00f4 t\u00ecnh kh\u00f4ng th\u1ec3 hi\u1ec3n m\u1ed9t v\u00e0i trong s\u1ed1 ch\u00fang, v\u00e0 k\u1ebft qu\u1ea3 l\u00e0 b\u1ea1n c\u0169ng s\u1ebd kh\u00f4ng nh\u00ecn th\u1ea5y ch\u00fang sau \u0111\u00f3. \u0110\u1ec3 tr\u00e1nh \u0111i\u1ec1u n\u00e0y, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng v\u00e0 \/ ho\u1eb7c c\u00e1c c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n kh\u00f3a \u0111\u1ec1u n\u1eb1m trong t\u1ea7m nh\u00ecn v\u00e0o l\u00fac th\u1ef1c hi\u1ec7n vi\u1ec7c c\u1ed1 \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh ba h\u00e0ng \u0111\u1ea7u ti\u00ean, nh\u01b0ng h\u00e0ng 1 kh\u00f4ng trong t\u1ea7m nh\u00ecn, nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y. K\u1ebft qu\u1ea3 l\u00e0, h\u00e0ng 1 s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb sau \u0111\u00f3 v\u00e0 b\u1ea1n s\u1ebd kh\u00f4ng th\u1ec3 cu\u1ed9n l\u00ean \u0111\u1ec3 th\u1ea5y n\u00f3. M\u1eb7c d\u00f9, b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 truy c\u1eadp v\u00e0o c\u00e1c \u00f4 trong h\u00e0ng \u0111\u01b0\u1ee3c \u1ea9n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c ph\u00edm m\u0169i t\u00ean.<\/p>\n<figure id=\"attachment_4797\" aria-describedby=\"caption-attachment-4797\" style=\"width: 282px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-111.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4797 size-full\" title=\"co-dinh-dong-cot-excel-10\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-111.bmp\" alt=\"co-dinh-dong-cot-excel-10\" width=\"282\" height=\"256\"><\/a><figcaption id=\"caption-attachment-4797\" class=\"wp-caption-text\">10- H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e2ng cao trong Excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"2_Excel_co_the_co_dinh_bang_hoan_toan_khac_voi_nhung_gi_ban_mong_doi\"><\/span><strong>2. Excel c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh b\u1ea3ng ho\u00e0n to\u00e0n kh\u00e1c v\u1edbi nh\u1eefng g\u00ec b\u1ea1n mong \u0111\u1ee3i<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u1ea1n kh\u00f4ng tin sao? V\u1eady h\u00e3y th\u1eed ch\u1ecdn \u00f4 A1, ho\u1eb7c h\u00e0ng tr\u00ean c\u00f9ng c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y, ho\u1eb7c c\u1ed9t b\u00ean tr\u00e1i c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y, nh\u1ea5p v\u00e0o Freeze panes v\u00e0 xem \u0111i\u1ec1u g\u00ec x\u1ea3y ra.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n ch\u1ecdn h\u00e0ng 4 trong khi 3 h\u00e0ng \u0111\u1ea7u kh\u00f4ng \u1edf ch\u1ebf \u0111\u1ed9 xem (kh\u00f4ng ph\u1ea3i b\u1ecb \u1ea9n, ch\u1ec9 l\u00e0 \u1edf ph\u00eda tr\u00ean thanh cu\u1ed9n) v\u00e0 nh\u1ea5p v\u00e0o Freeze panes, b\u1ea1n mong \u0111\u1ee3i \u0111i\u1ec1u g\u00ec? R\u00f5 r\u00e0ng l\u00e0 c\u00e1c h\u00e0ng 1 \u2013 3 s\u1ebd b\u1ecb c\u1ed1 \u0111\u1ecbnh? Kh\u00f4ng! Microsoft Excel ngh\u0129 kh\u00e1c v\u00e0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y m\u1ed9t trong nhi\u1ec1u k\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 x\u1ea3y ra:<\/p>\n<figure id=\"attachment_4799\" aria-describedby=\"caption-attachment-4799\" style=\"width: 582px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-112.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4799 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-112.bmp\" alt=\"co-dinh-dong-cot-excel-11\" width=\"582\" height=\"390\" title=\"new-bitmap-image-2-112\"><\/a><figcaption id=\"caption-attachment-4799\" class=\"wp-caption-text\">11- H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e2ng cao trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\">V\u00ec v\u1eady, h\u00e3y nh\u1edb r\u1eb1ng, c\u00e1c khung b\u1ea1n ch\u1ecdn \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh, c\u1ea3 h\u00e0ng v\u00e0 c\u1ed9t, n\u00ean lu\u00f4n lu\u00f4n th\u1ea5y \u0111\u01b0\u1ee3c.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"3_Meo_Lam_the_nao_de_nguy_trang_dong_Freeze_Panes\"><\/span><strong>3. M\u1eb9o: L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ng\u1ee5y trang d\u00f2ng Freeze Panes:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng th\u00edch c\u00e1c d\u00f2ng s\u1eabm ph\u00e2n c\u00e1ch gi\u1eefa ph\u1ea7n \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh v\u00e0 c\u00f2n l\u1ea1i c\u1ee7a b\u1ea3ng trong Microsoft Excel, b\u1ea1n c\u00f3 th\u1ec3 th\u1eed ng\u1ee5y trang b\u1eb1ng s\u1ef1 tr\u1ee3 gi\u00fap c\u1ee7a c\u00e1c h\u00ecnh kh\u1ed1i \u00a0v\u00e0 m\u1ed9t ch\u00fat s\u00e1ng t\u1ea1o:)<\/p>\n<figure id=\"attachment_4800\" aria-describedby=\"caption-attachment-4800\" style=\"width: 544px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-113.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-4800 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-113.bmp\" alt=\"co-dinh-dong-cot-excel-12\" width=\"544\" height=\"225\" title=\"new-bitmap-image-2-113\"><\/a><figcaption id=\"caption-attachment-4800\" class=\"wp-caption-text\">12- H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e2ng cao trong Excel<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_cach_sua_cac_loi_lien_quan_toi_co_dinh_bang_tinh_bang_Freeze_Panes\"><\/span>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<span class=\"ez-toc-section-end\"><\/span><\/h2>\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<h3><span class=\"ez-toc-section\" id=\"Khong_hien_ra_cac_cong_cu_trong_nhom_chuc_nang_Freeze_Panes\"><\/span><span id=\"Khong_hien_ra_cac_cong_cu_trong_nhom_chuc_nang_Freeze_Panes\" class=\"ez-toc-section\"><\/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><\/h3>\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\/2024\/12\/loi-freeze-panes-khong-su-dung-duoc.png\" width=\"1106\" height=\"330\" title=\"loi-freeze-panes-khong-su-dung-duoc\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Tinh_trang\"><\/span><span id=\"Tinh_trang\" class=\"ez-toc-section\"><\/span><strong>T\u00ecnh tr\u1ea1ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\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<h4><span class=\"ez-toc-section\" id=\"Cach_khac_phuc\"><\/span><span id=\"Cach_khac_phuc\" class=\"ez-toc-section\"><\/span><strong>C\u00e1ch kh\u1eafc ph\u1ee5c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\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:\u00a0<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\">\n<div class=\"ad-inserterpro\"><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-614.gif\" title=\"ex101_92019-nho-614\"><\/a><\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Chuc_nang_Freeze_Panes_hoat_dong_khong_nhu_mong_muon\"><\/span><span id=\"Chuc_nang_Freeze_Panes_hoat_dong_khong_nhu_mong_muon\" class=\"ez-toc-section\"><\/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><\/h3>\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\/2024\/12\/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<h4 id=\"template-VhPWJJfL#1-0-0-3\" class=\"uk-panel uk-margin\"><span class=\"ez-toc-section\" id=\"Tinh_trang-2\"><\/span><span id=\"Tinh_trang-2\" class=\"ez-toc-section\"><\/span><strong>T\u00ecnh tr\u1ea1ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"uk-panel uk-margin\"><span style=\"font-size: revert;color: initial\">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.<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cach_khac_phuc-2\"><\/span><span id=\"Cach_khac_phuc-2\" class=\"ez-toc-section\"><\/span><strong>C\u00e1ch kh\u1eafc ph\u1ee5c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\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\/2024\/12\/co-dinh-tieu-de-theo-table.png\" width=\"635\" height=\"184\" title=\"co-dinh-tieu-de-theo-table\">\n<\/p>\n<\/div>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem thu\u1ed9c <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-tu-co-ban-toi-nang-cao-danh-cho-dan-van-phong-2010-20132016\"><strong>kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao<\/strong><\/a> c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong>. Kh\u00f3a h\u1ecdc n\u00e0y cung c\u1ea5p cho b\u1ea1n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong excel, \u1ee9ng d\u1ee5ng excel trong c\u00f4ng vi\u1ec7c\u2026 Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc n\u00e0y.<\/p>\n<\/div>\n<h4 id=\"template-VhPWJJfL#1-0-0-3\" class=\"uk-panel uk-margin\"><span class=\"ez-toc-section\" id=\"Tinh_trang-2\"><\/span><span id=\"Tinh_trang-2\" class=\"ez-toc-section\"><\/span><strong>T\u00ecnh tr\u1ea1ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"uk-panel uk-margin\"><span style=\"font-size: revert;color: initial\">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.<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cach_khac_phuc-2\"><\/span><span id=\"Cach_khac_phuc-2\" class=\"ez-toc-section\"><\/span><strong>C\u00e1ch kh\u1eafc ph\u1ee5c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\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\/2024\/12\/co-dinh-tieu-de-theo-table.png\" width=\"635\" height=\"184\" title=\"co-dinh-tieu-de-theo-table\">\n<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-272.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6843,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6842","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\/6842","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=6842"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6842\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6843"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}