{"id":8645,"date":"2024-12-23T22:08:17","date_gmt":"2024-12-23T22:08:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/23\/huong-dan-sap-xep-du-lieu-theo-thu-tu-su-dung-danh-sach-tuy-chinh\/"},"modified":"2024-12-23T22:08:17","modified_gmt":"2024-12-23T22:08:17","slug":"huong-dan-sap-xep-du-lieu-theo-thu-tu-su-dung-danh-sach-tuy-chinh","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/23\/huong-dan-sap-xep-du-lieu-theo-thu-tu-su-dung-danh-sach-tuy-chinh\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo th\u1ee9 t\u1ef1 s\u1eed d\u1ee5ng danh s\u00e1ch t\u00f9y ch\u1ec9nh"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p danh s\u00e1ch c\u1ea7n s\u1eafp x\u1ebfp d\u1eef li\u1ec7u c\u1ee7a ta kh\u00f4ng ch\u1ee9a nh\u1eefng th\u1ee9 t\u1ef1 c\u1ed1 \u0111\u1ecbnh nh\u01b0 theo s\u1ed1, theo gi\u00e1 tr\u1ecb t\u1eeb nh\u1ecf t\u1edbi l\u1edbn\u2026 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng danh s\u00e1ch t\u00f9y ch\u1ec9nh nh\u01b0 m\u1ed9t c\u00e1ch kh\u00e1c thay th\u1ebf. H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a H\u1ecdc Excel Online \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch t\u1ea1o danh s\u00e1ch n\u00e0y.<\/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-6769df506b376\" 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\/sap-xep-su-dung-danh-sach-tuy-chinh.html#Danh_sach_tuy_chinh_trong_Excel\" title=\"Danh s\u00e1ch t\u00f9y ch\u1ec9nh trong Excel\">Danh s\u00e1ch t\u00f9y ch\u1ec9nh trong Excel<\/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\/sap-xep-su-dung-danh-sach-tuy-chinh.html#Sap_xep_du_lieu_su_dung_danh_sach_tuy_chinh\" title=\"S\u1eafp x\u1ebfp d\u1eef li\u1ec7u s\u1eed d\u1ee5ng danh s\u00e1ch t\u00f9y ch\u1ec9nh\">S\u1eafp x\u1ebfp d\u1eef li\u1ec7u s\u1eed d\u1ee5ng danh s\u00e1ch t\u00f9y ch\u1ec9nh<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Danh_sach_tuy_chinh_trong_Excel\"><\/span>Danh s\u00e1ch t\u00f9y ch\u1ec9nh trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta h\u00e3y \u0111\u1ebfn v\u1edbi v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27334\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sap-xep-danh-sach-tuy-chinh-1.png\" width=\"223\" height=\"324\" title=\"sap-xep-danh-sach-tuy-chinh-1\"><\/p>\n<p>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1\u00a0<strong>K\u00edch c\u1ee1 qu\u1ea7n \u00e1o<\/strong>: S \u2013 M \u2013 L \u2013 XL \u2013 XXL\u2026 t\u1ea5t nhi\u00ean l\u00e0 ta s\u1ebd kh\u00f4ng th\u1ec3 s\u1eafp x\u1ebfp theo c\u00e1ch b\u00ecnh th\u01b0\u1eddng \u0111\u01b0\u1ee3c r\u1ed3i ph\u1ea3i kh\u00f4ng?<\/p>\n<p>\u0110\u1ec3 gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c n\u00e0y, vi\u1ec7c ta c\u1ea7n l\u00e0m l\u00e0 t\u1ea1o ra m\u1ed9t danh s\u00e1ch t\u00f9y ch\u1ec9nh \u2013 m\u1ed9t \u201cth\u01b0 vi\u1ec7n\u201d c\u00e1 nh\u00e2n \u0111\u1ec3 s\u1eed d\u1ee5ng.<\/p>\n<p>V\u1edbi danh s\u00e1ch t\u00f9y ch\u1ec9nh t\u00edch h\u1ee3p s\u1eb5n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo ng\u00e0y trong tu\u1ea7n ho\u1eb7c th\u00e1ng trong n\u0103m. Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o danh s\u00e1ch c\u1ee7a ri\u00eang m\u00ecnh \u0111\u1ec3 s\u1eafp x\u1ebfp nh\u1eefng \u0111\u1ed1i t\u01b0\u1ee3ng kh\u00e1c.<\/p>\n<p>\u0110\u1ec3 t\u1ea1o danh s\u00e1ch t\u00f9y ch\u1ec9nh ta l\u00e0m nh\u01b0 sau:<\/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-801.gif\" title=\"ex101_92019-nho-801\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>1. T\u1ea1o m\u1ed9t danh s\u00e1ch s\u1eb5n theo th\u1ee9 t\u1ef1 t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27339\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sap-xep-danh-sach-tuy-chinh-2.png\" width=\"65\" height=\"121\" title=\"sap-xep-danh-sach-tuy-chinh-2\"><\/p>\n<p>2. V\u00e0o\u00a0<strong>File<\/strong>, ch\u1ecdn\u00a0<strong>Options<\/strong> v\u00e0 ch\u1ecdn\u00a0<strong>Advanced<\/strong>. K\u00e9o xu\u1ed1ng v\u00e0 ch\u1ecdn \u201cEdit Custom Lists\u2026\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27340\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sap-xep-danh-sach-tuy-chinh-3.png\" width=\"832\" height=\"679\" title=\"sap-xep-danh-sach-tuy-chinh-3\"><\/p>\n<p>3. Ch\u1ecdn\u00a0<strong>\u201cImport\u201d<\/strong> \u0111\u1ec3 \u0111\u01b0a d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n v\u00e0o sau \u0111\u00f3 \u1ea5n OK<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27341\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sap-xep-danh-sach-tuy-chinh-4.png\" width=\"503\" height=\"378\" title=\"sap-xep-danh-sach-tuy-chinh-4\"><\/p>\n<p>V\u1eady l\u00e0 ta \u0111\u00e3 c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t danh s\u00e1ch t\u00f9y ch\u1ec9nh r\u1ed3i.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Sap_xep_du_lieu_su_dung_danh_sach_tuy_chinh\"><\/span>S\u1eafp x\u1ebfp d\u1eef li\u1ec7u s\u1eed d\u1ee5ng danh s\u00e1ch t\u00f9y ch\u1ec9nh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 x\u1ebfp d\u1eef li\u1ec7u theo danh s\u00e1ch t\u00f9y ch\u1ec9nh ta l\u00e0m nh\u01b0 sau:<\/p>\n<p>1. Ch\u1ecdn c\u1ed9t \u0111\u1ec3 x\u1ebfp.<\/p>\n<p>2. T\u1ea1i th\u1ebb\u00a0<strong>Data<\/strong>, ch\u1ecdn\u00a0<strong>Sort.\u00a0<\/strong>T\u1ea1i m\u1ee5c Order ch\u1ecdn \u201c<strong>Custom List\u2026\u201d<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27342\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sap-xep-danh-sach-tuy-chinh-6.png\" width=\"601\" height=\"269\" title=\"sap-xep-danh-sach-tuy-chinh-6\"><\/p>\n<p>3. Ch\u1ecdn danh s\u00e1ch v\u1eeba nh\u1eadp v\u00e0o v\u00e0 \u1ea5n\u00a0<strong>OK<\/strong>. Ta c\u00f3 k\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27343\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sap-xep-danh-sach-tuy-chinh-7.png\" width=\"159\" height=\"322\" title=\"sap-xep-danh-sach-tuy-chinh-7\"><\/p>\n<p>Ngo\u00e0i vi\u1ec7c s\u1eafp x\u1ebfp b\u1eb1ng danh s\u00e1ch t\u00f9y ch\u1ec9nh ra b\u1ea1n c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng danh s\u00e1ch n\u00e0y v\u00e0o nh\u1eefng c\u00f4ng vi\u1ec7c kh\u00e1c nh\u01b0 s\u1eed d\u1ee5ng Fill, danh s\u00e1ch g\u1ee3i \u00fd\u2026 t\u00f9y thu\u1ed9c v\u00e0o \u0111\u1ed9 s\u00e1ng t\u1ea1o v\u00e0 kh\u1ea3 n\u0103ng v\u1eadn d\u1ee5ng trong khi thao t\u00e1c v\u1edbi s\u1ed5 t\u00ednh Excel.<\/p>\n<p><strong>H\u01b0\u1edbng d\u1eabn <a href=\"http:\/\/blog.ezworkapp.com\/sap-xep-du-lieu-theo-nhieu-dieu-kien-trong-excel.html\">c\u00e1ch s\u1eafp x\u1ebfp d\u1eef li\u1ec7u<\/a> theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel<\/strong><\/p>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft kh\u00e1c li\u00ean quan:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/chuc-nang-sort-trong-bai-thi-mos.html\">S\u1eed d\u1ee5ng SORT c\u01a1 b\u1ea3n trong Excel<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tao-so-thu-tu-trong-excel-custom-lists.html\"><strong>T\u1ea1o danh s\u00e1ch t\u00f9y ch\u1ecdn b\u1eb1ng Custom Lists<\/strong><\/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-801.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8646,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8645","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\/8645","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=8645"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8645\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8646"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}