{"id":13072,"date":"2022-11-23T08:33:29","date_gmt":"2022-11-23T01:33:29","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=13072"},"modified":"2026-01-20T14:35:59","modified_gmt":"2026-01-20T07:35:59","slug":"cach-giu-tieu-de-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/","title":{"rendered":"3+ C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n m\u1edbi nh\u1ea5t"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;13072&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;6&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;4.5\\\/5 - (6 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;3+ C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n m\u1edbi nh\u1ea5t&quot;,&quot;width&quot;:&quot;128&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 128px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            4.5\/5 - (6 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p><span style=\"font-weight: 400;\"><strong>C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel<\/strong> ra sao? Th\u1ef1c t\u1ebf, khi d\u1eef li\u1ec7u trong b\u1ea3ng Excel l\u00ean \u0111\u1ebfn h\u00e0ng tr\u0103m hay h\u00e0ng ngh\u00ecn d\u00f2ng. M\u1ed7i l\u1ea7n di chuy\u1ec3n \u0111\u1ebfn trang kh\u00e1c, d\u00f2ng ti\u00eau \u0111\u1ec1 s\u1ebd d\u1ec5 b\u1ecb che l\u1ea5p \u0111i. \u0110i\u1ec1u n\u00e0y g\u00e2y r\u1ea5t nhi\u1ec1u kh\u00f3 kh\u0103n cho ng\u01b0\u1eddi d\u00f9ng trong vi\u1ec7c nh\u1edb v\u00e0 nh\u1eadp d\u1eef li\u1ec7u. Do \u0111\u00f3 h\u00f4m nay TEKY s\u1ebd c\u00f9ng b\u1ea1n kh\u00e1m ph\u00e1 nh\u1eefng c\u00e1ch gi\u1eef nguy\u00ean ti\u00eau \u0111\u1ec1 si\u00eau \u0111\u01a1n gi\u1ea3n trong Excel.\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/train-jungle-21603754.figma.site\/\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-29759\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/11\/Banner-Word.png\" alt=\"\" width=\"1281\" height=\"767\" \/><\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#Cach_giu_tieu_de_trong_Excel_chuc_nang_Freeze_Panes\" >C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel ch\u1ee9c n\u0103ng Freeze Panes\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#Doi_voi_phien_ban_Excel_2007_tro_ve_sau\" >\u0110\u1ed1i v\u1edbi phi\u00ean b\u1ea3n Excel 2007 tr\u1edf v\u1ec1 sau<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#Doi_voi_phien_ban_Excel_2003\" >\u0110\u1ed1i v\u1edbi phi\u00ean b\u1ea3n Excel 2003<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#Cach_giu_tieu_de_trong_Excel_don_gian_voi_chuc_nang_Split\" >C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel \u0111\u01a1n gi\u1ea3n v\u1edbi ch\u1ee9c n\u0103ng Split\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#Cach_giu_tieu_de_trong_Excel_khi_in_don_gian\" >C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel khi in \u0111\u01a1n gi\u1ea3n\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#Cach_giu_tieu_de_trong_Excel_bang_cach_chuyen_vung_du_lieu_thanh_bang\" >C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel b\u1eb1ng c\u00e1ch chuy\u1ec3n v\u00f9ng d\u1eef li\u1ec7u th\u00e0nh b\u1ea3ng\u00a0<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_giu_tieu_de_trong_Excel_chuc_nang_Freeze_Panes\"><\/span><b>C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel ch\u1ee9c n\u0103ng Freeze Panes\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Doi_voi_phien_ban_Excel_2007_tro_ve_sau\"><\/span><strong>\u0110\u1ed1i v\u1edbi phi\u00ean b\u1ea3n Excel 2007 tr\u1edf v\u1ec1 sau<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Trong m\u1ed9t b\u1ea3ng t\u00ednh c\u00f3 nhi\u1ec1u lo\u1ea1i d\u1eef li\u1ec7u kh\u00e1c nhau. Ch\u1eb3ng nh\u01b0 c\u00e1c d\u1eef li\u1ec7u b\u00e1n h\u00e0ng, d\u1eef li\u1ec7u nh\u00e0 s\u00e1ch, h\u1ecdc sinh,.. Ng\u01b0\u1eddi ta th\u01b0\u1eddng s\u1ebd t\u1ea1o m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u g\u1ed3m nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t \u0111\u1ec3 d\u1ec5 d\u00e0ng ph\u00e2n bi\u1ec7t c\u00e1c th\u00f4ng tin c\u00f3 trong b\u1ea3ng. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">T\u1ea1i m\u1ed7i c\u1ed9t, \u00f4 \u0111\u1ea7u ti\u00ean th\u01b0\u1eddng s\u1ebd l\u00e0 ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t \u0111\u00f3. Nh\u01b0 v\u1eady, khi nh\u1eadp v\u00e0o c\u00e1c d\u1eef li\u1ec7u, kh\u1ea3 n\u0103ng b\u1ecb r\u1ed1i v\u00ec l\u01b0\u1ee3ng l\u1edbn th\u00f4ng tin s\u1ebd gi\u1ea3m b\u1edbt. Tuy nhi\u00ean, n\u1ebfu kh\u00f4ng c\u1ed1 \u0111\u1ecbnh d\u00f2ng ti\u00eau \u0111\u1ec1, khi b\u1ea1n cu\u1ed9n chu\u1ed9t xu\u1ed1ng, d\u00f2ng ti\u00eau \u0111\u1ec1 c\u0169ng theo chu\u1ed9t m\u00e0 bi\u1ebfn m\u1ea5t.\u00a0<\/span><\/p>\n<figure id=\"attachment_13074\" aria-describedby=\"caption-attachment-13074\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13074 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel-1.jpg\" alt=\"C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel 2007 v\u1ec1 sau v\u1edbi ch\u1ee9c n\u0103ng Freeze Panes\u00a0\" width=\"600\" height=\"235\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel-1-400x157.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13074\" class=\"wp-caption-text\">C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel 2007 v\u1ec1 sau v\u1edbi ch\u1ee9c n\u0103ng Freeze Panes<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">V\u00ec v\u1eady, \u0111\u1ec3 tr\u00e1nh t\u00ecnh tr\u1ea1ng tr\u00ean, b\u1ea1n h\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1eb7t h\u00e0ng ti\u00eau \u0111\u1ec1 \u1edf v\u1ecb tr\u00ed \u0111\u1ea7u b\u1ea3ng. N\u1ebfu h\u00e0ng ti\u00eau \u0111\u1ec1 n\u1eb1m \u1edf c\u00e1c d\u00f2ng d\u01b0\u1edbi, h\u00e3y nh\u1edb d\u1ecbch chuy\u1ec3n n\u00f3 l\u00ean \u0111\u1ea7u b\u1ea3ng d\u1eef li\u1ec7u. Nh\u1ea5p ch\u1ecdn d\u00f2ng ti\u00eau \u0111\u1ec1.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: T\u00ecm tab View tr\u00ean thanh c\u00f4ng c\u1ee5. Sau \u0111\u00f3 b\u1ea1n ch\u1ecdn Freeze Panes.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Khi b\u1ea5m v\u00e0o Freeze Panes, giao di\u1ec7n s\u1ebd xu\u1ea5t hi\u1ec7n m\u1ed9t b\u1ea3ng g\u1ed3m 3 l\u1ef1a ch\u1ecdn l\u00e0: Freeze Panes, Freeze Top Row, v\u00e0 Freeze First Column. B\u1ea1n ch\u1ecdn \u201cFreeze Top Row\u201d. Nh\u01b0 v\u1eady, d\u00f2ng ti\u00eau \u0111\u1ec1 s\u1ebd \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh l\u1ea1i v\u00e0 xu\u1ea5t hi\u1ec7n xuy\u00ean su\u1ed1t qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c c\u1ee7a b\u1ea1n.\u00a0<\/span><\/li>\n<\/ul>\n<p><iframe loading=\"lazy\" title=\"L\u1eb7p l\u1ea1i d\u00f2ng ti\u00eau \u0111\u1ec1 tr\u00ean c\u00e1c trang in trong Excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/wgyFCdAbT5E?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Doi_voi_phien_ban_Excel_2003\"><\/span><strong>\u0110\u1ed1i v\u1edbi phi\u00ean b\u1ea3n Excel 2003<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Tuy nhi\u00ean, c\u00e1c b\u01b0\u1edbc tr\u00ean ch\u1ec9 \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c cho c\u00e1c phi\u00ean b\u1ea3n Excel t\u1eeb n\u0103m 2007 tr\u1edf v\u1ec1 sau. \u0110\u1ed1i v\u1edbi phi\u00ean b\u1ea3n Excel 2003, b\u1ea1n c\u00f3 th\u1ec3 gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: L\u1ef1a ch\u1ecdn h\u00e0ng ti\u00eau \u0111\u1ec1 c\u1ea7n c\u1ed1 \u0111\u1ecbnh c\u1ee7a b\u1ea3ng v\u00e0 \u0111\u01b0a n\u00f3 l\u00ean v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Tr\u00ean thanh c\u00f4ng c\u1ee5, t\u00ecm v\u00e0 ch\u1ecdn Window, sau \u0111\u00f3 ch\u1ecdn Freeze Panes \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Th\u1ef1c hi\u1ec7n ho\u00e0n ch\u1ec9nh c\u00e1c b\u01b0\u1edbc tr\u00ean, b\u1ea1n s\u1ebd c\u00f3 ngay m\u1ed9t thanh ti\u00eau \u0111\u1ec1 kh\u00f4ng h\u1ec1 x\u00ea d\u1ecbch cho d\u00f9 b\u1ea1n cu\u1ed9n xu\u1ed1ng d\u01b0\u1edbi b\u1ea3ng bao nhi\u00eau d\u00f2ng v\u00e0 l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n v\u1edbi s\u1ed1 l\u01b0\u1ee3ng d\u1eef li\u1ec7u v\u00f4 c\u00f9ng l\u1edbn.\u00a0<\/span><\/p>\n<figure id=\"attachment_13082\" aria-describedby=\"caption-attachment-13082\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13082 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel-2.jpg\" alt=\"\u0110\u1ed1i v\u1edbi phi\u00ean b\u1ea3n Excel 2003\" width=\"600\" height=\"327\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel-2-400x218.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13082\" class=\"wp-caption-text\">\u0110\u1ed1i v\u1edbi phi\u00ean b\u1ea3n Excel 2003<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cach_giu_tieu_de_trong_Excel_don_gian_voi_chuc_nang_Split\"><\/span><b>C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel \u0111\u01a1n gi\u1ea3n v\u1edbi ch\u1ee9c n\u0103ng Split\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">C\u0169ng nh\u01b0 Freeze Panes, ch\u1ee9c n\u0103ng Split c\u0169ng c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n gi\u1eef l\u1ea1i d\u00f2ng ti\u00eau \u0111\u1ec1 khi \u0111ang l\u00e0m vi\u1ec7c. M\u1ee5c \u0111\u00edch nh\u1eb1m gi\u00fap ng\u01b0\u1eddi d\u00f9ng\u00a0 d\u1ec5 quan s\u00e1t v\u00e0 \u0111i\u1ec1n c\u00e1c d\u1eef li\u1ec7u ch\u00ednh x\u00e1c h\u01a1n. Ch\u1ee9c n\u0103ng n\u00e0y gi\u00fap ch\u00fang ta chia d\u1eef li\u1ec7u th\u00e0nh 2 ph\u1ea7n l\u00e0 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n l\u00e0m vi\u1ec7c v\u00e0 thanh ti\u00eau \u0111\u1ec1.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u1ea1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau, thanh ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea1n s\u1ebd kh\u00f4ng th\u1ec3 t\u1ef1 do di chuy\u1ec3n v\u00e0 lu\u00f4n xu\u1ea5t hi\u1ec7n khi b\u1ea1n l\u00e0m vi\u1ec7c<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: K\u00e9o chu\u1ed9t v\u00e0 ch\u1ecdn to\u00e0n b\u1ed9 d\u00f2ng n\u1eb1m ngay d\u01b0\u1edbi d\u00f2ng ti\u00eau \u0111\u1ec1 c\u1ea7n c\u1ed1 \u0111\u1ecbnh. B\u1ea1n ho\u00e0n to\u00e0n kh\u00f4ng c\u1ea7n ch\u1ecdn d\u00f2ng ti\u00eau \u0111\u1ec1.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: V\u00e0o tab \u201cView\u201d tr\u00ean thanh c\u00f4ng c\u1ee5, sau \u0111\u00f3 ch\u1ecdn \u201cSplit\u201d.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Sau khi ch\u1ecdn Split, b\u1ea1n s\u1ebd th\u1ea5y d\u00f2ng ti\u00eau \u0111\u1ec1 kh\u00f4ng h\u1ec1 di chuy\u1ec3n khi b\u1ea1n cu\u1ed9n chu\u1ed9t. Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u00e3 th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng m\u1eb9o nh\u1ecf n\u00e0y r\u1ed3i.\u00a0<\/span><\/p>\n<figure id=\"attachment_13083\" aria-describedby=\"caption-attachment-13083\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13083 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel-3.jpg\" alt=\"Gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel \u0111\u01a1n gi\u1ea3n v\u1edbi ch\u1ee9c n\u0103ng Split\u00a0\" width=\"600\" height=\"259\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel-3-400x173.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13083\" class=\"wp-caption-text\">Gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel \u0111\u01a1n gi\u1ea3n v\u1edbi ch\u1ee9c n\u0103ng Split<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cach_giu_tieu_de_trong_Excel_khi_in_don_gian\"><\/span><b>C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel khi in \u0111\u01a1n gi\u1ea3n\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Khi in m\u1ed9t file Excel v\u1edbi nhi\u1ec1u c\u1ed9t d\u1eef li\u1ec7u, gi\u1eef l\u1ea1i d\u00f2ng ti\u00eau \u0111\u1ec1 \u1edf \u0111\u1ea7u m\u1ed7i trang l\u00e0 m\u1ed9t \u0111i\u1ec1u v\u00f4 c\u00f9ng c\u1ea7n thi\u1ebft. Nh\u01b0 v\u1eady, b\u1ea1n s\u1ebd kh\u00f4ng c\u1ea7n ghi l\u1ea1i hay ch\u1ec9nh s\u1eeda l\u1ea1i ti\u00eau \u0111\u1ec1 \u1edf t\u1eebng trang. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u0111\u1ed1i chi\u1ebfu d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c in \u1edf trang sau v\u1edbi ti\u00eau \u0111\u1ec1 ngay \u0111\u1ea7u trang. B\u1ea1n kh\u00f4ng c\u1ea7n l\u1eadt l\u1ea1i ph\u00eda tr\u01b0\u1edbc v\u00e0 thu\u1eadn ti\u1ec7n khi in d\u1eef li\u1ec7u tr\u00ean nhi\u1ec1u c\u1ee1 gi\u1ea5y.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m theo c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel sau \u0111\u00e2y c\u1ee7a ch\u00fang t\u00f4i:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: M\u1edf file Excel b\u1ea1n c\u1ea7n in v\u00e0 t\u00ecm ch\u1ecdn tab Page Layout tr\u00ean thanh c\u00f4ng c\u1ee5.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ch\u1ecdn Print Titles trong tab Page Layout. H\u1ed9p tho\u1ea1i Page Setup s\u1ebd xu\u1ea5t hi\u1ec7n.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: T\u1ea1i h\u1ed9p tho\u1ea1i Page Setup, b\u1ea1n c\u00f3 2 l\u1ef1a ch\u1ecdn sau:<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">+ Ch\u1ecdn \u201cRows to repeat at top\u201d n\u1ebfu mu\u1ed1n gi\u1eef l\u1ea1i ti\u00eau \u0111\u1ec1 theo h\u00e0ng ngang. Sau \u0111\u00f3, b\u1ea1n b\u1ea5m v\u00e0o \u00f4 vu\u00f4ng \u1edf cu\u1ed1i d\u00f2ng v\u00e0 r\u00ea chu\u1ed9t ch\u1ecdn v\u00f9ng c\u00f3 ch\u1ee9a d\u00f2ng ti\u00eau \u0111\u1ec1 c\u1ea7n gi\u1eef. Ho\u1eb7c, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ghi tr\u1ef1c ti\u1ebfp \u0111\u1ecba ch\u1ec9 v\u00f9ng \u00f4 c\u00f3 ch\u1ee9a ti\u00eau \u0111\u1ec1 v\u00e0o \u00f4 tr\u1eafng t\u1ea1i d\u00f2ng n\u00e0y.\u00a0<\/span><\/p>\n<figure id=\"attachment_13085\" aria-describedby=\"caption-attachment-13085\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13085 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel-4.jpg\" alt=\"C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel khi in \u0111\u01a1n gi\u1ea3n\u00a0\" width=\"600\" height=\"337\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel-4-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13085\" class=\"wp-caption-text\">C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel khi in \u0111\u01a1n gi\u1ea3n<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">+ Ch\u1ecdn \u201cColumns to repeat at left\u201d n\u1ebfu b\u1ea1n mu\u1ed1n gi\u1eef d\u00f2ng ti\u00eau \u0111\u1ec1 d\u1ea1ng c\u1ed9t. Sau \u0111\u00f3 b\u1ea1n c\u0169ng l\u00e0m t\u01b0\u01a1ng t\u1ef1 c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 theo h\u00e0ng.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Sau khi ho\u00e0n th\u00e0nh ch\u1ecdn v\u00f9ng c\u1ea7n gi\u1eef, b\u1ea1n h\u00e3y c\u1ea9n th\u1eadn ki\u1ec3m tra l\u1ea1i. Nh\u1ea5n ch\u1ecdn \u201cPrint Preview\u201d \u1edf cu\u1ed1i h\u1ed9p tho\u1ea1i Page Setup. Ti\u1ebfp theo, nh\u1ea5p ch\u1ecdn\u201dOK\u201d \u0111\u1ec3 l\u01b0u l\u1ea1i c\u00e1c b\u01b0\u1edbc \u0111\u00e3 th\u1ef1c hi\u1ec7n xong.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Ho\u00e0n th\u00e0nh t\u1ea5t c\u1ea3 c\u00e1c b\u01b0\u1edbc tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y t\u1ea1i trang hai tr\u1edf v\u1ec1 sau \u0111\u1ec1u c\u00f3 ti\u00eau \u0111\u1ec1 \u1edf \u0111\u1ea7u trang ch\u1ee9 kh\u00f4ng ri\u00eang g\u00ec trang th\u1ee9 nh\u1ea5t. Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u00e3 ho\u00e0n th\u00e0nh gi\u1eef l\u1ea1i ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u Excel khi in r\u1ed3i.\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_giu_tieu_de_trong_Excel_bang_cach_chuyen_vung_du_lieu_thanh_bang\"><\/span><b>C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel b\u1eb1ng c\u00e1ch chuy\u1ec3n v\u00f9ng d\u1eef li\u1ec7u th\u00e0nh b\u1ea3ng\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">M\u1ed9t th\u1ee7 thu\u1eadt \u0111\u01a1n gi\u1ea3n ti\u1ebfp theo \u0111\u1ec3 gi\u1eef nguy\u00ean ti\u00eau \u0111\u1ec1 trong khi l\u00e0m vi\u1ec7c l\u00e0 chuy\u1ec3n v\u00f9ng d\u1eef li\u1ec7u \u0111ang s\u1eed d\u1ee5ng\u00a0 v\u1ec1 d\u1ea1ng b\u1ea3ng. Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y \u0111\u01a1n gi\u1ea3n v\u00e0 c\u0169ng mang l\u1ea1i hi\u1ec7u qu\u1ea3 r\u1ea5t t\u1ed1t nh\u01b0 c\u00e1c c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel b\u00ean tr\u00ean.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n th\u1ee7 thu\u1eadt n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m theo c\u00e1c b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n sau:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n chuy\u1ec3n th\u00e0nh b\u1ea3ng. B\u1ea1n h\u00e3y ch\u00fa \u00fd ch\u1ecdn lu\u00f4n c\u1ea3 v\u00f9ng ch\u1ee9a d\u00f2ng ti\u00eau \u0111\u1ec1.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ch\u1ecdn tab \u201cInsert\u201d tr\u00ean thanh c\u00f4ng c\u1ee5 v\u00e0 ch\u1ecdn m\u1ee5c \u201cTable\u201d trong tab. H\u1ed9p tho\u1ea1i Create Table s\u1ebd xu\u1ea5t hi\u1ec7n tr\u00ean m\u00e0n h\u00ecnh.\u00a0\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Trong tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng c\u00f3 \u0111\u1ecba ch\u1ec9 v\u00f9ng c\u1ea7n chuy\u1ec3n tr\u00ean h\u1ed9p tho\u1ea1i Create Table. B\u1ea1n c\u1ea7n \u0111i\u1ec1n \u0111\u1ecba ch\u1ec9 v\u00f9ng c\u1ea7n chuy\u1ec3n v\u00e0o khung tr\u1ed1ng. Ho\u1eb7c b\u1ea5m v\u00e0o \u00f4 vu\u00f4ng \u1edf cu\u1ed1i d\u00f2ng \u0111\u1ec3 ch\u1ecdn v\u00f9ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: T\u00edch v\u00e0o \u00f4 vu\u00f4ng tr\u01b0\u1edbc d\u00f2ng \u201cMy table has headers\u201d v\u00e0 ch\u1ecdn \u201cOK\u201d.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_13086\" aria-describedby=\"caption-attachment-13086\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13086 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel-5.jpg\" alt=\"C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel b\u1eb1ng c\u00e1ch chuy\u1ec3n v\u00f9ng d\u1eef li\u1ec7u th\u00e0nh b\u1ea3ng\u00a0\" width=\"600\" height=\"366\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel-5.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel-5-400x244.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13086\" class=\"wp-caption-text\">C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel b\u1eb1ng c\u00e1ch chuy\u1ec3n v\u00f9ng d\u1eef li\u1ec7u th\u00e0nh b\u1ea3ng<\/figcaption><\/figure>\n<p><strong>&gt;&gt;&gt; XEM TH\u00caM:\u00a0<\/strong><\/p>\n<ul>\n<li><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/cai-dat-dau-cham-trong-excel\/\"><strong>C\u00e0i \u0111\u1eb7t d\u1ea5u ch\u1ea5m trong excel trong gi\u00e2y l\u00e1t v\u1edbi m\u1eb9o sau<\/strong><\/a><\/span><\/li>\n<li><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/\"><strong>C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n<\/strong><\/a><\/span><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/freeze-panes-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u1ed1 \u0111\u1ecbnh c\u1ed9t, h\u00e0ng v\u1edbi Freeze Panes trong excel \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/hoc-cach-giu-binh-tinh\/\" target=\"_blank\" rel=\"noopener\">4 b\u01b0\u1edbc hi\u1ec7u qu\u1ea3 nh\u1ea5t \u0111\u1ec3 h\u1ecdc c\u00e1ch gi\u1eef b\u00ecnh t\u0129nh &#8211; Teky<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/truy-cap-vao-bios\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u00e0o Bios \u0111\u01a1n gi\u1ea3n tr\u00ean nhi\u1ec1u d\u00f2ng m\u00e1y t\u00ednh.<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng nh\u1ea5t<\/a><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng c\u00e1ch gi\u1eef thanh ti\u00eau \u0111\u1ec1 trong excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n nh\u1ea5t m\u00e0 b\u1ea5t c\u1ee9 nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng n\u00e0o c\u0169ng \u0111\u1ec1u n\u00ean bi\u1ebft. N\u1ebfu b\u1ea1n th\u01b0\u1eddng xuy\u00ean ph\u1ea3i l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh Excel c\u00f3 nhi\u1ec1u d\u1eef li\u1ec7u, h\u00e3y h\u1ecdc ngay nh\u1eefng th\u1ee7 thu\u1eadt tr\u00ean \u0111\u1ec3 hi\u1ec7u qu\u1ea3 c\u00f4ng vi\u1ec7c t\u1ed1t h\u01a1n v\u00e0 mau ch\u00f3ng \u0111\u01b0\u1ee3c t\u0103ng l\u01b0\u01a1ng nh\u00e9.\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel ra sao? Th\u1ef1c t\u1ebf, khi d\u1eef li\u1ec7u trong b\u1ea3ng Excel l\u00ean \u0111\u1ebfn h\u00e0ng tr\u0103m hay h\u00e0ng ngh\u00ecn d\u00f2ng. M\u1ed7i l\u1ea7n di chuy\u1ec3n \u0111\u1ebfn trang kh\u00e1c, d\u00f2ng ti\u00eau \u0111\u1ec1 s\u1ebd d\u1ec5 b\u1ecb che l\u1ea5p \u0111i. \u0110i\u1ec1u n\u00e0y g\u00e2y r\u1ea5t nhi\u1ec1u kh\u00f3 kh\u0103n cho ng\u01b0\u1eddi d\u00f9ng trong vi\u1ec7c nh\u1edb v\u00e0 nh\u1eadp &hellip;<\/p>\n","protected":false},"author":3,"featured_media":13073,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-13072","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Top 3+ c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n<\/title>\n<meta name=\"description\" content=\"Top 3+ c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a TEKY gi\u00fap c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n tr\u1edf n\u00ean su\u00f4n s\u1ebb h\u01a1n. C\u00f9ng theo d\u00f5i ngay n\u00e0o!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Top 3+ c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n\" \/>\n<meta property=\"og:description\" content=\"Top 3+ c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a TEKY gi\u00fap c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n tr\u1edf n\u00ean su\u00f4n s\u1ebb h\u01a1n. C\u00f9ng theo d\u00f5i ngay n\u00e0o!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-23T01:33:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-20T07:35:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"337\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"3+ C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n m\u1edbi nh\u1ea5t\",\"datePublished\":\"2022-11-23T01:33:29+00:00\",\"dateModified\":\"2026-01-20T07:35:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/\"},\"wordCount\":2012,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel.png\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/\",\"name\":\"Top 3+ c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel.png\",\"datePublished\":\"2022-11-23T01:33:29+00:00\",\"dateModified\":\"2026-01-20T07:35:59+00:00\",\"description\":\"Top 3+ c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a TEKY gi\u00fap c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n tr\u1edf n\u00ean su\u00f4n s\u1ebb h\u01a1n. C\u00f9ng theo d\u00f5i ngay n\u00e0o!\",\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel.png\",\"width\":600,\"height\":337,\"caption\":\"top 3+ c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Top 3+ c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n","description":"Top 3+ c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a TEKY gi\u00fap c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n tr\u1edf n\u00ean su\u00f4n s\u1ebb h\u01a1n. C\u00f9ng theo d\u00f5i ngay n\u00e0o!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"Top 3+ c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n","og_description":"Top 3+ c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a TEKY gi\u00fap c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n tr\u1edf n\u00ean su\u00f4n s\u1ebb h\u01a1n. C\u00f9ng theo d\u00f5i ngay n\u00e0o!","og_url":"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-23T01:33:29+00:00","article_modified_time":"2026-01-20T07:35:59+00:00","og_image":[{"width":600,"height":337,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel.png","type":"image\/png"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"9 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"3+ C\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n m\u1edbi nh\u1ea5t","datePublished":"2022-11-23T01:33:29+00:00","dateModified":"2026-01-20T07:35:59+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/"},"wordCount":2012,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel.png","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/","name":"Top 3+ c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel.png","datePublished":"2022-11-23T01:33:29+00:00","dateModified":"2026-01-20T07:35:59+00:00","description":"Top 3+ c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a TEKY gi\u00fap c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n tr\u1edf n\u00ean su\u00f4n s\u1ebb h\u01a1n. C\u00f9ng theo d\u00f5i ngay n\u00e0o!","inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-giu-tieu-de-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Cach-giu-tieu-de-trong-Excel.png","width":600,"height":337,"caption":"top 3+ c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n"},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13072","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=13072"}],"version-history":[{"count":1,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13072\/revisions"}],"predecessor-version":[{"id":29833,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13072\/revisions\/29833"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/13073"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=13072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=13072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=13072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}