{"id":11565,"date":"2022-11-15T11:35:03","date_gmt":"2022-11-15T04:35:03","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11565"},"modified":"2022-12-08T16:25:38","modified_gmt":"2022-12-08T09:25:38","slug":"cach-sap-xep-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eafp x\u1ebfp trong excel c\u00f3 kh\u00f3 nh\u01b0 l\u1eddi \u0111\u1ed3n kh\u00f4ng"},"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;11565&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 s\u1eafp x\u1ebfp trong excel c\u00f3 kh\u00f3 nh\u01b0 l\u1eddi \u0111\u1ed3n kh\u00f4ng&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;\">S\u1eed d\u1ee5ng b\u1ea3ng excel ng\u00e0y c\u00e0ng ph\u1ed5 bi\u1ebfn, r\u1ed9ng r\u00e3i b\u1edfi ch\u00fang thu\u1eadn ti\u1ec7n cho vi\u1ec7c theo d\u00f5i v\u00e0 tra c\u1ee9u c\u00e1c b\u1ea3ng danh s\u00e1ch. Tuy nhi\u00ean trong Excel kh\u00f4ng c\u00f3 t\u00ednh n\u0103ng t\u1ef1 \u0111\u1ed9ng s\u1eafp x\u1ebfp danh s\u00e1ch theo th\u1ee9 t\u1ef1 nh\u1ea5t \u0111\u1ecbnh. V\u00ec v\u1eady m\u00e0 sau \u0111\u00e2y l\u00e0 3 <strong>c\u00e1ch s\u1eafp x\u1ebfp trong excel<\/strong> m\u00e0 m\u00ecnh mu\u1ed1n gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n.<\/span><\/em><\/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-sap-xep-trong-excel\/#Cach_sap_xep_trong_excel_theo_thu_tu_ten_ABC\" >C\u00e1ch s\u1eafp x\u1ebfp trong excel theo th\u1ee9 t\u1ef1 t\u00ean ABC<\/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-sap-xep-trong-excel\/#Sap_xep_theo_kieu_tach_ho_ten_thanh_hai_cot_khac_nhau\" >S\u1eafp x\u1ebfp theo ki\u1ec3u t\u00e1ch h\u1ecd t\u00ean th\u00e0nh hai c\u1ed9t kh\u00e1c nhau<\/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-sap-xep-trong-excel\/#Sap_xep_ten_theo_kieu_tach_ho_va_ten_bang_Replace\" >S\u1eafp x\u1ebfp t\u00ean theo ki\u1ec3u t\u00e1ch h\u1ecd v\u00e0 t\u00ean b\u1eb1ng Replace<\/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-sap-xep-trong-excel\/#Cach_sap_xep_thu_tu_A_B_C_trong_Excel\" >C\u00e1ch s\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 A B C trong Excel<\/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-sap-xep-trong-excel\/#Cach_sap_xep_tang_dan_trong_excel\" >C\u00e1ch s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n trong excel<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_sap_xep_trong_excel_theo_thu_tu_ten_ABC\"><\/span><b>C\u00e1ch s\u1eafp x\u1ebfp trong excel theo th\u1ee9 t\u1ef1 t\u00ean ABC<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_11640\" aria-describedby=\"caption-attachment-11640\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11640 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-1.jpg\" alt=\"C\u00e1ch s\u1eafp x\u1ebfp trong excel theo th\u1ee9 t\u1ef1 t\u00ean ABC\" width=\"600\" height=\"337\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-1-400x225.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11640\" class=\"wp-caption-text\">C\u00e1ch s\u1eafp x\u1ebfp trong excel theo th\u1ee9 t\u1ef1 t\u00ean ABC<span style=\"font-size: 16px;\">\u00a0<\/span><\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc khi n\u00eau ra c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n c\u1ee7a c\u00e1ch s\u1eafp x\u1ebfp trong excel; ch\u00fang ta c\u1ea7n n\u1eafm v\u1eefng b\u1ea3n ch\u1ea5t c\u1ee7a ch\u00fang tr\u01b0\u1edbc. Tr\u00ean \u1ee9ng d\u1ee5ng n\u00e0y ch\u1ec9 c\u00f3 t\u00ednh n\u0103ng Sort\u00a0 A to Z ho\u1eb7c l\u00e0 Sort Z to A; c\u00e1ch s\u1eafp x\u1ebfp n\u00e0y \u0111\u1ec1u s\u1ebd d\u1ef1a v\u00e0o nh\u1eefng ch\u1eef c\u00e1i \u0111\u1ea7u d\u00f2ng c\u1ee7a \u00f4 ho\u1eb7c nh\u1eefng ch\u1eef c\u00e1i kh\u00e1c c\u00f9ng d\u00f2ng; \u0111\u1ec3 s\u1eafp x\u1ebfp \u00f4 \u0111\u00f3 theo th\u1ee9 t\u1ef1 c\u1ee7a b\u1ea3ng ch\u1eef c\u00e1i ho\u1eb7c ng\u01b0\u1ee3c l\u1ea1i.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u1ea3n ch\u1ea5t c\u00e1ch s\u1eafp x\u1ebfp trong excel: Excel l\u00e0 m\u1ed9t h\u1ec7 th\u1ed1ng qu\u1ed1c t\u1ebf; n\u00ean m\u1ed7i qu\u1ed1c gia c\u00f3 ki\u1ec3u ch\u1eef kh\u00e1c nhau s\u1ebd c\u00f3 ph\u01b0\u01a1ng ph\u00e1p s\u1eafp x\u1ebfp ki\u1ec3u t\u00ean ng\u01b0\u1eddi kh\u00e1c nhau. Kh\u00e1c v\u1edbi c\u00e1c n\u01b0\u1edbc kh\u00e1c, t\u00ean ng\u01b0\u1eddi Vi\u1ec7t Nam th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp: vi\u1ebft h\u1ecd tr\u01b0\u1edbc, vi\u1ebft t\u00ean sau. Do \u0111\u00f3, khi s\u1eed d\u1ee5ng Sort A to Z hay Sort Z to A th\u00ec danh s\u00e1ch s\u1ebd s\u1eafp x\u1ebfp theo h\u1ecd ch\u1ee9 kh\u00f4ng ph\u1ea3i theo t\u00ean.<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong Excel - Excel c\u01a1 b\u1ea3n\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/ziMU3qk6LZs?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 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Sap_xep_theo_kieu_tach_ho_ten_thanh_hai_cot_khac_nhau\"><\/span><b>S\u1eafp x\u1ebfp theo ki\u1ec3u t\u00e1ch h\u1ecd t\u00ean th\u00e0nh hai c\u1ed9t kh\u00e1c nhau<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">D\u1ef1a v\u00e0o b\u1ea3n ch\u1ea5t c\u1ee7a c\u00e1ch s\u1eafp x\u1ebfp trong excel ta c\u00f3 th\u1ec3 chia ch\u00fang l\u00e0m 2 ki\u1ec3u s\u1eafp x\u1ebfp. Ki\u1ec3u \u0111\u1ea7u ti\u00ean \u0111\u00f3 l\u00e0 s\u1eafp x\u1ebfp danh s\u00e1ch theo th\u1ee9 t\u1ef1 t\u00ean t\u00e1ch h\u1ecd v\u00e0 t\u00ean ra l\u00e0m hai c\u1ed9t kh\u00e1c nhau. Khi \u0111\u00f3 ta s\u1ebd th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c \u1edf c\u1ed9t t\u00ean \u0111\u1ec3 s\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 cho danh s\u00e1ch theo b\u1ea3ng ch\u1eef c\u00e1i qu\u1ed1c t\u1ebf ABC.<\/span><\/p>\n<figure id=\"attachment_11641\" aria-describedby=\"caption-attachment-11641\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11641 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-1-1.jpg\" alt=\"S\u1eafp x\u1ebfp theo ki\u1ec3u t\u00e1ch h\u1ecd t\u00ean th\u00e0nh hai c\u1ed9t kh\u00e1c nhau\" width=\"600\" height=\"406\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-1-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-1-1-400x271.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11641\" class=\"wp-caption-text\">S\u1eafp x\u1ebfp theo ki\u1ec3u t\u00e1ch h\u1ecd t\u00ean th\u00e0nh hai c\u1ed9t kh\u00e1c nhau<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Sap_xep_ten_theo_kieu_tach_ho_va_ten_bang_Replace\"><\/span><b>S\u1eafp x\u1ebfp t\u00ean theo ki\u1ec3u t\u00e1ch h\u1ecd v\u00e0 t\u00ean b\u1eb1ng Replace<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ngo\u00e0i ki\u1ec3u t\u00e1ch c\u1ed9t ta c\u00f2n c\u00f3 ki\u1ec3u t\u00e1ch b\u1eb1ng Replace. V\u1edbi ph\u01b0\u01a1ng ph\u00e1p n\u00e0y, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo c\u00e1c thao t\u00e1c d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u0110\u1ea7u ti\u00ean, b\u1ea1n s\u1ebd b\u00f4i \u0111en c\u1ed9t h\u1ecd t\u00ean sau \u0111\u00f3 d\u00f9ng n\u00fat l\u1ec7nh Copy\/Paste n\u00f3 s\u1ebd hi\u1ec7n ra m\u1ed9t c\u1ed9t b\u00ean c\u1ea1nh. C\u00e1c d\u00f2ng v\u00e0 c\u1ed9t n\u00e0y b\u1ea1n c\u1ea7n ph\u1ea3i \u0111\u1eb7t t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u1ed9t h\u1ecd v\u00e0 t\u00ean. Ngo\u00e0i ra, c\u00e1c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 Copy\/Paste b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl C v\u00e0 Ctrl Vl hay k\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o ch\u1ed7 b\u00f4i \u0111en r\u1ed3i nh\u1ea5n l\u1ec7nh copy\/paste.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u00f4i \u0111en c\u1ed9t h\u1ecd t\u00ean v\u1eeba copy \u0111\u01b0\u1ee3c v\u00e0 m\u1ee5c \u1edf thanh c\u00f4ng c\u1ee5 c\u00f3 t\u00ean ribbon Home t\u00ecm m\u1ee5c Editing, m\u1edf t\u00f9y ch\u1ecdn Find &amp; Select v\u00e0 ch\u1ecdn Replace. N\u1ebfu b\u1ea1n mu\u1ed1n l\u00e0m nhanh g\u1ecdn h\u01a1n th\u00ec h\u00e3y s\u1eed d\u1ee5ng ph\u00edm Ctrl H.<\/span><\/p>\n<figure id=\"attachment_11644\" aria-describedby=\"caption-attachment-11644\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11644 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-4.jpg\" alt=\"S\u1eafp x\u1ebfp t\u00ean theo ki\u1ec3u t\u00e1ch h\u1ecd v\u00e0 t\u00ean b\u1eb1ng Replace\" width=\"600\" height=\"336\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-4-400x224.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11644\" class=\"wp-caption-text\">S\u1eafp x\u1ebfp t\u00ean theo ki\u1ec3u t\u00e1ch h\u1ecd v\u00e0 t\u00ean b\u1eb1ng Replace<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Click th\u1eb3ng v\u00e0o Replace All \u0111\u1ec3 t\u00e1ch t\u1ea5t c\u1ea3 c\u00e1c t\u00ean b\u1ea1n \u0111\u00e3 l\u1ef1a ch\u1ecdn. Khi xu\u1ea5t hi\u1ec7n m\u1ed9t h\u1ed9p tho\u1ea1i nh\u1ecf th\u00f4ng b\u00e1o cho b\u1ea1n l\u00e0 Excel \u0111\u00e3 t\u00e1ch t\u00ean v\u00e0 x\u00f3a ph\u1ea7n \u0111\u1ec7m.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Ti\u1ebfp t\u1ee5c nh\u1ea5n tab Data ch\u1ecdn Sort AZ \u0111\u1ec3 s\u1eafp x\u1ebfp t\u00ean. R\u1ed3i Click v\u00e0o d\u1ea5u c\u1ed9ng b\u00ean d\u01b0\u1edbi trang r\u1ed3i ch\u1ecdn Fill Series. Khi \u0111\u00f3 c\u1ed9t STT s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp \u0111\u00fang.<\/span><\/p>\n<p style=\"text-align: justify;\">Xem th\u00eam b\u00e0i vi\u1ebft:<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/tinh-diem-trung-binh-trong-excel\/\">T\u00ednh \u0111i\u1ec3m trung b\u00ecnh trong Excel b\u1eb1ng c\u00e1c c\u00f4ng th\u1ee9c n\u00e0o?<\/a><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/bang-cham-cong-excel\/\">B\u1ea3ng ch\u1ea5m c\u00f4ng Excel \u0111\u1eb9p m\u1eaft v\u00e0 d\u1ec5 l\u00e0m nh\u1ea5t<\/a><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_sap_xep_thu_tu_A_B_C_trong_Excel\"><\/span><b>C\u00e1ch s\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 A B C trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n g\u1eb7p ph\u1ea3i nh\u1eefng b\u1ea3ng bi\u1ec3u th\u00ec n\u00ean s\u1eafp x\u1ebfp ch\u00fang theo ki\u1ec3u t\u0103ng gi\u1ea3m c\u01a1 b\u1ea3n \u0111\u1ec3 d\u1ec5 t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u khi c\u1ea7n thi\u1ebft v\u00e0 kh\u00f4ng \u0111\u1ec3 b\u1ecb s\u00f3t <a href=\"https:\/\/vi.wikipedia.org\/wiki\/D%E1%BB%AF_li%E1%BB%87u_(m%C3%A1y_t%C3%ADnh)\">d\u1eef li\u1ec7u<\/a>. B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc nh\u01b0 b\u00ean tr\u00ean. Tuy nhi\u00ean, n\u1ebfu nh\u1eefng \u0111i\u1ec1u ki\u1ec7n ch\u00fang ta c\u1ea7n l\u1ecdc c\u00f3 nhi\u1ec1u th\u00ec ta n\u00ean s\u1eed d\u1ee5ng c\u00e1ch kh\u00e1c. C\u00f9ng xem c\u00e1c b\u01b0\u1edbc trong c\u00e1ch s\u1eafp x\u1ebfp excel nh\u00e9.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: M\u1edf Tab Data, ch\u1ecdn \u1ee9ng d\u1ee5ng Sort \u0111\u1ec3 b\u1eaft \u0111\u1ea7u s\u1eafp x\u1ebfp.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: C\u00e1c b\u1ea1n n\u00ean \u0111\u1ecdc k\u1ef9 v\u00e0 t\u00ecm hi\u1ec3u chi ti\u1ebft \u0111i\u1ec1u ki\u1ec7n d\u1eef li\u1ec7u c\u0169ng nh\u01b0 t\u00ednh n\u0103ng \u1edf b\u1ea3ng c\u1ee7a Sort.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Nh\u1eefng ch\u1ee9c n\u0103ng ch\u00ednh m\u00e0 sort mang l\u1ea1i:<\/span><\/p>\n<figure id=\"attachment_11645\" aria-describedby=\"caption-attachment-11645\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11645 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-5-1.jpg\" alt=\"C\u00e1ch s\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 A B C trong Excel\" width=\"600\" height=\"447\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-5-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-5-1-400x298.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11645\" class=\"wp-caption-text\">C\u00e1ch s\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 A B C trong Excel<\/figcaption><\/figure>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Add Level: trong m\u1ee5c n\u00e0y b\u1ea1n c\u1ea7n t\u1ea1o th\u00eam nh\u1eefng t\u1ea7ng l\u1edbpl b\u1eadc thang s\u1eafp x\u1ebfp kh\u00e1c nhau. C\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng c\u00f3 th\u1ec3 chia ra l\u00e0m nhi\u1ec1u c\u1ea5p \u0111\u1ed9 kh\u00e1c nhau.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Delete Level: d\u00f9ng \u0111\u1ec3 x\u00f3a c\u1ea5p \u0111\u1ed9 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sort by: S\u1eafp x\u1ebfp c\u00e1c c\u1ed9t theo y\u00eau c\u1ea7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sort On: C\u00e1c danh m\u1ee5c c\u1ea7n \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp nh\u01b0 m\u00e0u s\u1eafc, con s\u1ed1, ghi ch\u00fa, ph\u00f4ng ch\u1eef, gi\u00e1 tr\u1ecb\u2026<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Order: s\u1eafp x\u1ebfp theo ki\u1ec3u t\u0103ng d\u1ea7n ho\u1eb7c d\u1ea7n gi\u1ea3m d\u1ea7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">My data has headers: N\u1ebfu r\u01a1i v\u00e0o b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u01b0\u1ee3c l\u1ecdc \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb th\u00ec c\u00e1c b\u1ea1n l\u00ean nh\u1ea5n chu\u1ed9t v\u00e0o \u00f4 n\u00e0y.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: truy c\u1eadp \u1ee9ng d\u1ee5ng v\u00e0o b\u1ea3ng Excel.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_sap_xep_tang_dan_trong_excel\"><\/span><b>C\u00e1ch s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n trong excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi c\u00e1c b\u1ea1n \u0111ang c\u00f3 m\u1ed9t b\u1ea3ng excel g\u1ed3m nhi\u1ec1u s\u1ed1 li\u1ec7u kh\u00e1c nhau; c\u00e1c b\u1ea1n c\u1ea7n l\u00e0m sao \u0111\u1ec3 c\u00e1ch s\u1eafp x\u1ebfp trong Excel c\u00e1c d\u1eef li\u1ec7u c\u1ee7a ch\u00fang t\u0103ng d\u1ea7n. M\u00e0 kh\u00f4ng ph\u1ea3i ng\u1ed3i t\u00ecm t\u1eebng ch\u00fat m\u1ed9t, so s\u00e1nh \u0111\u1ed1i chi\u1ebfu t\u1eebng s\u1ed1 l\u00e0m m\u1ea5t th\u1eddi gian.Th\u00ec h\u00e3y xem ph\u1ea7n h\u01b0\u1edbng d\u1eabn s\u1eafp x\u1ebfp si\u00eau \u0111\u01a1n gi\u1ea3n d\u01b0\u1edbi \u0111\u00e2y nh\u00e9. C\u00e1c thao t\u00e1c \u0111\u1ec3 th\u1ef1c hi\u1ec7n ch\u01b0a \u0111\u1ea7u 40s cho c\u00e1c b\u1ea1n.<\/span><\/p>\n<figure id=\"attachment_11642\" aria-describedby=\"caption-attachment-11642\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11642 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-2-1-e1647318750714.jpg\" alt=\"C\u00e1ch s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n trong excel\" width=\"600\" height=\"331\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-2-1-e1647318750714.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-2-1-e1647318750714-400x221.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11642\" class=\"wp-caption-text\">C\u00e1ch s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: B\u00f4i \u0111en c\u00e1c d\u1eef li\u1ec7u c\u1ea7n d\u00f9ng l\u1ecdc \u0111\u1ec3 b\u1eaft \u0111\u1ea7u ti\u1ebfn h\u00e0nh. Trong m\u1ed9t b\u1ea3ng s\u1ed1 li\u1ec7u c\u00e1c th\u00f4ng s\u1ed1 c\u1ee7a ch\u00fang s\u1ebd li\u00ean quan \u0111\u1ebfn nhau.\u00a0 N\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t c\u1ea7u l\u1ecdc m\u00e0 b\u1ea1n ch\u1ec9 d\u00f9ng m\u1ed9t c\u1ed9t \u0111\u1ec3 l\u1ecdc s\u1ebd x\u1ea3y ra c\u00e1c v\u1ea5n \u0111\u1ec1 sai s\u00f3t; ch\u00ednh v\u00ec v\u1eady m\u00e0 c\u00e1c b\u1ea1n n\u00ean b\u00f4i \u0111en ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t c\u1ea7n l\u1ecdc.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2:\u00a0 S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng c\u1ee7a Tab Data tr\u00ean thanh c\u00f4ng c\u1ee5; r\u1ed3i nh\u00e1y chu\u1ed9t ch\u1ecdn Sort \u0111\u1ec3 h\u1ed9p\u00a0 h\u1ed9p tho\u1ea1i hi\u1ec3n th\u1ecb.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Trong c\u00e1c danh m\u1ee5c c\u00f3 d\u1ea1ng m\u1ee5c mang t\u00ean Sort by. H\u00e3y ch\u1ecdn danh \u0111\u00f3 v\u00e0 c\u00e1c c\u1ed9t c\u1ea7n s\u1eafp x\u1ebfp c\u00e1c gi\u00e1 tr\u1ecb t\u0103ng d\u1ea7n. R\u1ed3i m\u1edf\u00a0 Sort On ch\u1ecdn Cell Vallues.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: T\u1ea1i v\u1ecb tr\u00ed m\u1ee5c Order nh\u1ea5n ch\u1ecdn Smallest to Largest \u0111\u1ec3 s\u1eafp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: Cu\u1ed1i c\u00f9ng ch\u1ecdn Ok \u0111\u1ec3 ho\u00e0n th\u00e0nh.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 b\u00e0i \u0111\u00e1nh gi\u00e1 chi ti\u1ebft v\u1ec1 c\u00e1c c\u00e1ch s\u1eafp x\u1ebfp trong excel v\u1edbi mong mu\u1ed1n \u0111em l\u1ea1i nhi\u1ec1u ki\u1ebfn th\u1ee9c b\u1ed5 \u00edch cho c\u00e1c b\u1ea1n. M\u1ed9t ph\u1ea7n t\u00e0i li\u1ec7u nh\u1ecf cho c\u00e1c b\u1ea1n tham kh\u1ea3o, hy v\u1ecdng nh\u1eadn \u0111\u01b0\u1ee3c s\u1ef1 \u1ee7ng h\u1ed9 v\u00e0 y\u00eau th\u00edch c\u1ee7a m\u1ecdi ng\u01b0\u1eddi.<\/span><\/p>\n<p><strong>Xem th\u00eam:<\/strong><\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-xep-loai-trong-excel\/\" target=\"_blank\" rel=\"noopener\">Nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1ch x\u1ebfp lo\u1ea1i trong excel<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>S\u1eed d\u1ee5ng b\u1ea3ng excel ng\u00e0y c\u00e0ng ph\u1ed5 bi\u1ebfn, r\u1ed9ng r\u00e3i b\u1edfi ch\u00fang thu\u1eadn ti\u1ec7n cho vi\u1ec7c theo d\u00f5i v\u00e0 tra c\u1ee9u c\u00e1c b\u1ea3ng danh s\u00e1ch. Tuy nhi\u00ean trong Excel kh\u00f4ng c\u00f3 t\u00ednh n\u0103ng t\u1ef1 \u0111\u1ed9ng s\u1eafp x\u1ebfp danh s\u00e1ch theo th\u1ee9 t\u1ef1 nh\u1ea5t \u0111\u1ecbnh. V\u00ec v\u1eady m\u00e0 sau \u0111\u00e2y l\u00e0 3 c\u00e1ch s\u1eafp x\u1ebfp trong &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11643,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"show_on_app":false,"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11565","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"acf":{"show_on_app":false},"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>C\u00e1ch s\u1eafp x\u1ebfp trong excel c\u00f3 kh\u00f3 nh\u01b0 l\u1eddi \u0111\u1ed3n kh\u00f4ng?<\/title>\n<meta name=\"description\" content=\"Khi b\u1ea1n \u0111ang c\u00f3 m\u1ed9t b\u1ea3ng excel g\u1ed3m nhi\u1ec1u s\u1ed1 li\u1ec7u kh\u00e1c nhau; c\u00e1c b\u1ea1n c\u1ea7n l\u00e0m sao \u0111\u1ec3 c\u00e1ch s\u1eafp x\u1ebfp trong Excel c\u00e1c d\u1eef li\u1ec7u c\u1ee7a ch\u00fang t\u0103ng d\u1ea7n.\" \/>\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-sap-xep-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch s\u1eafp x\u1ebfp trong excel c\u00f3 kh\u00f3 nh\u01b0 l\u1eddi \u0111\u1ed3n kh\u00f4ng?\" \/>\n<meta property=\"og:description\" content=\"Khi b\u1ea1n \u0111ang c\u00f3 m\u1ed9t b\u1ea3ng excel g\u1ed3m nhi\u1ec1u s\u1ed1 li\u1ec7u kh\u00e1c nhau; c\u00e1c b\u1ea1n c\u1ea7n l\u00e0m sao \u0111\u1ec3 c\u00e1ch s\u1eafp x\u1ebfp trong Excel c\u00e1c d\u1eef li\u1ec7u c\u1ee7a ch\u00fang t\u0103ng d\u1ea7n.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-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-15T04:35:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-08T09:25:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-3-1.jpg\" \/>\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\/jpeg\" \/>\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=\"7 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-sap-xep-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"C\u00e1ch s\u1eafp x\u1ebfp trong excel c\u00f3 kh\u00f3 nh\u01b0 l\u1eddi \u0111\u1ed3n kh\u00f4ng\",\"datePublished\":\"2022-11-15T04:35:03+00:00\",\"dateModified\":\"2022-12-08T09:25:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/\"},\"wordCount\":1860,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-3-1.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/\",\"name\":\"C\u00e1ch s\u1eafp x\u1ebfp trong excel c\u00f3 kh\u00f3 nh\u01b0 l\u1eddi \u0111\u1ed3n kh\u00f4ng?\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-3-1.jpg\",\"datePublished\":\"2022-11-15T04:35:03+00:00\",\"dateModified\":\"2022-12-08T09:25:38+00:00\",\"description\":\"Khi b\u1ea1n \u0111ang c\u00f3 m\u1ed9t b\u1ea3ng excel g\u1ed3m nhi\u1ec1u s\u1ed1 li\u1ec7u kh\u00e1c nhau; c\u00e1c b\u1ea1n c\u1ea7n l\u00e0m sao \u0111\u1ec3 c\u00e1ch s\u1eafp x\u1ebfp trong Excel c\u00e1c d\u1eef li\u1ec7u c\u1ee7a ch\u00fang t\u0103ng d\u1ea7n.\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-3-1.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-3-1.jpg\",\"width\":600,\"height\":337,\"caption\":\"C\u00e1ch s\u1eafp x\u1ebfp trong excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-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 s\u1eafp x\u1ebfp trong excel c\u00f3 kh\u00f3 nh\u01b0 l\u1eddi \u0111\u1ed3n kh\u00f4ng\"}]},{\"@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":"C\u00e1ch s\u1eafp x\u1ebfp trong excel c\u00f3 kh\u00f3 nh\u01b0 l\u1eddi \u0111\u1ed3n kh\u00f4ng?","description":"Khi b\u1ea1n \u0111ang c\u00f3 m\u1ed9t b\u1ea3ng excel g\u1ed3m nhi\u1ec1u s\u1ed1 li\u1ec7u kh\u00e1c nhau; c\u00e1c b\u1ea1n c\u1ea7n l\u00e0m sao \u0111\u1ec3 c\u00e1ch s\u1eafp x\u1ebfp trong Excel c\u00e1c d\u1eef li\u1ec7u c\u1ee7a ch\u00fang t\u0103ng d\u1ea7n.","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-sap-xep-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eafp x\u1ebfp trong excel c\u00f3 kh\u00f3 nh\u01b0 l\u1eddi \u0111\u1ed3n kh\u00f4ng?","og_description":"Khi b\u1ea1n \u0111ang c\u00f3 m\u1ed9t b\u1ea3ng excel g\u1ed3m nhi\u1ec1u s\u1ed1 li\u1ec7u kh\u00e1c nhau; c\u00e1c b\u1ea1n c\u1ea7n l\u00e0m sao \u0111\u1ec3 c\u00e1ch s\u1eafp x\u1ebfp trong Excel c\u00e1c d\u1eef li\u1ec7u c\u1ee7a ch\u00fang t\u0103ng d\u1ea7n.","og_url":"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-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-15T04:35:03+00:00","article_modified_time":"2022-12-08T09:25:38+00:00","og_image":[{"width":600,"height":337,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-3-1.jpg","type":"image\/jpeg"}],"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":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"C\u00e1ch s\u1eafp x\u1ebfp trong excel c\u00f3 kh\u00f3 nh\u01b0 l\u1eddi \u0111\u1ed3n kh\u00f4ng","datePublished":"2022-11-15T04:35:03+00:00","dateModified":"2022-12-08T09:25:38+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/"},"wordCount":1860,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-3-1.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/","name":"C\u00e1ch s\u1eafp x\u1ebfp trong excel c\u00f3 kh\u00f3 nh\u01b0 l\u1eddi \u0111\u1ed3n kh\u00f4ng?","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-3-1.jpg","datePublished":"2022-11-15T04:35:03+00:00","dateModified":"2022-12-08T09:25:38+00:00","description":"Khi b\u1ea1n \u0111ang c\u00f3 m\u1ed9t b\u1ea3ng excel g\u1ed3m nhi\u1ec1u s\u1ed1 li\u1ec7u kh\u00e1c nhau; c\u00e1c b\u1ea1n c\u1ea7n l\u00e0m sao \u0111\u1ec3 c\u00e1ch s\u1eafp x\u1ebfp trong Excel c\u00e1c d\u1eef li\u1ec7u c\u1ee7a ch\u00fang t\u0103ng d\u1ea7n.","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-3-1.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-3-1.jpg","width":600,"height":337,"caption":"C\u00e1ch s\u1eafp x\u1ebfp trong excel"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/cach-sap-xep-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 s\u1eafp x\u1ebfp trong excel c\u00f3 kh\u00f3 nh\u01b0 l\u1eddi \u0111\u1ed3n kh\u00f4ng"}]},{"@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\/"}]}},"thumbnail":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/cach-sap-xep-trong-excel-3-1-400x225.jpg","_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11565","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=11565"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11565\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11643"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}