{"id":9125,"date":"2025-01-01T18:37:16","date_gmt":"2025-01-01T18:37:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/cach-sap-xep-ten-theo-abc-trong-excel-2010-va-cac-phien-ban-khac\/"},"modified":"2025-01-01T18:37:16","modified_gmt":"2025-01-01T18:37:16","slug":"cach-sap-xep-ten-theo-abc-trong-excel-2010-va-cac-phien-ban-khac","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/cach-sap-xep-ten-theo-abc-trong-excel-2010-va-cac-phien-ban-khac\/","title":{"rendered":"C\u00e1ch s\u1eafp x\u1ebfp t\u00ean theo abc trong excel 2010 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n kh\u00e1c"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n<strong> c\u00e1ch s\u1eafp x\u1ebfp t\u00ean theo abc trong excel<\/strong> 2010 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n kh\u00e1c, t\u1eeb \u0111\u00f3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 l\u1eadp danh s\u00e1ch theo t\u00ean c\u1ee7a ng\u01b0\u1eddi s\u1eed d\u1ee5ng.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67758b5c265d1\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-sap-xep-ten-theo-abc-trong-excel-2010.html#Cach_sap_xep_ten_theo_abc_trong_excel_2010_va_cac_phien_ban_khac\" title=\"C\u00e1ch s\u1eafp x\u1ebfp t\u00ean theo abc trong excel 2010 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n kh\u00e1c\">C\u00e1ch s\u1eafp x\u1ebfp t\u00ean theo abc trong excel 2010 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n kh\u00e1c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-sap-xep-ten-theo-abc-trong-excel-2010.html#Sap_xep_ten_theo_abc_voi_Sort\" title=\"S\u1eafp x\u1ebfp t\u00ean theo abc v\u1edbi Sort\">S\u1eafp x\u1ebfp t\u00ean theo abc v\u1edbi Sort<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_sap_xep_ten_theo_abc_trong_excel_2010_va_cac_phien_ban_khac\"><\/span>C\u00e1ch s\u1eafp x\u1ebfp t\u00ean theo abc trong excel 2010 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort \u0111\u1ec3 s\u1eafp x\u1ebfp t\u00ean theo abc. Khi l\u1eadp m\u1ed9t danh s\u00e1ch (nh\u00e2n vi\u00ean, s\u1ea3n ph\u1ea9m,\u2026)\u00a0 trong Excel, \u0111\u1ec3 s\u1eafp x\u1ebfp ta s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng\u00a0<strong>Sort<\/strong>.<\/p>\n<figure id=\"attachment_25477\" aria-describedby=\"caption-attachment-25477\" style=\"width: 621px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25477 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/sap-xep-ten-theo-abc-1.png\" width=\"621\" height=\"128\" title=\"sap-xep-ten-theo-abc-1\"><figcaption id=\"caption-attachment-25477\" class=\"wp-caption-text\">Ch\u1ee9c n\u0103ng Sort n\u1eb1m t\u1ea1i th\u1ebb Data, nh\u00f3m Sort &amp; Filter<\/figcaption><\/figure>\n<p>C\u00e1c b\u01b0\u1edbc \u0111\u1ec3 s\u1eafp x\u1ebfp nh\u01b0 sau:<\/p>\n<p><strong>1:\u00a0<\/strong>Ch\u1ecdn v\u00f9ng c\u1ea7n s\u1eafp x\u1ebfp<\/p>\n<figure id=\"attachment_25481\" aria-describedby=\"caption-attachment-25481\" style=\"width: 621px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25481 size-full\" title=\"Ch\u1ecdn v\u00f9ng c\u1ea7n s\u1eafp x\u1ebfp\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/sap-xep-ten-theo-abc-2.png\" alt=\"Ch\u1ecdn v\u00f9ng c\u1ea7n s\u1eafp x\u1ebfp\" width=\"621\" height=\"456\"><figcaption id=\"caption-attachment-25481\" class=\"wp-caption-text\">Ch\u1ecdn v\u00f9ng c\u1ea7n s\u1eafp x\u1ebfp<\/figcaption><\/figure>\n<p><strong>2:\u00a0<\/strong>Ch\u1ecdn\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/chuc-nang-sort-trong-bai-thi-mos.html\">ch\u1ee9c n\u0103ng\u00a0<\/a><\/strong><strong>Sort.\u00a0<\/strong>Khi \u0111\u00f3 m\u1ed9t b\u1ea3ng ch\u1ecdn s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb:<\/p>\n<figure id=\"attachment_25482\" aria-describedby=\"caption-attachment-25482\" style=\"width: 618px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25482 size-full\" title=\"Ch\u1ecdn\u00a0ch\u1ee9c n\u0103ng\u00a0Sort\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/sap-xep-ten-theo-abc-3.png\" alt=\"Ch\u1ecdn\u00a0ch\u1ee9c n\u0103ng\u00a0Sort\" width=\"618\" height=\"530\"><figcaption id=\"caption-attachment-25482\" class=\"wp-caption-text\">Ch\u1ecdn\u00a0ch\u1ee9c n\u0103ng\u00a0Sort<\/figcaption><\/figure>\n<p><em>N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111\u00e3 bao g\u1ed3m ti\u00eau \u0111\u1ec1 h\u00e0ng\/c\u1ed9t, h\u00e3y \u0111\u00e1nh d\u1ea5u v\u00e0o \u201c<strong>My data has headers<\/strong>\u201c.<\/em><\/p>\n<p><strong>3:\u00a0<\/strong>Ch\u1ecdn c\u1ed9t s\u1eafp x\u1ebfp, ch\u1ecdn lo\u1ea1i s\u1eafp x\u1ebfp v\u00e0 ch\u1ecdn ki\u1ec3u s\u1eafp x\u1ebfp<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-11.gif\" title=\"ex101_92019-nho-11\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 s\u1eafp x\u1ebfp t\u00ean theo abc, ta ch\u1ecdn\u00a0<strong>Cell Values<\/strong> v\u00e0\u00a0<strong>A to Z<\/strong>. Sau \u0111\u00f3 \u1ea5n\u00a0<strong>OK.<\/strong><\/p>\n<figure id=\"attachment_25485\" aria-describedby=\"caption-attachment-25485\" style=\"width: 593px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25485 size-full\" title=\"Ch\u1ecdn c\u1ed9t s\u1eafp x\u1ebfp, ch\u1ecdn lo\u1ea1i s\u1eafp x\u1ebfp\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/sap-xep-ten-theo-abc-4.png\" alt=\"Ch\u1ecdn c\u1ed9t s\u1eafp x\u1ebfp, ch\u1ecdn lo\u1ea1i s\u1eafp x\u1ebfp\" width=\"593\" height=\"272\"><figcaption id=\"caption-attachment-25485\" class=\"wp-caption-text\">Ch\u1ecdn c\u1ed9t s\u1eafp x\u1ebfp, ch\u1ecdn lo\u1ea1i s\u1eafp x\u1ebfp<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<figure id=\"attachment_25486\" aria-describedby=\"caption-attachment-25486\" style=\"width: 537px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25486 size-full\" title=\"K\u1ebft qu\u1ea3 s\u1eafp x\u1ebfp, ch\u1ecdn lo\u1ea1i s\u1eafp x\u1ebfp\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/sap-xep-ten-theo-abc-5.png\" alt=\"K\u1ebft qu\u1ea3 s\u1eafp x\u1ebfp, ch\u1ecdn lo\u1ea1i s\u1eafp x\u1ebfp\" width=\"537\" height=\"401\"><figcaption id=\"caption-attachment-25486\" class=\"wp-caption-text\">K\u1ebft qu\u1ea3 s\u1eafp x\u1ebfp, ch\u1ecdn lo\u1ea1i s\u1eafp x\u1ebfp<\/figcaption><\/figure>\n<p><strong>\u0110\u1ecdc th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/chuc-nang-sort-trong-bai-thi-mos.html\">https:\/\/blog.hocexcel.online\/chuc-nang-sort-trong-bai-thi-mos.html<\/a><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Sap_xep_ten_theo_abc_voi_Sort\"><\/span>S\u1eafp x\u1ebfp t\u00ean theo abc v\u1edbi Sort<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 \u0111\u00e3 th\u1ea5y \u1edf tr\u00ean, ta \u0111\u00e3 s\u1eafp x\u1ebfp h\u1ecd v\u00e0 t\u00ean theo danh s\u00e1ch abc. V\u1eady n\u1ebfu ta ch\u1ec9 mu\u1ed1n s\u1eafp x\u1ebfp t\u00ean th\u00f4i th\u00ec sao?<\/p>\n<p>Ta ti\u1ebfn h\u00e0nh l\u00e0m th\u00eam m\u1ed9t b\u01b0\u1edbc n\u1eefa:<a href=\"http:\/\/blog.ezworkapp.com\/69-%E2%97%8F-tach-ten-ho-va-ten-dem-trong-excel-khong-dung-cong-thuc.html\">\u00a0<strong>T\u00e1ch t\u00ean, h\u1ecd, t\u00ean \u0111\u1ec7m trong Excel<\/strong><\/a><\/p>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c sau b\u01b0\u1edbc t\u00e1ch t\u00ean nh\u01b0 sau:<\/p>\n<figure id=\"attachment_25487\" aria-describedby=\"caption-attachment-25487\" style=\"width: 922px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25487 size-full\" title=\"S\u1eafp x\u1ebfp t\u00ean theo abc v\u1edbi Sort\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/sap-xep-ten-theo-abc-6.png\" alt=\"S\u1eafp x\u1ebfp t\u00ean theo abc v\u1edbi Sort\" width=\"922\" height=\"373\"><figcaption id=\"caption-attachment-25487\" class=\"wp-caption-text\">S\u1eafp x\u1ebfp t\u00ean theo abc v\u1edbi Sort<\/figcaption><\/figure>\n<p>Sau \u0111\u00f3 ta ti\u1ebfn h\u00e0nh t\u00e1ch t\u00ean b\u1eb1ng Sort. Thay v\u00ec s\u1eed d\u1ee5ng v\u1edbi c\u1ed9t\u00a0<strong>H\u1ecd v\u00e0 t\u00ean<\/strong>, ta s\u1eed d\u1ee5ng cho c\u1ed9t\u00a0<strong>T\u00ean.<\/strong><\/p>\n<figure id=\"attachment_25488\" aria-describedby=\"caption-attachment-25488\" style=\"width: 589px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25488 size-full\" title=\"S\u1eed d\u1ee5ng v\u1edbi c\u1ed9t\u00a0H\u1ecd v\u00e0 t\u00ean, ta s\u1eed d\u1ee5ng cho c\u1ed9t\u00a0T\u00ean\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/sap-xep-ten-theo-abc-7.png\" alt=\"S\u1eed d\u1ee5ng v\u1edbi c\u1ed9t\u00a0H\u1ecd v\u00e0 t\u00ean, ta s\u1eed d\u1ee5ng cho c\u1ed9t\u00a0T\u00ean\" width=\"589\" height=\"265\"><figcaption id=\"caption-attachment-25488\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng v\u1edbi c\u1ed9t\u00a0H\u1ecd v\u00e0 t\u00ean, ta s\u1eed d\u1ee5ng cho c\u1ed9t\u00a0T\u00ean<\/figcaption><\/figure>\n<p>K\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng ta thu \u0111\u01b0\u1ee3c:<\/p>\n<figure id=\"attachment_25489\" aria-describedby=\"caption-attachment-25489\" style=\"width: 872px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-25489 size-full\" title=\"Danh s\u00e1ch sau khi s\u1eafp x\u1ebfp\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/sap-xep-ten-theo-abc-8.png\" alt=\"Danh s\u00e1ch sau khi s\u1eafp x\u1ebfp\" width=\"872\" height=\"341\"><figcaption id=\"caption-attachment-25489\" class=\"wp-caption-text\">Danh s\u00e1ch sau khi s\u1eafp x\u1ebfp<\/figcaption><\/figure>\n<p>Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o? Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t.<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-11.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9126,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9125","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=9125"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9125\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9126"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}