{"id":8734,"date":"2024-12-28T21:47:00","date_gmt":"2024-12-28T21:47:00","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/28\/giu-tieu-de-bang-trong-excel-qua-03-cach-don-gian\/"},"modified":"2024-12-28T21:47:00","modified_gmt":"2024-12-28T21:47:00","slug":"giu-tieu-de-bang-trong-excel-qua-03-cach-don-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/28\/giu-tieu-de-bang-trong-excel-qua-03-cach-don-gian\/","title":{"rendered":"Gi\u1eef ti\u00eau \u0111\u1ec1 b\u1ea3ng trong Excel qua 03 c\u00e1ch \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ta th\u01b0\u1eddng ph\u1ea3i l\u00e0m vi\u1ec7c v\u1edbi nh\u1eefng b\u1ea3ng d\u1eef li\u1ec7u l\u00ean \u0111\u1ebfn h\u00e0ng ngh\u00ecn d\u00f2ng v\u00e0 s\u1ebd th\u1eadt kh\u00f3 \u0111\u1ec3 nh\u1edb ti\u00eau \u0111\u1ec1 c\u1ed9t, \u0111\u1ec3 bi\u1ebft c\u1ea7n ph\u1ea3i \u0111i\u1ec1n g\u00ec v\u00e0o hay li\u1ec7u d\u1eef li\u1ec7u c\u00f3 kh\u1edbp kh\u00f4ng. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, H\u1ecdc Excel Online s\u1ebd chia s\u1ebb v\u1edbi b\u1ea1n 03 m\u1eb9o \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 gi\u1eef ti\u00eau \u0111\u1ec1 b\u1ea3ng trong Excel.<\/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-677071d3a7709\" 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\/giu-tieu-de-bang-trong-excel.html#Giu_tieu_de_bang_trong_Excel_bang_chuc_nang_Freeze_Panes\" title=\"Gi\u1eef ti\u00eau \u0111\u1ec1 b\u1ea3ng trong Excel b\u1eb1ng ch\u1ee9c n\u0103ng Freeze Panes\">Gi\u1eef ti\u00eau \u0111\u1ec1 b\u1ea3ng trong Excel b\u1eb1ng ch\u1ee9c 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\/giu-tieu-de-bang-trong-excel.html#Giu_tieu_de_bang_trong_Excel_bang_chuc_nang_Split\" title=\"Gi\u1eef ti\u00eau \u0111\u1ec1 b\u1ea3ng trong Excel b\u1eb1ng ch\u1ee9c n\u0103ng Split\">Gi\u1eef ti\u00eau \u0111\u1ec1 b\u1ea3ng trong Excel b\u1eb1ng ch\u1ee9c n\u0103ng Split<\/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\/giu-tieu-de-bang-trong-excel.html#Chuyen_vung_thanh_bang_trong_Excel\" title=\"Chuy\u1ec3n v\u00f9ng th\u00e0nh b\u1ea3ng trong Excel\">Chuy\u1ec3n v\u00f9ng th\u00e0nh b\u1ea3ng trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Giu_tieu_de_bang_trong_Excel_bang_chuc_nang_Freeze_Panes\"><\/span>Gi\u1eef ti\u00eau \u0111\u1ec1 b\u1ea3ng trong Excel b\u1eb1ng ch\u1ee9c n\u0103ng Freeze Panes<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/tinh-nang-freeze-trong-bai-thi-mos-excel.html\">Ch\u1ee9c n\u0103ng Freeze Panes<\/a>\u00a0<\/strong>s\u1ebd gi\u00fap b\u1ea1n c\u1ed1 \u0111\u1ecbnh h\u00e0ng ho\u1eb7c c\u1ed9t theo \u00fd mu\u1ed1n. \u0110\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng n\u00e0y, ta v\u00e0o th\u1ebb\u00a0<strong>View<\/strong>, ch\u1ecdn\u00a0<strong>Freeze Panes<\/strong> sau \u0111\u00f3 ch\u1ecdn\u00a0<strong>Freeze Top Row\u00a0<\/strong>n\u1ebfu ti\u00eau \u0111\u1ec1 c\u1ed9t n\u1eb1m t\u1ea1i d\u00f2ng 1, ho\u1eb7c ch\u1ecdn d\u00f2ng n\u1eb1m b\u00ean d\u01b0\u1edbi d\u00f2ng mu\u1ed1n c\u1ed1 \u0111\u1ecbnh r\u1ed3i ch\u1ecdn\u00a0<strong>Freeze Panes.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26976\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/co-dinh-tieu-de-cot-1.png\" width=\"979\" height=\"423\" title=\"co-dinh-tieu-de-cot-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Giu_tieu_de_bang_trong_Excel_bang_chuc_nang_Split\"><\/span>Gi\u1eef ti\u00eau \u0111\u1ec1 b\u1ea3ng trong Excel b\u1eb1ng ch\u1ee9c n\u0103ng Split<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/chuc-nang-split-arrange-hide-unhide.html\"><strong>Ch\u1ee9c n\u0103ng Split<\/strong><\/a> trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y c\u0169ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 Freeze Panes, gi\u00fap chia t\u00e1ch b\u1ea3ng d\u1eef li\u1ec7u ra th\u00e0nh 2 ph\u1ea7n \u0111\u1ec3 ta v\u1eeba c\u00f3 th\u1ec3 quan s\u00e1t, v\u1eeba\u00a0c\u00f3 th\u1ec3 t\u1ef1 do di chuy\u1ec3n.<\/p>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng n\u00e0y ta ch\u1ecdn d\u00f2ng b\u00ean d\u01b0\u1edbi d\u00f2ng c\u1ea7n c\u1ed1 \u0111inh, v\u00e0o th\u1ebb\u00a0<strong>View<\/strong>, ch\u1ecdn\u00a0<strong>Split.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26977\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/co-dinh-tieu-de-cot-2.png\" width=\"752\" height=\"358\" title=\"co-dinh-tieu-de-cot-2\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chuyen_vung_thanh_bang_trong_Excel\"><\/span>Chuy\u1ec3n v\u00f9ng th\u00e0nh b\u1ea3ng trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1eb9o s\u1ed1 3 c\u1ee7a ta \u0111\u00f3 l\u00e0 chuy\u1ec3n d\u1eef li\u1ec7u t\u1eeb v\u00f9ng th\u00e0nh b\u1ea3ng. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y ta ch\u1ecdn v\u00f9ng c\u1ea7n chuy\u1ec3n (bao g\u1ed3m c\u1ea3 ti\u00eau \u0111\u1ec1), v\u00e0o th\u1ebb Insert v\u00e0 ch\u1ecdn\u00a0<strong>Table<\/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\/2024\/12\/ex101_92019-nho-814.gif\" title=\"ex101_92019-nho-814\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26978\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/co-dinh-tieu-de-cot-3.png\" width=\"549\" height=\"385\" title=\"co-dinh-tieu-de-cot-3\"><\/p>\n<p>Ch\u1ecdn v\u00f9ng t\u1ea1o b\u1ea3ng v\u00e0 ch\u1ecdn\u00a0<strong>My table has headers<\/strong> n\u1ebfu c\u00f3.<\/p>\n<p>Sau \u0111\u00f3 m\u1ed7i khi ta cu\u1ed9n b\u1ea3ng xu\u1ed1ng (v\u1edbi \u0111i\u1ec1u ki\u1ec7n ch\u1ecdn \u00f4 trong b\u1ea3ng), ti\u00eau \u0111\u1ec1 b\u1ea3ng s\u1ebd t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb l\u00ean ti\u00eau \u0111\u1ec1 c\u1ed9t m\u1eb7c \u0111\u1ecbnh.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26979\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/co-dinh-tieu-de-cot-4.png\" width=\"733\" height=\"452\" title=\"co-dinh-tieu-de-cot-4\"><\/p>\n<p>V\u1eady l\u00e0 ch\u00fang ta \u0111\u00e3 t\u00ecm hi\u1ec3u 3 m\u1eb9o \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 hi\u1ec3n th\u1ecb ti\u00eau \u0111\u1ec1 b\u1ea3ng. Hy v\u1ecdng c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng nh\u1eefng t\u00ednh n\u0103ng n\u00e0y nhi\u1ec1u h\u01a1n, gi\u00fap cho c\u00f4ng vi\u1ec7c tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 d\u00e0ng.<\/p>\n<hr>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-sua-cac-loi-lien-quan-toi-co-dinh-bang-tinh-bang-freeze-panes.html\">H\u01b0\u1edbng d\u1eabn c\u00e1c l\u1ed7i li\u00ean quan Freeze Panes<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-dem-lan-xuat-hien-trong-table.html\"><strong>C\u00f4ng th\u1ee9c \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n trong Table<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/hoi-dap-excel-7-tinh-nang-huu-ich-trong-excel.html\"><strong>7 t\u00ednh n\u0103ng h\u1eefu \u00edch c\u1ee7a Excel<\/strong><\/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-814.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8735,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8734","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\/8734","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=8734"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8734\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8735"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}