{"id":12084,"date":"2025-01-15T06:59:21","date_gmt":"2025-01-15T06:59:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-data-validation-de-nhap-nhanh-du-lieu-tu-select-box\/"},"modified":"2025-01-15T06:59:21","modified_gmt":"2025-01-15T06:59:21","slug":"huong-dan-su-dung-data-validation-de-nhap-nhanh-du-lieu-tu-select-box","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-data-validation-de-nhap-nhanh-du-lieu-tu-select-box\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Data Validation \u0111\u1ec3 nh\u1eadp nhanh d\u1eef li\u1ec7u t\u1eeb select box"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>\u0110\u1ec3 \u00a0nh\u1eadp d\u1eef li\u1ec7u nhanh ch\u00f3ng cho m\u1ed9t s\u1ed1 \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh s\u1eb5n b\u1eb1ng m\u1ed9t list danh s\u00e1ch c\u1ea7n li\u1ec7t k\u00ea, ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Data Validation.<\/strong><\/em><\/p>\n<p style=\"text-align: justify\">B\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\">Ho\u0323c Excel Online<\/a><\/strong> s\u1ebd chia s\u1ebd cho c\u00e1c b\u1ea1n c\u00e1ch d\u00f9ng <strong><a href=\"http:\/\/blog.ezworkapp.com\/tao-mot-danh-sach-tuy-chon-trong-excel-tinh-dong-tu-mot-bang-tinh-khac.html\">Data Validation<\/a>\u00a0<\/strong>\u0111\u1ec3 t\u1ea1o list d\u1eef li\u1ec7u khi nh\u1eadp d\u1eef li\u1ec7u \u1edf \u00f4 <em>Gi\u1edbi t\u00ednh<\/em> v\u00e0 \u00f4 <em>Qu\u00ea qu\u00e1n<\/em> trong b\u1ea3ng sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4156 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tao-list-excel.png\" width=\"600\" height=\"400\" title=\"tao-list-excel\"><\/p>\n<ul>\n<li style=\"text-align: justify\">\u0110\u1eb7t tr\u1ecf chu\u1ed9t t\u1ea1i \u00f4 c\u1ea7n t\u1ea1o list x\u1ed5 xu\u1ed1ng (\u00f4 C3), v\u00e0o m\u1ee5c<strong> Data<\/strong>, ch\u1ecdn <strong>Data Validation<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4158 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tao-list-excel-1.png\" width=\"600\" height=\"264\" title=\"tao-list-excel-1\"><\/p>\n<ul>\n<li>H\u1ed9p tho\u1ea1i\u00a0<strong>Data Validation\u00a0<\/strong>xu\u1ea5t hi\u1ec7n. T\u1ea1i m\u1ee5c <strong>Allow<\/strong>, ch\u1ecdn<strong> List<\/strong> c\u00f2n t\u1ea1i m\u1ee5c <strong>Source<\/strong>, nh\u1eadp c\u00e1c danh s\u00e1ch c\u00f3 s\u1eb5n, v\u00ed d\u1ee5: \u0110\u1ed1i v\u1edbi gi\u1edbi t\u00ednh th\u00ec nh\u1eadp <em>Nam,N\u1eef\u00a0<\/em>r\u1ed3i nh\u1ea5n <strong>OK,\u00a0<\/strong>l\u00e0 xong!<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4159 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tao-list-excel-2.png\" width=\"600\" height=\"397\" title=\"tao-list-excel-2\"><\/p>\n<ul>\n<li>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c \u1edf \u00f4 gi\u1edbi t\u00ednh.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4160 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tao-list-excel-3.png\" width=\"600\" height=\"451\" title=\"tao-list-excel-3\"><\/p>\n<ul>\n<li>T\u01b0\u01a1ng t\u1ef1 \u1edf ph\u1ea7n Qu\u00ea qu\u00e1n, ta s\u1eed d\u1ee5ng\u00a0<strong>Data Validation\u00a0<\/strong>v\u00e0 c\u0169ng c\u00f3 m\u1ed9t list x\u1ed5 xu\u1ed1ng nhanh ch\u00f3ng.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4161 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tao-list-excel-4.png\" width=\"600\" height=\"508\" title=\"tao-list-excel-4\"><\/p>\n<p><strong>M\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft b\u1ea1n c\u00f3 th\u1ec3 quan t\u00e2m<\/strong><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-72.gif\" title=\"vba101_92019-nho-72\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-349.gif\" title=\"ex101_92019-nho-349\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li><strong><a href=\"https:\/\/blog.hocexcel.online\/su-khac-nhau-giua-ham-columns-va-ham-column-trong-excel.html\">S\u1ef1 kh\u00e1c nhau gi\u1eefa h\u00e0m COLUMNS v\u00e0 h\u00e0m COLUMN trong Excel<\/a><\/strong><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/ham-search-trong-excel-cach-dung-va-vi-du.html\"><strong>H\u00e0m SEARCH trong Excel, c\u00e1ch d\u00f9ng v\u00e0 v\u00ed d\u1ee5<\/strong><\/a><\/li>\n<li><strong><a href=\"https:\/\/blog.hocexcel.online\/bai-tap-huong-dan-su-dung-ket-hop-ham-if-voi-mot-so-ham-trong-excel.html\">B\u00e0i t\u1eadp h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p h\u00e0m IF v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m trong Excel<\/a><\/strong><\/li>\n<li><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-noi-chuoi-voi-dau-noi-tuy-chon-trong-excel.html\">H\u00e0m n\u1ed1i chu\u1ed7i v\u1edbi d\u1ea5u n\u1ed1i tu\u1ef3 ch\u1ecdn trong Excel<\/a>\u00a0<\/strong><\/li>\n<\/ul>\n<p>\u2014\u2014\u2014<\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener\">HocExcel.Online<\/a><\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-72.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12085,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12084","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\/12084","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=12084"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12084\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12085"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12084"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}