{"id":7980,"date":"2024-12-21T19:15:18","date_gmt":"2024-12-21T19:15:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/data-validation-taodrop-down-list-da-cap-phuc-tap\/"},"modified":"2024-12-21T19:15:18","modified_gmt":"2024-12-21T19:15:18","slug":"data-validation-taodrop-down-list-da-cap-phuc-tap","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/data-validation-taodrop-down-list-da-cap-phuc-tap\/","title":{"rendered":"Data Validation, t\u1ea1o\u201dDrop-down list\u201d \u0111a c\u1ea5p ph\u1ee9c t\u1ea1p"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><strong>B\u1ea1n \u0111\u00e3 d\u00f9ng Data Validation \u0111\u1ec3 t\u1ea1o \u201cDrop-down list\u201d?<\/strong><\/p>\n<p>Th\u1ef1c s\u1ef1 \u0111ieu n\u00e0y kh\u00e1 kh\u00f3 kh\u0103n \u0111\u1ed1i v\u1edbi ng\u01b0\u1eddi m\u1edbi h\u1ecdc. B\u1ea1n c\u1ea7n c\u00f3 m\u1ed9t n\u1ec1n t\u1ea3ng Excel kh\u00e1 v\u1eefng, am hi\u1ec3u c\u00e1c c\u00f4ng th\u1ee9c Excel, m\u1ed9t s\u1ef1 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u, v\u00e0 c\u1ea3 th\u1eddi gian n\u1eefa. Trong video n\u00e0y, m\u00ecnh s\u1ebd share m\u1ed9t c\u00e1ch l\u00e0m kh\u00e1 \u0111\u01a1n gi\u1ea3n, m\u00e0 c\u1ef1c k\u1ef3 hi\u1ec7u qu\u1ea3 chuy\u00ean nghi\u1ec7p:<\/p>\n<ul>\n<li>Kh\u00f4ng c\u1ea7n t\u1ea1o qu\u00e1 nhi\u1ec1u c\u00f4ng th\u1ee9c.<\/li>\n<li>Th\u1ef1c hi\u1ec7n d\u1ec5 d\u00e0ng.<\/li>\n<li>D\u1ec5 d\u00e0ng thay \u0111\u1ed5i danh s\u00e1ch.<\/li>\n<\/ul>\n<p>C\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n ch\u1ec9 l\u00e0 t\u1ea1o c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u m\u00f4 t\u1ea3 c\u00e1c m\u1ee9c danh s\u00e1ch, sau \u0111\u00f3 d\u00f9ng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n l\u00e0 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u1ea1o m\u1ed9t \u201cDrop-down list\u201d m\u1ea1nh m\u1ebd, v\u1edbi 3 c\u1ea5p \u00e1p d\u1ee5ng trong video m\u00e0 ch\u1ec9 c\u1ea7n 3 c\u00f4ng th\u1ee9c, qu\u00e1 d\u1ec5 d\u00e0ng ph\u1ea3i kh\u00f4ng?<\/p>\n<iframe loading=\"lazy\" title=\"\"Drop-down list\" \u0111a c\u1ea5p ph\u1ee9c t\u1ea1p cho c\u00e1c \u0111\u01a1n v\u1ecb h\u00e0nh ch\u00ednh trong Excel. (V2)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/K9tUD9YIPjw?feature=oembed\" frameborder allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<blockquote>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\">Kh\u00f3a h\u1ecdc word excel<\/a><\/p>\n<\/blockquote>\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":"<p>B\u1ea1n \u0111\u00e3 d\u00f9ng Data Validation \u0111\u1ec3 t\u1ea1o \u201cDrop-down list\u201d? Th\u1ef1c s\u1ef1 \u0111ieu n\u00e0y kh\u00e1 kh\u00f3..<\/p>\n","protected":false},"author":1,"featured_media":7981,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7980","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7980","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=7980"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7980\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7981"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7980"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}