{"id":10275,"date":"2025-01-12T09:32:25","date_gmt":"2025-01-12T09:32:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/12\/huong-dan-cach-tao-danh-sach-chon-theo-cac-bieu-tuong-trong-excel\/"},"modified":"2025-01-12T09:32:25","modified_gmt":"2025-01-12T09:32:25","slug":"huong-dan-cach-tao-danh-sach-chon-theo-cac-bieu-tuong-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/12\/huong-dan-cach-tao-danh-sach-chon-theo-cac-bieu-tuong-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o danh s\u00e1ch ch\u1ecdn theo c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ch\u1eafc h\u1eb3n b\u1ea1n \u0111\u00e3 t\u1eebng nghe n\u00f3i t\u1edbi vi\u1ec7c t\u1ea1o danh s\u00e1ch ch\u1ecdn trong Excel v\u1edbi ch\u1ee9c n\u0103ng Data Validation c\u1ee7a Excel. Nh\u01b0ng \u0111\u1ec3 c\u00f3 th\u1ec3 t\u1ea1o \u0111\u01b0\u1ee3c 1 danh s\u00e1ch ch\u1ecdn c\u00f3 bao g\u1ed3m theo c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng th\u00ec l\u00e0m th\u1ebf n\u00e0o? H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.<\/p>\n<p>M\u1ee5c ti\u00eau c\u1ee7a b\u00e0i vi\u1ebft n\u00e0y l\u00e0 ch\u00fang ta c\u00f3 th\u1ec3 t\u1ea1o \u0111\u01b0\u1ee3c 1 danh s\u00e1ch ch\u1ecdn c\u00f3 bao g\u1ed3m c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng nh\u01b0 sau:<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20547\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tao-danh-sach-chon-theo-bieu-tuong.png\" width=\"513\" height=\"179\" title=\"tao-danh-sach-chon-theo-bieu-tuong\"><\/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-67838c28adfe5\" 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\/huong-dan-cach-tao-danh-sach-chon-theo-cac-bieu-tuong-trong-excel.html#Cach_chen_bieu_tuong_vao_trong_o_tren_Excel\" title=\"C\u00e1ch ch\u00e8n bi\u1ec3u t\u01b0\u1ee3ng v\u00e0o trong \u00f4 tr\u00ean Excel\">C\u00e1ch ch\u00e8n bi\u1ec3u t\u01b0\u1ee3ng v\u00e0o trong \u00f4 tr\u00ean Excel<\/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\/huong-dan-cach-tao-danh-sach-chon-theo-cac-bieu-tuong-trong-excel.html#Cach_thiet_lap_tao_danh_sach_chon_theo_bieu_tuong\" title=\"C\u00e1ch thi\u1ebft l\u1eadp t\u1ea1o danh s\u00e1ch ch\u1ecdn theo bi\u1ec3u t\u01b0\u1ee3ng\">C\u00e1ch thi\u1ebft l\u1eadp t\u1ea1o danh s\u00e1ch ch\u1ecdn theo bi\u1ec3u t\u01b0\u1ee3ng<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_chen_bieu_tuong_vao_trong_o_tren_Excel\"><\/span>C\u00e1ch ch\u00e8n bi\u1ec3u t\u01b0\u1ee3ng v\u00e0o trong \u00f4 tr\u00ean Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Gi\u1ed1ng nh\u01b0 Microsoft Word, Excel c\u0169ng cho ph\u00e9p ch\u00fang ta ch\u00e8n c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng. \u0110\u1ec3 ch\u00e8n c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng n\u00e0y th\u00ec ch\u00fang ta s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng <strong>Insert &gt; Symbol<\/strong><\/p>\n<p>T\u1ea1i 1 \u00f4 b\u1ea5t k\u1ef3, ch\u00fang ta ch\u1ecdn th\u1ebb <strong>Insert<\/strong>. Ti\u1ebfp theo ch\u1ecdn m\u1ee5c <strong>Symbol.<\/strong><\/p>\n<p>Trong c\u1eeda s\u1ed5 Symbol, m\u1ee5c <strong>Font<\/strong> ch\u1ecdn lo\u1ea1i font l\u00e0 <strong>Arial.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20548\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/insert-symbol-arial-excel.png\" width=\"1052\" height=\"639\" title=\"insert-symbol-arial-excel\"><\/p>\n<p>T\u1ea1i \u0111\u00e2y ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ecdn 1 s\u1ed1 bi\u1ec3u t\u01b0\u1ee3ng theo \u00fd mu\u1ed1n.<\/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-150.gif\" title=\"ex101_92019-nho-150\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Khi ch\u00e8n c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng th\u00ec ch\u00fa \u00fd m\u1ed7i \u00f4 s\u1ebd ch\u1ee9a 1 bi\u1ec3u t\u01b0\u1ee3ng. Do \u0111\u00f3 n\u1ebfu b\u1ea1n ch\u00e8n nhi\u1ec1u bi\u1ec3u t\u01b0\u1ee3ng trong c\u00f9ng 1 \u00f4 th\u00ec s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng thao t\u00e1c Cut\/Paste \u0111\u1ec3 \u0111\u01b0a m\u1ed7i bi\u1ec3u t\u01b0\u1ee3ng v\u00e0o 1 \u00f4. C\u00e1c \u00f4 s\u1eafp x\u1ebfp theo chi\u1ec1u d\u1ecdc.<\/p>\n<p>Khi t\u1ea1o c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng th\u00ec c\u00f3 th\u1ec3 vi\u1ebft k\u00e8m theo c\u00e1c k\u00fd t\u1ef1 Text.<\/p>\n<p>V\u00ed d\u1ee5 ch\u00fang ta t\u1ea1o 1 danh s\u00e1ch t\u1eeb A3:A9 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20549\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/insert-symbol-arial-excel-danh-sach-symbol.png\" width=\"505\" height=\"281\" title=\"insert-symbol-arial-excel-danh-sach-symbol\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_thiet_lap_tao_danh_sach_chon_theo_bieu_tuong\"><\/span>C\u00e1ch thi\u1ebft l\u1eadp t\u1ea1o danh s\u00e1ch ch\u1ecdn theo bi\u1ec3u t\u01b0\u1ee3ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>T\u1ea1i \u00f4 B1 ch\u00fang ta s\u1ebd thi\u1ebft l\u1eadp ch\u1ee9c n\u0103ng Data Validation\/List nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20550\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/data-validation-theo-list-symbol.png\" width=\"1097\" height=\"408\" title=\"data-validation-theo-list-symbol\"><\/p>\n<ul>\n<li>T\u1ea1i \u00f4 B1 ch\u1ecdn th\u1ebb Data &gt; Data Validation<\/li>\n<li>Trong c\u1eeda s\u1ed5 Data Validation ch\u1ecdn m\u1ee5c Settings \/ Allow: ch\u1ecdn List (danh s\u00e1ch)<\/li>\n<li>Ngu\u1ed3n cho danh s\u00e1ch (Source) ch\u1ecdn v\u00f9ng A3:A9<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-20551\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/data-validation-theo-list-symbol-ket-qua.png\" width=\"539\" height=\"285\" title=\"data-validation-theo-list-symbol-ket-qua\"><\/p>\n<p>R\u1ea5t \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o. Vi\u1ec7c s\u1eed d\u1ee5ng Symbol trong Excel c\u00f3 r\u1ea5t nhi\u1ec1u \u1ee9ng d\u1ee5ng trong b\u00e1o c\u00e1o. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-2-cach-tu-dong-dinh-dang-du-lieu-theo-icon-trong-excel.html\">H\u01b0\u1edbng d\u1eabn 2 c\u00e1ch t\u1ef1 \u0111\u1ed9ng \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u theo icon trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tao-data-validation-voi-name-dong-trong-excel-voi-ham-offset-va-counta.html\">T\u1ea1o data validation v\u1edbi name \u0111\u1ed9ng trong Excel v\u1edbi h\u00e0m Offset v\u00e0 counta<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0<a href=\"http:\/\/bit.ly\/2uHAJ3W\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online \u0111ang c\u00f3 ch\u01b0\u01a1ng tr\u00ecnh \u01b0u \u0111\u00e3i r\u1ea5t h\u1ea5p d\u1eabn khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i:<\/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-150.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10276,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10275","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\/10275","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=10275"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10275\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10276"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10275"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}