{"id":5966,"date":"2024-12-21T11:26:17","date_gmt":"2024-12-21T11:26:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-tra-ve-thu-tu-ban-dau-truoc-khi-sap-xep-bang-sort-trong-excel\/"},"modified":"2024-12-21T11:26:17","modified_gmt":"2024-12-21T11:26:17","slug":"huong-dan-cach-tra-ve-thu-tu-ban-dau-truoc-khi-sap-xep-bang-sort-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-cach-tra-ve-thu-tu-ban-dau-truoc-khi-sap-xep-bang-sort-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch tr\u1ea3 v\u1ec1 th\u1ee9 t\u1ef1 ban \u0111\u1ea7u tr\u01b0\u1edbc khi s\u1eafp x\u1ebfp b\u1eb1ng sort trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Th\u00f4ng th\u01b0\u1eddng khi t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u trong\u00a0Excel, ch\u00fang ta hay s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng s\u1eafp x\u1ebfp (Data \u2013 Sort). Vi\u1ec7c s\u1eafp x\u1ebfp gi\u00fap d\u1eef li\u1ec7u c\u00f3 t\u00ednh th\u1ed1ng nh\u1ea5t v\u00e0 tr\u1eadt t\u1ef1 r\u00f5 r\u00e0ng. Tuy nhi\u00ean khi mu\u1ed1n ho\u00e0n t\u00e1c (Undo) l\u1ea1i danh s\u00e1ch ban \u0111\u1ea7u th\u00ec c\u00f3 th\u1ec3 g\u1eb7p kh\u00f3 kh\u0103n \u2013 khi ch\u00fang ta ph\u1ee5 thu\u1ed9c\u00a0v\u00e0o t\u00ednh n\u0103ng Undo c\u1ee7a Excel, m\u00e0 ch\u1ee9c n\u0103ng n\u00e0y l\u1ea1i d\u1ec5 b\u1ecb sai s\u00f3t do n\u00f3 lu\u00f4n thay \u0111\u1ed5i theo c\u00e1c thao t\u00e1c m\u1edbi. V\u00e0\u00a0ch\u00fang ta c\u1ea7n\u00a0c\u00f3 1 gi\u1ea3i ph\u00e1p gi\u00fap l\u1ea5y l\u1ea1i th\u1ee9 t\u1ef1 d\u1eef li\u1ec7u ban\u00a0\u0111\u1ea7u tr\u01b0\u1edbc khi s\u1eafp x\u1ebfp b\u1ea5t k\u1ef3 l\u00fac n\u00e0o m\u00ecnh mu\u1ed1n. H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u gi\u1ea3i ph\u00e1p n\u00e0y nh\u00e9.<\/p>\n<p>\u0110\u1eb7c\u00a0\u0111i\u1ec3m c\u1ee7a d\u1eef li\u1ec7u sau khi s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng s\u1eafp x\u1ebfp l\u00e0\u00a0ch\u00fang ta ch\u1ec9 nh\u00ecn th\u1ea5y k\u1ebft qu\u1ea3 c\u1ee7a vi\u1ec7c s\u1eafp x\u1ebfp, c\u00f2n c\u00e1c n\u1ed9i dung\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c x\u00e1o tr\u1ed9n th\u1ebf n\u00e0o, thay\u00a0\u0111\u1ed5i tr\u1eadt t\u1ef1 ra sao ch\u00fang ta kh\u00f4ng r\u00f5. V\u00ed d\u1ee5 trong b\u1ea3ng d\u1eef li\u1ec7u d\u01b0\u1edbi\u00a0\u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22966\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data_sort_ban-dau-chua-sort.png\" width=\"401\" height=\"449\" title=\"data_sort_ban-dau-chua-sort\"><\/p>\n<p>\u00a0<\/p>\n<p>Trong b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean\u00a0ch\u01b0a\u00a0\u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo tr\u1eadt t\u1ef1 n\u00e0o. Khi ch\u00fang ta th\u1eed s\u1eafp x\u1ebfp theo M\u00e3:<\/p>\n<ul>\n<li>Ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u<\/li>\n<li>Ch\u1ecdn th\u1ebb <strong>Data<\/strong> -&gt; ch\u1ecdn <strong>Sort<\/strong><\/li>\n<li>Trong c\u1eeda s\u1ed5 Sort, ch\u1ecdn <strong>Sort by<\/strong> theo <strong>M\u00e3<\/strong>, th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp\u00a0<strong>Order A to Z<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22967\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data_sort_thao-tac-sap-xep-theo-ma.png\" width=\"1145\" height=\"653\" title=\"data_sort_thao-tac-sap-xep-theo-ma\"><\/p>\n<p>K\u1ebft qu\u1ea3 sau khi s\u1eafp x\u1ebfp:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22965\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data_sort_theo_ma.png\" width=\"399\" height=\"449\" title=\"data_sort_theo_ma\"><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-534.gif\" title=\"ex101_92019-nho-534\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>So v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u ban\u00a0\u0111\u1ea7u,\u00a0\u0111i\u1ec1u kh\u00e1c bi\u1ec7t duy nh\u1ea5t ch\u1ec9 l\u00e0 th\u1ee9 t\u1ef1\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c x\u00e1o tr\u1ed9n.<\/p>\n<p>V\u1eady l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 tr\u1ea3 v\u1ec1\u00a0th\u1ee9 t\u1ef1 ban \u0111\u1ea7u tr\u01b0\u1edbc khi s\u1eafp x\u1ebfp b\u1eb1ng sort?<\/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-6766a5d8ba8c5\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tra-ve-thu-tu-ban-dau-truoc-khi-sap-xep-bang-sort-trong-excel.html#Cach_thu_1_Su_dung_chuc_nang_Undo_phim_tat_Ctrl_Z\" title=\"C\u00e1ch th\u1ee9 1: S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Undo (ph\u00edm t\u1eaft Ctrl + Z)\">C\u00e1ch th\u1ee9 1: S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Undo (ph\u00edm t\u1eaft Ctrl + Z)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tra-ve-thu-tu-ban-dau-truoc-khi-sap-xep-bang-sort-trong-excel.html#Cach_thu_2_Su_dung_cot_phu\" title=\"C\u00e1ch th\u1ee9 2: S\u1eed d\u1ee5ng c\u1ed9t ph\u1ee5\">C\u00e1ch th\u1ee9 2: S\u1eed d\u1ee5ng c\u1ed9t ph\u1ee5<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thu_1_Su_dung_chuc_nang_Undo_phim_tat_Ctrl_Z\"><\/span>C\u00e1ch th\u1ee9 1: S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Undo (ph\u00edm t\u1eaft Ctrl + Z)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00e2y l\u00e0 ch\u1ee9c n\u0103ng gi\u00fap tr\u1ea3 v\u1ec1 tr\u1ea1ng th\u00e1i tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n 1 thao t\u00e1c n\u00e0o\u00a0\u0111\u00f3 trong\u00a0Excel. Hay c\u00f2n\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0\u00a0Excel nh\u1edb l\u1ea1i nh\u1eefng g\u00ec ch\u00fang ta\u00a0\u0111\u00e3 th\u1ef1c hi\u1ec7n, v\u00e0 tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n 1 h\u00e0nh\u00a0\u0111\u1ed9ng n\u00e0o\u00a0\u0111\u00f3.<\/p>\n<p>Tuy nhi\u00ean c\u00e1ch n\u00e0y c\u00f3 h\u1ea1n ch\u1ebf:<\/p>\n<ul>\n<li>Kh\u00f4ng ph\u1ea3i thao t\u00e1c n\u00e0o c\u0169ng cho ph\u00e9p Undo<\/li>\n<li>Undo c\u00f3 th\u1ec3 b\u1ecb c\u1eaft ngang \/ x\u00f3a b\u1ecf khi ch\u1ea1y 1 macro.<\/li>\n<\/ul>\n<p>Do\u00a0\u0111\u00f3 khi ph\u1ee5 thu\u1ed9c v\u00e0o ch\u1ee9c n\u0103ng n\u00e0y th\u00ec r\u1ea5t c\u00f3 th\u1ec3 ch\u00fang ta s\u1ebd c\u00f3 l\u00fac g\u1eb7p ph\u1ea3i t\u00ecnh tr\u1ea1ng: kh\u00f4ng th\u1ec3 undo, kh\u00f4ng tr\u1edf v\u1ec1 tr\u1ea1ng th\u00e1i ban\u00a0\u0111\u1ea7u tr\u01b0\u1edbc khi s\u1eafp x\u1ebfp\u00a0\u0111\u01b0\u1ee3c n\u1eefa.<\/p>\n<p>Khi\u00a0\u0111\u00f3 ch\u00fang ta c\u1ea7n t\u1edbi c\u00e1ch l\u00e0m kh\u00e1c,\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 tr\u1edf v\u1ec1 tr\u1ea1ng th\u00e1i ban\u00a0\u0111\u1ea7u tr\u01b0\u1edbc khi s\u1eafp x\u1ebfp b\u1ea5t k\u1ef3 l\u00fac n\u00e0o.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thu_2_Su_dung_cot_phu\"><\/span>C\u00e1ch th\u1ee9 2: S\u1eed d\u1ee5ng c\u1ed9t ph\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1i c\u1ed9t A, tr\u01b0\u1edbc khi s\u1eafp x\u1ebfp d\u1eef li\u1ec7u, ch\u00fang ta s\u1ebd\u00a0\u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 cho c\u00e1c n\u1ed9i dung nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22968\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/danh-stt-cot-phu.png\" width=\"402\" height=\"449\" title=\"danh-stt-cot-phu\"><\/p>\n<p style=\"padding-left: 30px\">Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/tu-dong-danh-so-thu-tu-cot-trong-excel.html\">T\u1ef1 \u0111\u1ed9ng \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t trong Excel<\/a><\/p>\n<p>Khi s\u1eafp x\u1ebfp theo c\u1ed9t M\u00e3, ch\u00fang ta s\u1ebd th\u1ea5y th\u1ee9 t\u1ef1 c\u00e1c v\u1ecb tr\u00ed b\u1ecb x\u00e1o tr\u1ed9n nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22969\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/danh-stt-cot-phu-sau-sort.png\" width=\"404\" height=\"449\" title=\"danh-stt-cot-phu-sau-sort\"><\/p>\n<p>Nh\u01b0 v\u1eady nh\u00ecn\u00a0\u1edf c\u1ed9t ph\u1ee5, ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y c\u00e1c v\u1ecb tr\u00ed\u00a0\u0111\u00e3 thay\u00a0\u0111\u1ed5i ra sao, b\u1edfi c\u00e1c s\u1ed1\u00a0\u0111\u00e3 b\u1ecb\u00a0\u0111\u1ea3o l\u1ed9n nh\u01b0ng v\u1eabn th\u1ec3 hi\u1ec7n tr\u01b0\u1edbc\u00a0\u0111\u00f3 g\u1eafn v\u1edbi s\u1ed1 th\u1ee9 t\u1ef1 n\u00e0o.<\/p>\n<p>Khi mu\u1ed1n tr\u1edf l\u1ea1i tr\u1ea1ng th\u00e1i ban\u00a0\u0111\u1ea7u, ch\u00fang ta s\u1ebd th\u1ef1c hi\u1ec7n vi\u1ec7c s\u1eafp x\u1ebfp theo c\u1ed9t S\u1ed1 th\u1ee9 t\u1ef1 n\u00e0y nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22970\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sap-xep-cot-stt-de-tra-ve-trang-thai-ban-dau.png\" width=\"1151\" height=\"461\" title=\"sap-xep-cot-stt-de-tra-ve-trang-thai-ban-dau\"><\/p>\n<p>Nh\u01b0 v\u1eady b\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng c\u1ed9t ph\u1ee5, ch\u00fang ta\u00a0\u0111\u1ea1t\u00a0\u0111\u01b0\u1ee3c 2 m\u1ee5c\u00a0\u0111\u00edch:<\/p>\n<ul>\n<li>N\u1eafm\u00a0\u0111\u01b0\u1ee3c s\u1ef1 x\u00e1o tr\u1ed9n c\u00e1c d\u00f2ng\u00a0\u0111\u00e3 di\u1ec5n ra nh\u01b0 th\u1ebf n\u00e0o<\/li>\n<li>C\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 tr\u1ea1ng th\u00e1i ban\u00a0\u0111\u1ea7u tr\u01b0\u1edbc khi s\u1eafp x\u1ebfp b\u1eb1ng c\u00e1ch s\u1eafp x\u1ebfp l\u1ea1i c\u1ed9t ph\u1ee5.<\/li>\n<\/ul>\n<p>R\u1ea5t h\u1eefu\u00a0\u00edch ph\u1ea3i kh\u00f4ng n\u00e0o? H\u00e3y\u00a0\u00e1p d\u1ee5ng ki\u1ebfn th\u1ee9c n\u00e0y v\u00e0o c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n ngay nh\u00e9. Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n<p>M\u1eddi c\u00e1c b\u1ea1n xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c v\u1ec1 ch\u1ee7\u00a0\u0111\u1ec1 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong\u00a0Excel:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/4-cach-danh-so-thu-tu-trong-excel-2007-2010-2013-2016.html\">4 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel 2007, 2010, 2013, 2016<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/danh-thu-tu-tu-dong-trong-excel-voi-ham-subtotal.html\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong Excel v\u1edbi h\u00e0m SUBTOTAL<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/danh-thu-tu-ket-qua-loc-autofilter-voi-ham-subtotal.html\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 k\u1ebft qu\u1ea3 l\u1ecdc Autofilter v\u1edbi h\u00e0m Subtotal<\/a><\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-534.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5967,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5966","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\/5966","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=5966"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5966\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5967"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}