{"id":13265,"date":"2022-11-03T21:06:44","date_gmt":"2022-11-03T14:06:44","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=13265"},"modified":"2022-12-13T14:41:49","modified_gmt":"2022-12-13T07:41:49","slug":"cach-an-cot-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/","title":{"rendered":"C\u00e1ch \u1ea9n c\u1ed9t trong Excel H\u01b0\u1edbng d\u1eabn chi ti\u1ebft 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;13265&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;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;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;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1ch \u1ea9n c\u1ed9t trong Excel H\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u1ea5t&quot;,&quot;width&quot;:&quot;142.5&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: 142.5px;\">\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            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em><span style=\"font-weight: 400;\">Excel l\u00e0 m\u1ed9t trong nh\u1eefng t\u00ednh n\u0103ng h\u1ed7 tr\u1ee3 trong c\u00f4ng vi\u1ec7c r\u1ea5t nhi\u1ec1u. C\u00e1c thao t\u00e1c t\u00ednh to\u00e1n hay l\u1eadp b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n \u1edf \u0111\u00e2y v\u00f4 c\u00f9ng d\u1ec5 d\u00e0ng. B\u00ean c\u1ea1nh c\u00e1c thao t\u00e1c th\u00f4ng th\u01b0\u1eddng th\u00ec \u1ea9n hay hi\u1ec7n c\u1ed9t trong Excel c\u0169ng \u0111\u01b0\u1ee3c m\u1ecdi ng\u01b0\u1eddi s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn. V\u1eady c\u00e1ch \u1ea9n c\u1ed9t trong Excel l\u00e0 g\u00ec? C\u00f9ng teky.edu.vn t\u00ecm hi\u1ec3u c\u00e1ch \u1ea9n c\u1ed9t trong excel chi ti\u1ebft v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5t nh\u00e9.<\/span><\/em><\/p>\n<p style=\"text-align: justify;\"><!--more--><\/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-an-cot-trong-excel\/#Huong_dan_cach_an_cot_trong_Excel\" >H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#Huong_dan_cach_an_sheet_trong_Excel\" >H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n sheet trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#Cach_de_an_hoac_hien_cot_va_hang_theo_nhom_tai_Excel\" >C\u00e1ch \u0111\u1ec3 \u1ea9n ho\u1eb7c hi\u1ec7n c\u1ed9t v\u00e0 h\u00e0ng theo nh\u00f3m t\u1ea1i Excel<\/a><\/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-an-cot-trong-excel\/#Cac_cach_hien_thi_cot_da_bi_an\" >C\u00e1c c\u00e1ch hi\u1ec3n th\u1ecb c\u1ed9t \u0111\u00e3 b\u1ecb \u1ea9n<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#Cach_hien_thi_cot_bang_Go_To_va_Format\" >C\u00e1ch hi\u1ec3n th\u1ecb c\u1ed9t b\u1eb1ng Go To v\u00e0 Format<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#Cach_hien_thi_cot_bang_cach_mo_rong_cot_da_bi_an\" >C\u00e1ch hi\u1ec3n th\u1ecb c\u1ed9t b\u1eb1ng c\u00e1ch m\u1edf r\u1ed9ng c\u1ed9t \u0111\u00e3 b\u1ecb \u1ea9n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#Hien_thi_cot_bang_tuy_chon_Go_To_Special\" >Hi\u1ec3n th\u1ecb c\u1ed9t b\u1eb1ng t\u00f9y ch\u1ecdn Go To Special<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#Cach_de_tat_tuy_chon_bo_an_cot\" >C\u00e1ch \u0111\u1ec3 t\u1eaft t\u00f9y ch\u1ecdn b\u1ecf \u1ea9n c\u1ed9t<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#Buoc_thu_nhat\" >B\u01b0\u1edbc th\u1ee9 nh\u1ea5t<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#Buoc_thu_2\" >B\u01b0\u1edbc th\u1ee9 2<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#Buoc_thu_3\" >B\u01b0\u1edbc th\u1ee9 3<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#Buoc_thu_4\" >B\u01b0\u1edbc th\u1ee9 4<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#Buoc_thu_5\" >B\u01b0\u1edbc th\u1ee9 5<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#Buoc_thu_6\" >B\u01b0\u1edbc th\u1ee9 6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#Buoc_thu_7\" >B\u01b0\u1edbc th\u1ee9 7<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#Buoc_thu_8\" >B\u01b0\u1edbc th\u1ee9 8<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Huong_dan_cach_an_cot_trong_Excel\"><\/span><strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><iframe loading=\"lazy\" title=\"H\u01b0\u1edbng d\u1eabn \u1ea8n &amp; Hi\u1ec7n c\u1ed9t v\u00e0 d\u00f2ng trong excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/Bx5o2gpAt4w?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<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch \u1ea9n hi\u1ec7n c\u1ed9t trong Excel c\u0169ng \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n v\u00f4 c\u00f9ng d\u1ec5 d\u00e0ng. B\u1ea1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc c\u1ee5 th\u1ec3 nh\u01b0 sau: B\u1ea1n ti\u1ebfn h\u00e0nh b\u00f4i \u0111en nh\u1eefng c\u1ed9t m\u00e0 b\u1ea1n c\u1ea7n mu\u1ed1n \u1ea9n. Sau \u0111\u00f3 h\u00e3y nh\u1ea5n chu\u1ed9t ph\u1ea3i. Ti\u1ebfp \u0111\u1ebfn h\u00e3y ch\u1ecdn Hide ho\u1eb7c Unhide \u0111\u1ec3 \u1ea9n ho\u1eb7c hi\u1ec7n c\u1ed9t.<\/span><\/p>\n<figure id=\"attachment_13266\" aria-describedby=\"caption-attachment-13266\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13266 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/1-8.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"412\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/1-8.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/1-8-400x275.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13266\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Huong_dan_cach_an_sheet_trong_Excel\"><\/span><strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n sheet trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch \u0111\u1ec3 \u1ea9n sheet trong Excel c\u0169ng v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n. \u0110\u1ec3 \u1ea9n b\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc \u0111\u1ea7u ti\u00ean: B\u1ea1n ti\u1ebfn h\u00e0nh ch\u1ecdn c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n \u1ea9n. Ti\u1ebfp \u0111\u1ebfn v\u00e0o th\u1ebb Home.<\/span><\/p>\n<figure id=\"attachment_13267\" aria-describedby=\"caption-attachment-13267\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13267 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/2-8.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"320\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/2-8.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/2-8-400x213.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13267\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc th\u1ee9 2: Sau khi th\u1ef1c hi\u1ec7n c\u00e1c l\u1ec7nh nh\u01b0 tr\u00ean b\u1ea1n h\u00e3y v\u00e0o <strong>Format<\/strong> v\u00e0 ch\u1ecdn <strong>hide &amp; Unhide<\/strong>. Sau \u0111\u00f3 ti\u1ebfn h\u00e0nh ch\u1ecdn \u1ea9n ho\u1eb7c hi\u1ec7n sheet m\u00e0 b\u1ea1n mong mu\u1ed1n. <\/span><\/p>\n<figure id=\"attachment_13268\" aria-describedby=\"caption-attachment-13268\" style=\"width: 520px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13268 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/3-8.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"520\" height=\"450\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/3-8.png 520w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/3-8-400x346.png 400w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><figcaption id=\"caption-attachment-13268\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi hai b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n nh\u01b0 tr\u00ean v\u1eady l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 \u1ea9n sheet trong <a href=\"https:\/\/www.office.com\/\" rel=\"nofollow noreferrer\">Excel<\/a>.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_de_an_hoac_hien_cot_va_hang_theo_nhom_tai_Excel\"><\/span><strong>C\u00e1ch \u0111\u1ec3 \u1ea9n ho\u1eb7c hi\u1ec7n c\u1ed9t v\u00e0 h\u00e0ng theo nh\u00f3m t\u1ea1i Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 \u1ea9n ho\u1eb7c hi\u1ec7n c\u1ed9t v\u00e0 h\u00e0ng theo nh\u00f3m th\u00ec b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc \u0111\u1ea7u ti\u00ean: b\u1ea1n h\u00e3y b\u00f4i \u0111en c\u1ed9t ho\u1eb7c h\u00e0ng m\u00e0 b\u1ea1n mu\u1ed1n \u1ea9n. Sau \u0111\u00f3 b\u1ea1n h\u00e3y v\u00e0o th\u1ebb Data. <\/span><\/p>\n<figure id=\"attachment_13269\" aria-describedby=\"caption-attachment-13269\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13269 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/4-7.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"409\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/4-7.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/4-7-400x273.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13269\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc th\u1ee9 2: Ti\u1ebfp \u0111\u1ebfn b\u1ea1n h\u00e3y ch\u1ecdn Group<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc th\u1ee9 3: B\u1ea1n ti\u1ebfn h\u00e0nh nh\u1ea5n d\u1ea5u tr\u1eeb ho\u1eb7c d\u1ea5u c\u1ed9ng c\u1ee7a khung \u0111\u1ec3 \u1ea9n ho\u1eb7c hi\u1ec7n nh\u00f3m h\u00e0ng ho\u1eb7c c\u1ed9t m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ecdn tr\u01b0\u1edbc \u0111\u00f3. <\/span><\/p>\n<figure id=\"attachment_13270\" aria-describedby=\"caption-attachment-13270\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13270 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/5-8.png\" alt=\"H\u01b0\u1edbng d\u1eabn \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t\" width=\"600\" height=\"331\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/5-8.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/5-8-400x221.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13270\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t l\u01b0u \u00fd \u1edf b\u01b0\u1edbc n\u00e0y l\u00e0 trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n b\u1ecf t\u00ednh n\u0103ng \u1ea9n c\u1ed9t theo nh\u00f3m. b\u1ea1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n thao t\u00e1c \u1ea5n v\u00e0o Ungroup ngay b\u00ean c\u1ea1nh c\u1ee7a Group.\u00a0<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cac_cach_hien_thi_cot_da_bi_an\"><\/span><strong>C\u00e1c c\u00e1ch hi\u1ec3n th\u1ecb c\u1ed9t \u0111\u00e3 b\u1ecb \u1ea9n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh c\u00e1c c\u00e1ch \u1ea9n c\u1ed9t \u0111\u00e3 \u0111\u01b0\u1ee3c Teky.edu.vn h\u01b0\u1edbng d\u1eabn nh\u01b0 tr\u00ean. Sau \u0111\u00e2y Teky.edu.vn s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch b\u1ecf \u1ea9n c\u1ed9t trong Excel. C\u00f9ng theo d\u00f5i \u0111\u1ec3 bi\u1ebft c\u00e1ch l\u00e0m ngay nh\u00e9.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_hien_thi_cot_bang_Go_To_va_Format\"><\/span><strong>C\u00e1ch hi\u1ec3n th\u1ecb c\u1ed9t b\u1eb1ng Go To v\u00e0 Format<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u1ed9t theo Go To v\u00e0 Format c\u0169ng r\u1ea5t \u0111\u01a1n gi\u1ea3n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc \u0111\u1ea7u ti\u00ean: Sau khi \u0111\u00e3 m\u1edf file m\u00e0 b\u1ea1n mu\u1ed1n \u0111i\u1ec1u ch\u1ec9nh. \u0110\u1ea7u ti\u00ean b\u1ea1n h\u00e3y v\u00e0o th\u1ebb Home t\u1ea1i thanh c\u00f4ng c\u1ee5. T\u1ea1i m\u1ee5c <strong>Editing<\/strong>, b\u1ea1n ti\u1ebfn h\u00e0nh\u00a0 ch\u1ecdn <strong>Find &amp; Select<\/strong> v\u00e0 ch\u1ecdn <strong>Go to<\/strong>.<\/span><\/p>\n<figure id=\"attachment_13272\" aria-describedby=\"caption-attachment-13272\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13272 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/6-4.png\" alt=\"C\u00e1ch hi\u1ec3n th\u1ecb c\u1ed9t b\u1eb1ng Go To v\u00e0 Format\" width=\"600\" height=\"450\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/6-4.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/6-4-400x300.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13272\" class=\"wp-caption-text\">C\u00e1ch hi\u1ec3n th\u1ecb c\u1ed9t b\u1eb1ng Go To v\u00e0 Format<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc th\u1ee9 2: Sau khi b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c l\u1ec7nh nh\u01b0 \u1edf b\u01b0\u1edbc 1. C\u1eeda s\u1ed5 Go To s\u1ebd xu\u1ea5t hi\u1ec7n. t\u1ea1i m\u1ee5c Reference, b\u1ea1n h\u00e3y nh\u1eadp 1 \u00f4 trong c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb l\u1ea1i. \u1ede v\u00ed d\u1ee5 n\u00e0y th\u00ec c\u1ed9t J \u0111ang b\u1ecb \u1ea9n n\u00ean nh\u1eadp J1 v\u00ec J1 l\u00e0 \u00f4 thu\u1ed9c c\u1ed9t J. Sau \u0111\u00f3, nh\u1ea5n OK l\u00e0 \u00f4 J1 \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn. <\/span><\/p>\n<figure id=\"attachment_13273\" aria-describedby=\"caption-attachment-13273\" style=\"width: 512px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13273 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/7-4.png\" alt=\"C\u00e1ch hi\u1ec3n th\u1ecb c\u1ed9t b\u1eb1ng Go To v\u00e0 Format\" width=\"512\" height=\"450\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/7-4.png 512w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/7-4-400x352.png 400w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><figcaption id=\"caption-attachment-13273\" class=\"wp-caption-text\">C\u00e1ch hi\u1ec3n th\u1ecb c\u1ed9t b\u1eb1ng Go To v\u00e0 Format<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc\u00a0 th\u1ee9 3: Ti\u1ebfp \u0111\u1ebfn \u1edf th\u1ebb Home t\u1ea1i thanh c\u00f4ng c\u1ee5 b\u1ea1n h\u00e3y ch\u1ecdn Format trong m\u1ee5c Cells. Sau \u0111\u00f3 ti\u1ebfn h\u00e0nh ch\u1ecdn Hide &amp; Unhide. Ti\u1ebfp \u0111\u1ebfn h\u00e3y ch\u1ecdn Unhide Columns l\u00e0 c\u1ed9t b\u1ecb \u1ea9n s\u1ebd hi\u1ec3n th\u1ecb l\u1ea1i, c\u1ee5 th\u1ec3 trong b\u00e0i h\u01b0\u1edbng d\u1eabn l\u00e0 c\u1ed9t J. <\/span><\/p>\n<figure id=\"attachment_13275\" aria-describedby=\"caption-attachment-13275\" style=\"width: 497px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13275 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/8-4.png\" alt=\"C\u00e1ch hi\u1ec3n th\u1ecb c\u1ed9t b\u1eb1ng Go To v\u00e0 Format\" width=\"497\" height=\"450\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/8-4.png 497w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/8-4-400x362.png 400w\" sizes=\"auto, (max-width: 497px) 100vw, 497px\" \/><figcaption id=\"caption-attachment-13275\" class=\"wp-caption-text\">C\u00e1ch hi\u1ec3n th\u1ecb c\u1ed9t b\u1eb1ng Go To v\u00e0 Format<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_hien_thi_cot_bang_cach_mo_rong_cot_da_bi_an\"><\/span><strong>C\u00e1ch hi\u1ec3n th\u1ecb c\u1ed9t b\u1eb1ng c\u00e1ch m\u1edf r\u1ed9ng c\u1ed9t \u0111\u00e3 b\u1ecb \u1ea9n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh c\u00e1ch v\u1eeba h\u01b0\u1edbng d\u1eabn tr\u00ean, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb c\u1ed9t \u0111\u00e3 b\u1ecb \u1ea9n b\u1eb1ng c\u00e1ch sau \u0111\u00e2y.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc \u0111\u1ea7u ti\u00ean: B\u1ea1n ti\u1ebfn h\u00e0nh m\u1edf file m\u00e0 b\u1ea1n mu\u1ed1n \u0111i\u1ec1u ch\u1ec9nh. Ti\u1ebfp \u0111\u1ebfn h\u00e3y di chuy\u1ec3n chu\u1ed9t v\u00e0o ngay gi\u1eefa c\u1ed9t tr\u00e1i v\u00e0 c\u1ed9t ph\u1ea3i c\u1ee7a c\u1ed9t b\u1ecb \u1ea9n cho \u0111\u1ebfn khi m\u0169i t\u00ean chu\u1ed9t h\u01b0\u1edbng v\u1ec1 2 ph\u00eda nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc th\u1ee9 2: Ti\u1ebfp \u0111\u1ebfn h\u00e3n h\u00e3y nh\u1ea5n gi\u1eef v\u00e0 k\u00e9o chu\u1ed9t sang ph\u1ea3i \u0111\u1ec3 c\u00e1c c\u1ed9t b\u1ecb \u1ea9n s\u1ebd \u0111\u01b0\u1ee3c m\u1edf r\u1ed9ng v\u00e0 hi\u1ec3n th\u1ecb.\u00a0<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Hien_thi_cot_bang_tuy_chon_Go_To_Special\"><\/span><strong>Hi\u1ec3n th\u1ecb c\u1ed9t b\u1eb1ng t\u00f9y ch\u1ecdn Go To Special<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n b\u1ea1n s\u1ebd l\u00e0m nh\u01b0 sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc \u0111\u1ea7u ti\u00ean: b\u1ea1n h\u00e3y v\u00e0o th\u1ebbo Home t\u1ea1i thanh c\u00f4ng c\u1ee5. t\u1ea1i m\u1ee5c Editing b\u1ea1n ch\u1ecdn Find &amp; Select v\u00e0 ch\u1ecdn Go To Special.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc th\u1ee9 2: Sau khi th\u1ef1c hi\u1ec7n c\u00e1c l\u1ec7nh tr\u00ean th\u1ecb c\u1eeda s\u1ed5 Go To Special xu\u1ea5t hi\u1ec7n, b\u1ea1n ch\u1ecdn Visible cells only v\u00e0 nh\u1ea5n OK.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc th\u1ee9 3: Khi th\u1ef1c hi\u1ec7n xong c\u00e1c l\u1ec7nh nh\u01b0 tr\u00ean th\u00ec \u0111\u01b0\u1eddng vi\u1ec1n \u1edf c\u1ed9t b\u1ecb \u1ea9n s\u1ebd b\u1ecb b\u00f4i tr\u1eafng \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn di\u1ec7n. Ti\u1ebfp \u0111\u1ebfn b\u1ea1n h\u00e3y di chuy\u1ec3n chu\u1ed9t v\u00e0 m\u1edf r\u1ed9ng r\u1ed9t \u0111\u00f3.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_de_tat_tuy_chon_bo_an_cot\"><\/span><strong>C\u00e1ch \u0111\u1ec3 t\u1eaft t\u00f9y ch\u1ecdn b\u1ecf \u1ea9n c\u1ed9t<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1eeba r\u1ed3i l\u00e0 nh\u1eefng c\u00e1ch \u1ea9n c\u1ed9t, sau \u0111\u00e2y teky.edu.vn s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ec3 t\u1eaft t\u00f9y ch\u1ecdn b\u1ecf \u1ea9n c\u1ed9t. V\u1edbi c\u00e1ch n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00e1ch b\u1ecf \u1ea9n c\u1ed9t \u0111\u1ea7u ti\u00ean trong Excel. Ho\u1eb7c b\u1ea5t c\u1ee9 c\u1ed9t n\u00e0o m\u00e0 b\u1ea1n mong mu\u1ed1n. C\u00e1ch th\u1ee9c th\u1ef1c hi\u1ec7n c\u0169ng v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_thu_nhat\"><\/span><span style=\"font-weight: 400;\">B\u01b0\u1edbc th\u1ee9 nh\u1ea5t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"> B\u1ea1n h\u00e3y nh\u1ea5n v\u00e0o t\u1ed5 h\u1ee3p ph\u00edm Ctrl + A \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 trang t\u00ednh. Ti\u1ebfp \u0111\u1ebfn b\u1ea1n h\u00e3y nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Format Cells.<\/span><\/p>\n<figure id=\"attachment_13276\" aria-describedby=\"caption-attachment-13276\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13276 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/9-3.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1eaft t\u00f9y ch\u1ecdn b\u1ecf \u1ea9n c\u1ed9t trong excel\" width=\"600\" height=\"423\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/9-3.png 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/9-3-400x282.png 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13276\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1eaft t\u00f9y ch\u1ecdn b\u1ecf \u1ea9n c\u1ed9t trong excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_thu_2\"><\/span><span style=\"font-weight: 400;\">B\u01b0\u1edbc th\u1ee9 2<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"> Sau khi th\u1ef1c hi\u1ec7n c\u00e1c l\u1ec7nh nh\u01b0 tr\u00ean th\u00ec c\u1eeda s\u1ed5 <a href=\"https:\/\/teky.edu.vn\/blog\/ham-left-trong-excel\/\">Format Cells<\/a> s\u1ebd hi\u1ec7n ra. B\u1ea1n h\u00e3y ch\u1ecdn v\u00e0o tab Protection v\u00e0 nh\u1ea5n b\u1ecf ch\u1ecdn Locked. Sau \u0111\u00f3, nh\u1ea5n OK \u0111\u1ec3 l\u01b0u thay \u0111\u1ed5i.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_thu_3\"><\/span><span style=\"font-weight: 400;\">B\u01b0\u1edbc th\u1ee9 3<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau \u0111\u00f3 b\u1ea1n h\u00e3y ch\u1ecdn c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n t\u1eaft t\u00f9y ch\u1ecdn \u1ea9n c\u1ed9t. R\u1ed3i nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o c\u1ed9t \u0111\u00f3 v\u00e0 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng Format Cells. <\/span><\/p>\n<figure id=\"attachment_13278\" aria-describedby=\"caption-attachment-13278\" style=\"width: 528px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13278 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/11.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1eaft t\u00f9y ch\u1ecdn b\u1ecf \u1ea9n c\u1ed9t trong excel\" width=\"528\" height=\"450\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/11.png 528w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/11-400x341.png 400w\" sizes=\"auto, (max-width: 528px) 100vw, 528px\" \/><figcaption id=\"caption-attachment-13278\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1eaft t\u00f9y ch\u1ecdn b\u1ecf \u1ea9n c\u1ed9t trong excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_thu_4\"><\/span><span style=\"font-weight: 400;\">B\u01b0\u1edbc th\u1ee9 4<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"> L\u00fac n\u00e0y c\u1eeda s\u1ed5 Format Cells xu\u1ea5t hi\u1ec7n, b\u1ea1n ch\u1ecdn v\u00e0o tab Protection v\u00e0 nh\u1ea5n ch\u1ecdn Locked. Sau \u0111\u00f3, nh\u1ea5n OK \u0111\u1ec3 l\u01b0u thay \u0111\u1ed5i.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_thu_5\"><\/span><span style=\"font-weight: 400;\">B\u01b0\u1edbc th\u1ee9 5<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"> Th\u1ef1c hi\u1ec7n \u1ea9n c\u1ed9t b\u1eb1ng c\u00e1ch nh\u1ea5p chu\u1ed9t ph\u1ea3i l\u00ean c\u1ed9t b\u1ea1n mu\u1ed1n \u1ea9n v\u00e0 ch\u1ecdn <a href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-loc-trong-excel-chi-tiet-nhat\/\">Hide<\/a>.<\/span><\/p>\n<figure id=\"attachment_13279\" aria-describedby=\"caption-attachment-13279\" style=\"width: 536px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13279 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/12.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1eaft t\u00f9y ch\u1ecdn b\u1ecf \u1ea9n c\u1ed9t trong excel\" width=\"536\" height=\"450\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/12.png 536w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/12-400x336.png 400w\" sizes=\"auto, (max-width: 536px) 100vw, 536px\" \/><figcaption id=\"caption-attachment-13279\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1eaft t\u00f9y ch\u1ecdn b\u1ecf \u1ea9n c\u1ed9t trong excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_thu_6\"><\/span><strong>B\u01b0\u1edbc th\u1ee9 6<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"> Tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ecdn Review v\u00e0 ch\u1ecdn Protect Sheet.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_thu_7\"><\/span><strong>B\u01b0\u1edbc th\u1ee9 7<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">H\u1ed9p tho\u1ea1i <strong>Protect Sheet<\/strong> hi\u1ec3n th\u1ecb, b\u1ea1n h\u00e3y nh\u1ea5p ch\u1ecdn v\u00e0o <strong>Select locked cells<\/strong> v\u00e0 <strong>Select unlocked cells,<\/strong> sau \u0111\u00f3 nh\u1eadp m\u1eadt kh\u1ea9u \u0111\u1ec3 b\u1ea3o v\u1ec7. <\/span><\/p>\n<figure id=\"attachment_13281\" aria-describedby=\"caption-attachment-13281\" style=\"width: 536px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13281 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/12-1.png\" alt=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1eaft t\u00f9y ch\u1ecdn b\u1ecf \u1ea9n c\u1ed9t trong excel\" width=\"536\" height=\"450\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/12-1.png 536w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/12-1-400x336.png 400w\" sizes=\"auto, (max-width: 536px) 100vw, 536px\" \/><figcaption id=\"caption-attachment-13281\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1eaft t\u00f9y ch\u1ecdn b\u1ecf \u1ea9n c\u1ed9t trong excel<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Buoc_thu_8\"><\/span><strong>B\u01b0\u1edbc th\u1ee9 8<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"> Nh\u1eadp m\u1eadt kh\u1ea9u m\u1ed9t l\u1ea7n n\u1eefa \u0111\u1ec3 x\u00e1c nh\u1eadn l\u1ea1i m\u1eadt kh\u1ea9u. V\u1eady l\u00e0 b\u1ea1n \u0111\u00e3 t\u1eaft t\u00f9y ch\u1ecdn b\u1ecf \u1ea9n c\u1ed9t th\u00e0nh c\u00f4ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1eeba r\u1ed3i l\u00e0 nh\u1eefng chia s\u1ebb v\u1ec1 c\u00e1ch \u1ea9n c\u1ed9t trong Excel. V\u1edbi nh\u1eefng th\u00f4ng tin do teky.edu.vn cung c\u1ea5p \u0111\u00e3 gi\u00fap \u00edch \u0111\u01b0\u1ee3c m\u1ecdi ng\u01b0\u1eddi. \u0110\u1ec3 bi\u1ebft th\u00eam nhi\u1ec1u m\u1eb9o hay v\u1ec1 tin h\u1ecdc h\u00e3y truy c\u1eadp ngay v\u00e0o webstie c\u1ee7a teky.edu.vn nh\u00e9.<\/span><\/p>\n<p><strong>Xem th\u00eam:\u00a0<\/strong><\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-them-cot-trong-excel\/\" target=\"_blank\" rel=\"noopener\">3 C\u00e1ch th\u00eam c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-khoa-cot-trong-excel\/\" target=\"_blank\" rel=\"noopener\">B\u1eadt m\u00ed c\u00e1ch kh\u00f3a c\u1ed9t trong Excel ch\u1ec9 trong m\u1ed9t n\u1ed1t nh\u1ea1c<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-doi-cot-trong-excel\/\" target=\"_blank\" rel=\"noopener\">Kh\u00e1m ph\u00e1 ngay 3 c\u00e1ch \u0111\u1ed5i c\u1ed9t trong Excel \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-cot-trong-excel-ma-ban-can-biet\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft\u00a0<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cac-cach-dinh-dang-ngay-thang-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1c c\u00e1ch \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng trong Excel si\u00eau \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Excel l\u00e0 m\u1ed9t trong nh\u1eefng t\u00ednh n\u0103ng h\u1ed7 tr\u1ee3 trong c\u00f4ng vi\u1ec7c r\u1ea5t nhi\u1ec1u. C\u00e1c thao t\u00e1c t\u00ednh to\u00e1n hay l\u1eadp b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n \u1edf \u0111\u00e2y v\u00f4 c\u00f9ng d\u1ec5 d\u00e0ng. B\u00ean c\u1ea1nh c\u00e1c thao t\u00e1c th\u00f4ng th\u01b0\u1eddng th\u00ec \u1ea9n hay hi\u1ec7n c\u1ed9t trong Excel c\u0169ng \u0111\u01b0\u1ee3c m\u1ecdi ng\u01b0\u1eddi s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn. V\u1eady &hellip;<\/p>\n","protected":false},"author":3,"featured_media":13283,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-13265","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>H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t 2022<\/title>\n<meta name=\"description\" content=\"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch \u1ea9n c\u1ed9t trong excel hay ch\u01b0a? t\u1ea1i sao ph\u1ea3i \u1ea9n c\u1ed9t, m\u1ee5c \u0111\u00edch \u1ea9n c\u1ed9t trong excel \u0111\u1ec3 l\u00e0m g\u00ec. H\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft nh\u00e9\" \/>\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-an-cot-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t 2022\" \/>\n<meta property=\"og:description\" content=\"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch \u1ea9n c\u1ed9t trong excel hay ch\u01b0a? t\u1ea1i sao ph\u1ea3i \u1ea9n c\u1ed9t, m\u1ee5c \u0111\u00edch \u1ea9n c\u1ed9t trong excel \u0111\u1ec3 l\u00e0m g\u00ec. H\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft nh\u00e9\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-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-03T14:06:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-13T07:41:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Huong-dan-cach-an-cot-trong-Excel-chi-tiet-nhat.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\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-an-cot-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch \u1ea9n c\u1ed9t trong Excel H\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u1ea5t\",\"datePublished\":\"2022-11-03T14:06:44+00:00\",\"dateModified\":\"2022-12-13T07:41:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/\"},\"wordCount\":2030,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Huong-dan-cach-an-cot-trong-Excel-chi-tiet-nhat.png\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t 2022\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Huong-dan-cach-an-cot-trong-Excel-chi-tiet-nhat.png\",\"datePublished\":\"2022-11-03T14:06:44+00:00\",\"dateModified\":\"2022-12-13T07:41:49+00:00\",\"description\":\"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch \u1ea9n c\u1ed9t trong excel hay ch\u01b0a? t\u1ea1i sao ph\u1ea3i \u1ea9n c\u1ed9t, m\u1ee5c \u0111\u00edch \u1ea9n c\u1ed9t trong excel \u0111\u1ec3 l\u00e0m g\u00ec. H\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft nh\u00e9\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Huong-dan-cach-an-cot-trong-Excel-chi-tiet-nhat.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Huong-dan-cach-an-cot-trong-Excel-chi-tiet-nhat.png\",\"width\":600,\"height\":400,\"caption\":\"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch \u1ea9n c\u1ed9t trong Excel H\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u1ea5t\"}]},{\"@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":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t 2022","description":"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch \u1ea9n c\u1ed9t trong excel hay ch\u01b0a? t\u1ea1i sao ph\u1ea3i \u1ea9n c\u1ed9t, m\u1ee5c \u0111\u00edch \u1ea9n c\u1ed9t trong excel \u0111\u1ec3 l\u00e0m g\u00ec. H\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft nh\u00e9","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-an-cot-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t 2022","og_description":"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch \u1ea9n c\u1ed9t trong excel hay ch\u01b0a? t\u1ea1i sao ph\u1ea3i \u1ea9n c\u1ed9t, m\u1ee5c \u0111\u00edch \u1ea9n c\u1ed9t trong excel \u0111\u1ec3 l\u00e0m g\u00ec. H\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft nh\u00e9","og_url":"https:\/\/teky.edu.vn\/blog\/cach-an-cot-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-03T14:06:44+00:00","article_modified_time":"2022-12-13T07:41:49+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Huong-dan-cach-an-cot-trong-Excel-chi-tiet-nhat.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-an-cot-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch \u1ea9n c\u1ed9t trong Excel H\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u1ea5t","datePublished":"2022-11-03T14:06:44+00:00","dateModified":"2022-12-13T07:41:49+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/"},"wordCount":2030,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Huong-dan-cach-an-cot-trong-Excel-chi-tiet-nhat.png","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/","name":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t 2022","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Huong-dan-cach-an-cot-trong-Excel-chi-tiet-nhat.png","datePublished":"2022-11-03T14:06:44+00:00","dateModified":"2022-12-13T07:41:49+00:00","description":"B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch \u1ea9n c\u1ed9t trong excel hay ch\u01b0a? t\u1ea1i sao ph\u1ea3i \u1ea9n c\u1ed9t, m\u1ee5c \u0111\u00edch \u1ea9n c\u1ed9t trong excel \u0111\u1ec3 l\u00e0m g\u00ec. H\u00e3y theo d\u00f5i ngay b\u00e0i vi\u1ebft nh\u00e9","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Huong-dan-cach-an-cot-trong-Excel-chi-tiet-nhat.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/Huong-dan-cach-an-cot-trong-Excel-chi-tiet-nhat.png","width":600,"height":400,"caption":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n c\u1ed9t trong Excel chi ti\u1ebft nh\u1ea5t"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-an-cot-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch \u1ea9n c\u1ed9t trong Excel H\u01b0\u1edbng d\u1eabn chi ti\u1ebft nh\u1ea5t"}]},{"@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\/13265","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=13265"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13265\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/13283"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=13265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=13265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=13265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}