{"id":9551,"date":"2025-01-02T09:46:27","date_gmt":"2025-01-02T09:46:27","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-tao-danh-sach-tuy-chon-trong-excel-voi-custom-lists\/"},"modified":"2025-01-02T09:46:27","modified_gmt":"2025-01-02T09:46:27","slug":"huong-dan-tao-danh-sach-tuy-chon-trong-excel-voi-custom-lists","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-tao-danh-sach-tuy-chon-trong-excel-voi-custom-lists\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1ea1o danh s\u00e1ch t\u00f9y ch\u1ecdn trong Excel v\u1edbi Custom Lists"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n mu\u1ed1n t\u1ea1o m\u1ed9t ho\u1eb7c nhi\u1ec1u danh s\u00e1ch \u0111\u1ec3 s\u1eed d\u1ee5ng cho vi\u1ec7c thay \u0111\u1ed5i th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp ho\u1eb7c t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n. \u0110i\u1ec1u n\u00e0y ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n v\u1edbi ch\u1ee9c n\u0103ng Custom Lists. 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: T\u1ea1o danh s\u00e1ch t\u00f9y ch\u1ecdn v\u1edbi Custom Lists.<\/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-67766072bc7c6\" 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\/tao-so-thu-tu-trong-excel-custom-lists.html#Chuc_nang_Custom_Lists\" title=\"Ch\u1ee9c n\u0103ng Custom Lists\">Ch\u1ee9c n\u0103ng Custom Lists<\/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\/tao-so-thu-tu-trong-excel-custom-lists.html#Mot_so_cach_su_dung_danh_sach_tuy_chon_tao_ra_tu_Custom_Lists\" title=\"M\u1ed9t s\u1ed1 c\u00e1ch s\u1eed d\u1ee5ng danh s\u00e1ch t\u00f9y ch\u1ecdn t\u1ea1o ra t\u1eeb Custom Lists\">M\u1ed9t s\u1ed1 c\u00e1ch s\u1eed d\u1ee5ng danh s\u00e1ch t\u00f9y ch\u1ecdn t\u1ea1o ra t\u1eeb Custom Lists<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tao-so-thu-tu-trong-excel-custom-lists.html#Dien_du_lieu_voi_danh_sach_tuy_chon\" title=\"\u0110i\u1ec1n d\u1eef li\u1ec7u v\u1edbi danh s\u00e1ch t\u00f9y ch\u1ecdn\">\u0110i\u1ec1n d\u1eef li\u1ec7u v\u1edbi danh s\u00e1ch t\u00f9y ch\u1ecdn<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/tao-so-thu-tu-trong-excel-custom-lists.html#Sap_xep_danh_sach_tuy_chon\" title=\"S\u1eafp x\u1ebfp danh s\u00e1ch t\u00f9y ch\u1ecdn\">S\u1eafp x\u1ebfp danh s\u00e1ch t\u00f9y ch\u1ecdn<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Chuc_nang_Custom_Lists\"><\/span>Ch\u1ee9c n\u0103ng Custom Lists<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Custom Lists cho ph\u00e9p t\u1ea1o ra nh\u1eefng danh s\u00e1ch theo \u00fd c\u1ee7a ng\u01b0\u1eddi s\u1eed d\u1ee5ng.<\/p>\n<p>V\u1ecb tr\u00ed: Th\u1ebb\u00a0<strong>Home<\/strong>, h\u1ed9p tho\u1ea1i\u00a0<strong>Excel Options,<\/strong>\u00a0m\u1ee5c\u00a0<strong>Advanced<\/strong>, nh\u00f3m\u00a0<strong>General.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23998\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/custom-lists-1.png\" width=\"578\" height=\"466\" title=\"custom-lists-1\"><\/p>\n<p>Trong h\u1ed9p tho\u1ea1i\u00a0<strong>Custom Lists<\/strong> c\u00f3 g\u00ec?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23999\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/custom-lists-2.png\" width=\"739\" height=\"506\" title=\"custom-lists-2\"><\/p>\n<p>Custom Lists chia l\u00e0m 2 ph\u1ea7n ch\u00ednh:<\/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-65.gif\" title=\"ex101_92019-nho-65\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol>\n<li>Danh s\u00e1ch c\u00f3 s\u1eb5n. Nh\u1eefng danh s\u00e1ch n\u00e0y bao g\u1ed3m m\u1eb7c \u0111\u1ecbnh c\u1ee7a h\u1ec7 th\u1ed1ng, v\u00e0 ng\u01b0\u1eddi s\u1eed d\u1ee5ng nh\u1eadp v\u00e0o.<\/li>\n<li>Th\u00eam ho\u1eb7c x\u00f3a danh s\u00e1ch. Ch\u1ecdn Import \u0111\u1ec3 l\u1ea5y danh s\u00e1ch t\u1eeb trong trang t\u00ednh Excel, ho\u1eb7c c\u00f3 th\u1ec3 nh\u1eadp tr\u1ef1c ti\u1ebfp v\u00e0o b\u1ea3ng\u00a0<em>List entries<\/em>. \u1ea4n Add \u0111\u1ec3 th\u00eam v\u00e0o danh s\u00e1ch, Delete \u0111\u1ec3 x\u00f3a danh s\u00e1ch \u0111i.<\/li>\n<\/ol>\n<p>B\u1ea1n kh\u00f4ng th\u1ec3 x\u00f3a\u00a0danh s\u00e1ch m\u1eb7c \u0111\u1ecbnh c\u1ee7a h\u1ec7 th\u1ed1ng.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Mot_so_cach_su_dung_danh_sach_tuy_chon_tao_ra_tu_Custom_Lists\"><\/span>M\u1ed9t s\u1ed1 c\u00e1ch s\u1eed d\u1ee5ng danh s\u00e1ch t\u00f9y ch\u1ecdn t\u1ea1o ra t\u1eeb Custom Lists<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>2 \u1ee9ng d\u1ee5ng\u00a0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ec3n c\u1ee7a Custom Lists l\u00e0\u00a0<strong>s\u1eafp x\u1ebfp (<\/strong><strong>sort)<\/strong> v\u00e0\u00a0<strong>\u0111i\u1ec1n d\u1eef li\u1ec7u (fill).<\/strong><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Dien_du_lieu_voi_danh_sach_tuy_chon\"><\/span>\u0110i\u1ec1n d\u1eef li\u1ec7u v\u1edbi danh s\u00e1ch t\u00f9y ch\u1ecdn<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 \u0111i\u1ec1n d\u1eef li\u1ec7u v\u1edbi danh s\u00e1ch ta ch\u1ec9 c\u1ea7n nh\u1eadp m\u1ed9t ph\u1ea7n t\u1eed b\u1ea5t k\u1ef3 c\u1ee7a d\u00e3y, sau \u0111\u00f3 s\u1eed d\u1ee5ng con tr\u1ecf chu\u1ed9t k\u00e9o th\u1ea3 \u0111\u1ec3 ho\u00e0n th\u00e0nh thao t\u00e1c fill.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24000\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/custom-lists-3.png\" width=\"768\" height=\"66\" title=\"custom-lists-3\"><\/p>\n<p>Tuy v\u1eady trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, c\u00e1c danh s\u00e1ch c\u1ee7a ta v\u00f4 t\u00ecnh tr\u00f9ng l\u1eb7p khi\u1ebfn k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb sai.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24002\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/custom-lists-4.png\" width=\"500\" height=\"380\" title=\"custom-lists-4\"><\/p>\n<p>\u0110\u1ec3 x\u1eed l\u00fd t\u00ecnh hu\u1ed1ng n\u00e0y ta l\u1ef1a ch\u1ecdn nh\u1eefng gi\u00e1 tr\u1ecb kh\u00e1c bi\u1ec7t c\u1ee7a danh s\u00e1ch c\u1ea7n \u0111i\u1ec1n so v\u1edbi danh s\u00e1ch c\u00f2n l\u1ea1i, sau \u0111\u00f3 s\u1eed d\u1ee5ng thao t\u00e1c k\u00e9o b\u00ecnh th\u01b0\u1eddng. Tuy nhi\u00ean, trong tr\u01b0\u1eddng h\u1ee3p c\u00f3 nhi\u1ec1u list tr\u00f9ng nhau, vi\u1ec7c l\u1ef1a ch\u1ecdn gi\u00e1 tr\u1ecb \u0111\u1ed9c nh\u1ea5t s\u1ebd r\u1ea5t kh\u00f3 kh\u0103n. B\u1edfi v\u1eady, t\u1ed1t nh\u1ea5t l\u00e0 ti\u1ebfn h\u00e0nh nh\u1eadp\u00a0<em>\u00edt nh\u1ea5t<\/em> 2 gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t danh s\u00e1ch r\u1ed3i ti\u1ebfn h\u00e0nh fill.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24006\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/custom-lists-5.png\" width=\"448\" height=\"102\" title=\"custom-lists-5\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Sap_xep_danh_sach_tuy_chon\"><\/span>S\u1eafp x\u1ebfp danh s\u00e1ch t\u00f9y ch\u1ecdn<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>M\u1ed9t \u1ee9ng d\u1ee5ng n\u1eefa c\u1ee7a Custom Lists: gi\u00fap ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t \u201clu\u1eadt\u201d \u0111\u1ec3 s\u1eafp x\u1ebfp.<\/p>\n<p>VD: L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eafp x\u1ebfp danh s\u00e1ch n\u00e0y t\u1eeb\u00a0<strong>M\u1ed9t<\/strong> \u0111\u1ebfn\u00a0<strong>Ch\u00edn?<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24007\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/custom-lists-6.png\" width=\"136\" height=\"207\" title=\"custom-lists-6\"><\/p>\n<p>A to Z? Z to A?<\/p>\n<p>Kh\u00f4ng.<\/p>\n<p>H\u00e3y s\u1eafp x\u1ebfp theo\u00a0<strong>Custom Lists<\/strong>.<\/p>\n<figure id=\"attachment_24008\" aria-describedby=\"caption-attachment-24008\" style=\"width: 593px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24008\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/custom-lists-7.png\" width=\"593\" height=\"274\" title=\"custom-lists-7\"><figcaption id=\"caption-attachment-24008\" class=\"wp-caption-text\">Ch\u1ecdn nh\u01b0 n\u00e0y<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<figure id=\"attachment_24009\" aria-describedby=\"caption-attachment-24009\" style=\"width: 788px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24009\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/custom-lists-8.png\" width=\"788\" height=\"319\" title=\"custom-lists-8\"><figcaption id=\"caption-attachment-24009\" class=\"wp-caption-text\">V\u00e0 k\u1ebft qu\u1ea3<\/figcaption><\/figure>\n<p>V\u1eady l\u00e0 xong. Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/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\/2025\/01\/ex101_92019-nho-65.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9552,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9551","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\/9551","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=9551"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9551\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9552"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}