{"id":5992,"date":"2024-12-21T12:09:59","date_gmt":"2024-12-21T12:09:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-thiet-lap-hop-thoai-xo-xuong-dep-mat-cho-chuc-nang-kiem-duyet-du-lieu-data-validation-trong-excel\/"},"modified":"2024-12-21T12:09:59","modified_gmt":"2024-12-21T12:09:59","slug":"cach-thiet-lap-hop-thoai-xo-xuong-dep-mat-cho-chuc-nang-kiem-duyet-du-lieu-data-validation-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-thiet-lap-hop-thoai-xo-xuong-dep-mat-cho-chuc-nang-kiem-duyet-du-lieu-data-validation-trong-excel\/","title":{"rendered":"C\u00e1ch thi\u1ebft l\u1eadp h\u1ed9p tho\u1ea1i x\u1ed5 xu\u1ed1ng \u0111\u1eb9p m\u1eaft cho ch\u1ee9c n\u0103ng ki\u1ec3m duy\u1ec7t d\u1eef li\u1ec7u Data Validation trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, Blog H\u1ecdc Excel Online s\u1ebd gi\u1edbi thi\u1ec7u v\u1edbi b\u1ea1n c\u00e1ch \u0111\u1ec3 t\u1ea1o 1 h\u00f4p tho\u1ea1i x\u1ed5 xu\u1ed1ng cho ch\u1ee9c n\u0103ng <a href=\"http:\/\/blog.ezworkapp.com\/tao-mot-danh-sach-tuy-chon-trong-excel-tinh-dong-tu-mot-bang-tinh-khac.html\"><strong>Data Validation<\/strong><\/a> trong Excel. Ta c\u0169ng s\u1ebd t\u00ecm hi\u1ec3u v\u1ec1 m\u1ed9t s\u1ed1 k\u1ef9 thu\u1eadt n\u00e2ng cao \u0111\u1ec3 hi\u1ec3n th\u1ecb danh s\u00e1ch nhi\u1ec1u l\u1ef1a ch\u1ecdn Data Validation th\u00f4ng qua h\u00e0m Indirect.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9673\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/create-excel-data-validation-drop-down-list.png\" width=\"600\" height=\"338\" title=\"create-excel-data-validation-drop-down-list\"><\/p>\n<p style=\"text-align: justify\"><strong>Gi\u1edbi thi\u1ec7u\u00a0ch\u1ee9c n\u0103ng Data Validation trong Excel<\/strong><\/p>\n<p style=\"text-align: justify\">N\u00f3i m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n, <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-data-validation-de-nhap-nhanh-du-lieu-tu-select-box.html\">Data Validation<\/a> l\u00e0 ch\u1ee9c n\u0103ng ki\u1ec3m duy\u1ec7t d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o sao cho d\u1eef li\u1ec7u \u0111\u00fang ph\u1ea3i \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o \u0111\u00fang n\u01a1i \u0111\u00fang ch\u1ed7. Data Validation \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi nhi\u1ec1u m\u1ee5c \u0111\u00edch kh\u00e1c nhau, ch\u1eb3ng h\u1ea1n nh\u01b0 \u0111\u1ec3 nh\u1eadp c\u00e1c k\u00fd t\u1ef1 ch\u1eef gi\u1ed1ng nhau trong c\u00f9ng m\u1ed9t c\u1ed9t ho\u1eb7c x\u00e2y d\u1ef1ng bi\u1ec3u \u0111\u1ed3 b\u00e1o c\u00e1o t\u00e0i ch\u00ednh v\u1edbi c\u00e1c ti\u00eau ch\u00ed r\u00e0ng bu\u1ed9c (ch\u1eb3ng h\u1ea1n theo m\u1ed1c th\u1eddi gian h\u00e0ng th\u00e1ng, h\u00e0ng qu\u00fd, n\u1eeda n\u0103m, h\u00e0ng n\u0103m, theo t\u1eebng khu v\u1ef1c ho\u1eb7c theo t\u1eebng qu\u1ed1c gia)<\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch \u0111\u1ec3 t\u1ea1o h\u1ed9p tho\u1ea1i Data Validation x\u1ed5 xu\u1ed1ng trong Excel<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 1:<\/strong> B\u00f4i \u0111en m\u1ed9t \u00f4 t\u00ednh ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n t\u1ea1o h\u1ed9p tho\u1ea1i Data Validation x\u1ed5 xu\u1ed1ng<\/p>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn thanh t\u00e1c v\u1ee5 <strong>Data <\/strong>v\u00e0 click v\u00e0o m\u1ee5c <strong>Data Validation<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9674 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/how-to-add-data-validation-in-excel.png\" width=\"598\" height=\"115\" title=\"how-to-add-data-validation-in-excel\"><\/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-537.gif\" title=\"ex101_92019-nho-537\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Sau \u0111\u00f3 h\u1ed9p tho\u1ea1i Data Validation xu\u1ea5t hi\u1ec7n v\u1edbi r\u1ea5t nhi\u1ec1u l\u1ef1a ch\u1ecdn cho b\u1ea1n<\/p>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 3:<\/strong> Trong tab Settings, ch\u1ecdn List<\/p>\n<p style=\"text-align: justify\"><strong>B\u01b0\u1edbc 4:<\/strong> Ti\u1ebfp \u0111\u1ebfn b\u1ea1n \u0111i\u1ec1n danh s\u00e1ch c\u00e1c d\u1eef li\u1ec7u c\u1ea7n ki\u1ec3m duy\u1ec7t, ng\u0103n c\u00e1ch nhau b\u1edfi d\u1ea5u ph\u1ea9y v\u00e0o sau \u0111\u00f3 b\u1ea5m OK<\/p>\n<p style=\"text-align: justify\">(trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y ta s\u1ebd \u0111i\u1ec1n l\u1ea7n l\u01b0\u1ee3t t\u00ean c\u00e1c th\u00e1ng v\u00e0o \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn trong danh s\u00e1ch x\u1ed5 xu\u1ed1ng)<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9675\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-validation-options-window-with-complete-steps.png\" width=\"600\" height=\"381\" title=\"data-validation-options-window-with-complete-steps\"><\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch \u0111\u1ec3 th\u00eam c\u00e1c th\u00f4ng b\u00e1o d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp v\u00e0 c\u1ea3nh b\u00e1o l\u1ed7i x\u1ea3y ra v\u00e0o trong h\u1ed9p tho\u1ea1i x\u1ed5 xu\u1ed1ng<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1ed1i v\u1edbi th\u00f4ng b\u00e1o d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp:<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Trong c\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i Data Validation, Ch\u1ecdn tab Input Message -&gt; Click ch\u1ecdn v\u00e0o h\u1ed9p ki\u1ec3m \u0111\u1ea7u ti\u00ean<\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec1n v\u00e0o ph\u1ea7n Title n\u1ed9i dung kh\u00e1i qu\u00e1t c\u1ee7a th\u00f4ng b\u00e1o<\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec1n v\u00e0o ph\u1ea7n Input message n\u1ed9i dung th\u00f4ng b\u00e1o \u0111\u1ea7y \u0111\u1ee7 v\u1ec1 lo\u1ea1i d\u1eef li\u1ec7u m\u00e0 ng\u01b0\u1eddi d\u00f9ng s\u1ebd l\u1ef1a ch\u1ecdn \u0111\u1ec3 nh\u1eadp v\u00e0o<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9676\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/input-message-in-data-excel-data-validation.png\" width=\"600\" height=\"311\" title=\"input-message-in-data-excel-data-validation\"><\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1ed1i v\u1edbi c\u1ea3nh b\u00e1o l\u1ed7i:<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Trong c\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i Data Validation, Ch\u1ecdn tab Error Alert -&gt; Click ch\u1ecdn v\u00e0o h\u1ed9p ki\u1ec3m \u0111\u1ea7u ti\u00ean<\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng c\u1ea3nh b\u00e1o v\u00e0 \u0111i\u1ec1n n\u1ed9i dung kh\u00e1i qu\u00e1t c\u1ee7a l\u1ed7i c\u0169ng nh\u01b0 n\u1ed9i dung l\u1ed7i \u0111\u1ea7y \u0111\u1ee7 v\u00e0o c\u00e1c m\u1ee5c Title v\u00e0 Short Description.<\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00f3 b\u1ea5m OK<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\">\u0110\u1ecba ch\u1ec9 h\u1ecdc Excel t\u1ea1i H\u00e0 N\u1ed9i<\/a>\u00a0t\u1ed1t nh\u1ea5t<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>C\u00e1ch \u0111\u1ec3 t\u1ea1o h\u1ed9p tho\u1ea1i Data Validation x\u1ed5 xu\u1ed1ng cho v\u00f9ng d\u1eef li\u1ec7u\/v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u00f4i khi kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u1ea1o th\u1ee7 c\u00f4ng h\u1ed9p tho\u1ea1i d\u1eef li\u1ec7u x\u1ed5 xu\u1ed1ng trong \u00f4 d\u1eef li\u1ec7u ngu\u1ed3n. N\u1ebfu trong qu\u00e1 tr\u00ecnh nh\u1eadp li\u1ec7u sau n\u00e0y m\u00e0 b\u1ea1n c\u1ea7n ph\u1ea3i thay \u0111\u1ed5i hay c\u1eadp nh\u1eadp th\u00ec vi\u1ec7c n\u00e0y s\u1ebd tr\u1edf n\u00ean t\u01b0\u01a1ng \u0111\u1ed1i kh\u00f3 ch\u1ecbu.<\/p>\n<p style=\"text-align: justify\">Thay v\u00ec \u0111\u00f3, b\u1ea1n n\u00ean li\u00ean k\u1ebft \u0111\u1ebfn 1 d\u1ea3i \u00f4 m\u1edbi \u0111\u1ec3 d\u1ec5 d\u00e0ng c\u1eadp nh\u1eadt nh\u1eefng thay \u0111\u1ed5i v\u1ec1 n\u1ed9i dung d\u1eef li\u1ec7u<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 1: Ch\u1ecdn 1 \u00f4 t\u00ednh c\u1ea7n t\u1ea1o h\u1ed9p ki\u1ec3m Data Validation<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 2: \u0110i\u1ec1n c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a h\u1ed9p ki\u1ec3m v\u00e0o 1 c\u1ed9t kh\u00e1c<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 3: Click ch\u1ecdn tab Data Validation -&gt; Setting -&gt; Ch\u1ecdn \u201cList\u201d<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 4: Tr\u00ean ph\u1ea7n Source -&gt; B\u1ea5m v\u00e0o n\u00fat t\u00f4 \u0111en v\u00f9ng d\u1eef li\u1ec7u v\u00e0 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n c\u1ea7n, sau \u0111\u00f3 b\u1ea5m OK \u0111\u1ec3 ho\u00e0n t\u1ea5t<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9677 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/create-data-validation-list-from-range.png\" width=\"519\" height=\"355\" title=\"create-data-validation-list-from-range\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean, vi\u1ec7c thi\u1ebft l\u1eadp tr\u00ean tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n b\u1edfi v\u00ec n\u00f3 d\u1ec5 nh\u1eadn bi\u1ebft v\u00e0 c\u0169ng d\u1ec5 thao t\u00e1c h\u01a1n:<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 1: Ch\u1ecdn d\u1ea3i \u00f4 d\u1eef li\u1ec7u c\u1ea7n tham chi\u1ebfu<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 2: T\u00ecm \u0111\u1ebfn thanh t\u00e1c v\u1ee5 Formulas -&gt; Ch\u1ecdn \u201cDefine Name\u201d<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 3: D\u01b0\u1edbi m\u1ee5c Name -&gt; \u0110i\u1ec1n t\u00ean v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n (trong v\u00ed d\u1ee5 n\u00e0y ta ch\u1ecdn \u201clookup_range\u201d)<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 4: \u0110\u1eb7t Scope l\u00e0 Workbook, Ph\u1ea7n Comment ta s\u1ebd \u0111i\u1ec1n m\u1ed9t \u0111o\u1ea1n m\u00f4 t\u1ea3 ng\u1eafn \u0111\u1ec3 d\u1ec5 ph\u00e2n bi\u1ec7t -&gt; Sau \u0111\u00f3 click OK<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9678 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-validation-using-named-range.png\" width=\"477\" height=\"304\" title=\"data-validation-using-named-range\"><\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 5: Quay l\u1ea1i c\u1eeda s\u1ed5 Data Validation -&gt; Trong m\u1ee5c Source b\u1ea1n nh\u1eadp t\u00ean v\u00f9ng d\u1eef li\u1ec7u v\u1eeba t\u1ea1o (=lookup_range) l\u00e0 xong.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch t\u1ea1o h\u1ed9p tho\u1ea1i x\u1ed5 xu\u1ed1ng Data Validation c\u00f3 \u0111i\u1ec1u ki\u1ec7n r\u00e0ng bu\u1ed9c<\/strong><\/p>\n<p style=\"text-align: justify\">Ph\u1ea7n n\u00e0y ta s\u1ebd t\u00ecm hi\u1ec3u c\u00e1ch \u0111\u1ec3 t\u1ea1o 1 h\u1ed9p tho\u1ea1i linh \u0111\u1ed9ng v\u1edbi h\u00e0m Indirect<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 ti\u1ebfp theo ta c\u00f3 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c chia th\u00e0nh 2 lo\u1ea1i: \u0110\u1ed3 \u0111i\u1ec7n t\u1eed v\u00e0 S\u00e1ch<\/p>\n<p style=\"text-align: justify\">Khi ng\u01b0\u1eddi d\u00f9ng l\u1ef1a ch\u1ecdn \u0110\u1ed3 \u0111i\u1ec7n t\u1eed (Electronics) trong h\u1ed9p tho\u1ea1i x\u1ed5 xu\u1ed1ng, s\u1ebd c\u00f3 1 h\u1ed9p tho\u1ea1i kh\u00e1c xu\u1ea5t hi\u1ec7n trong \u0111\u00f3 ch\u1ee9a nh\u1eefng danh m\u1ee5c thu\u1ed9c h\u00e0ng \u0111i\u1ec7n t\u1eed, v\u00ed d\u1ee5 nh\u01b0 \u0111i\u1ec7n tho\u1ea1i di \u0111\u1ed9ng, laptop, v.v.<\/p>\n<p style=\"text-align: justify\">Khi ng\u01b0\u1eddi d\u00f9ng l\u1ef1a ch\u1ecdn S\u00e1ch (Books) trong h\u1ed9p tho\u1ea1i x\u1ed5 xu\u1ed1ng, s\u1ebd c\u00f3 1 h\u1ed9p tho\u1ea1i kh\u00e1c xu\u1ea5t hi\u1ec7n trong \u0111\u00f3 ch\u1ee9a nh\u1eefng danh m\u1ee5c c\u00e1c lo\u1ea1i s\u00e1ch, v\u00ed d\u1ee5 nh\u01b0 s\u00e1ch ti\u1ec3u thuy\u1ebft gi\u1ea3 t\u01b0\u1edfng, s\u00e1ch v\u0103n h\u1ecdc l\u00e3ng m\u1ea1n, s\u00e1ch ti\u1ec3u thuy\u1ebft th\u1ef1c t\u1ebf, v.v.<\/p>\n<p style=\"text-align: justify\">B\u1ed1 tr\u00ed b\u1ea3ng tham chi\u1ebfu:<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 1: B\u1ed1 tr\u00ed b\u1ea3ng tham chi\u1ebfu d\u01b0\u1edbi d\u1ea1ng nh\u01b0 sau. Ti\u00eau \u0111\u1ec1 c\u00e1c m\u1ee5c nh\u1ecf h\u01a1n c\u1ea7n \u0111\u01b0\u1ee3c b\u1ed1 tr\u00ed sang ph\u1ea3i d\u01b0\u1edbi d\u1ea1ng ti\u00eau \u0111\u1ec1 ch\u00ednh<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9681 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dynamic-lookup-table-for-data-validation.png\" width=\"564\" height=\"256\" title=\"dynamic-lookup-table-for-data-validation\"><\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 2: Ch\u1ecdn c\u1ea3 2 \u00f4 trong m\u1ee5c \u201cShop Category\u201d v\u00e0 \u0111\u1eb7t t\u00ean v\u00f9ng d\u1eef li\u1ec7u \u0111\u00f3 l\u00e0 \u201cShop_Category\u201d<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 3: L\u00e0m t\u01b0\u01a1ng t\u1ef1 v\u1edbi m\u1ee5c Electronics v\u00e0 Books<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 4: Ch\u1ecdn \u00f4 B1 v\u00e0 click v\u00e0o ph\u1ea7n Data Validation -&gt; List -&gt; \u0110i\u1ec1n t\u00ean danh m\u1ee5c \u0111\u1ea1i di\u1ec7n \u0111\u1ea7u ti\u00ean (\u201cShop_Category\u201d ch\u1eb3ng h\u1ea1n) v\u00e0 click OK<\/p>\n<p style=\"text-align: justify\">B\u1ea1n v\u1eeba ho\u00e0n t\u1ea5t vi\u1ec7c t\u1ea1o h\u1ed9p tho\u1ea1i x\u1ed5 xu\u1ed1ng \u0111\u1ea7u ti\u00ean, ti\u1ebfp theo ta c\u1ea7n t\u1ea1o th\u00eam 1 h\u1ed9p tho\u1ea1i n\u1eefa<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 5: Ch\u1ecdn \u00f4 B2 -&gt; Data Validation -&gt; List -&gt; Under Source -&gt; B\u1ea1n c\u1ea7n li\u00ean k\u1ebft v\u1edbi \u00f4 B1 b\u1eb1ng c\u00f4ng th\u1ee9c h\u00e0m Indirect nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9682 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/how-to-use-indirect-formula-for-data-validation.png\" width=\"499\" height=\"432\" title=\"how-to-use-indirect-formula-for-data-validation\"><\/p>\n<p style=\"text-align: justify\">V\u1eady l\u00e0 xong, k\u1ec3 t\u1eeb gi\u1edd n\u1ebfu b\u1ea1n l\u1ef1a ch\u1ecdn Electronics trong h\u1ed9p tho\u1ea1i \u0111\u1ea7u ti\u00ean, b\u1ea1n s\u1ebd ch\u1ec9 th\u1ea5y c\u00e1c m\u1ee5c nh\u1ecf h\u01a1n thu\u1ed9c \u0111\u1ed3 \u0111i\u1ec7n t\u1eed m\u00e0 th\u00f4i.<\/p>\n<p style=\"text-align: justify\">L\u00e0m t\u01b0\u01a1ng t\u1ef1 \u0111\u1ed1i v\u1edbi Books<\/p>\n<p style=\"text-align: justify\"><strong>Ghi ch\u00fa c\u1ea7n l\u01b0u \u00fd<\/strong><\/p>\n<p style=\"text-align: justify\">Ph\u01b0\u01a1ng ph\u00e1p tr\u00ean c\u00f3 m\u1ed9t s\u1ed1 h\u1ea1n ch\u1ebf nh\u01b0 sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>T\u00ean v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n \u0111\u1eb7t kh\u00f4ng \u0111\u01b0\u1ee3c ch\u1ee9a k\u00fd t\u1ef1 kho\u1ea3ng tr\u1eafng \u1edf trong. Ch\u1eb3ng h\u1ea1n, b\u1ea1n kh\u00f4ng n\u00ean \u0111\u1eb7t t\u00ean d\u01b0\u1edbi d\u1ea1ng \u201cMobile Phones\u201d m\u00e0 thay v\u00e0o \u0111\u00f3 ph\u1ea3i l\u00e0 \u201cMobile_Phones\u201d<\/li>\n<li>B\u1ea1n c\u0169ng kh\u00f4ng n\u00ean \u0111\u1eb7t t\u00ean d\u01b0\u1edbi d\u1ea1ng FY15, FY16, Q116, Q216, v.v. b\u1edfi v\u00ec Excel s\u1ebd m\u1eb7c \u0111\u1ecbnh r\u1eb1ng ch\u00fang l\u00e0 d\u1ea3i \u00f4 t\u00ednh th\u00f4ng th\u01b0\u1eddng.<\/li>\n<\/ul>\n<blockquote>\n<p>T\u00ecm hi\u1ec3u th\u00eam: T\u1ed5ng h\u1ee3p\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/thu-thuat-excel\">th\u1ee7 thu\u1eadt Excel hay<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>C\u00e1ch t\u00ecm c\u00e1c \u00f4 t\u00ednh ch\u1ee9a Data Validation trong Excel<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u00ecm c\u00e1c \u00f4 t\u00ednh ch\u1ee9a Data Validation, b\u1ea1n c\u1ea7n truy c\u1eadp thanh t\u00e1c v\u1ee5 Home -&gt; Click ch\u1ecdn Find &amp; Select\u00a0\u2192 Ch\u1ecdn Data Validation.<\/p>\n<p style=\"text-align: justify\">Khi \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c to\u00e0n b\u1ed9 nh\u1eefng \u00f4 t\u00ednh Excel ch\u1ee9a h\u1ed9p tho\u1ea1i x\u1ed5 xu\u1ed1ng Data Validation.<\/p>\n<p style=\"text-align: justify\">C\u00e1ch x\u00f3a h\u1ed9p ki\u1ec3m Data Validation trong Excel<\/p>\n<p style=\"text-align: justify\">R\u1ea5t \u0111\u01a1n gi\u1ea3n, b\u1ea1n ch\u1ec9 c\u1ea7n b\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a h\u1ed9p ki\u1ec3m Data Validation, sau \u0111\u00f3 Click v\u00e0o m\u1ee5c Data Validation -&gt; Ch\u1ecdn tab Settings -&gt; Trong h\u1ed9p ki\u1ec3m Allow, ch\u1ecdn \u201cAny Value\u201d<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9683\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/how-to-remove-data-validation-in-excel.png\" width=\"600\" height=\"346\" title=\"how-to-remove-data-validation-in-excel\"><\/p>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u01a1n gi\u1ea3n h\u01a1n \u0111\u00f3 l\u00e0 sao ch\u00e9p v\u00e0 d\u00e1n m\u1ed9t \u00f4 d\u1eef li\u1ec7u tr\u1eafng v\u00e0o ph\u1ea7n h\u1ed9p ki\u1ec3m Data Validation. Khi b\u1ea1n click v\u00e0o l\u1ef1a ch\u1ecdn \u0111\u00f3 th\u00ec to\u00e0n b\u1ed9 \u0111\u1ecbnh d\u1ea1ng \u0111\u01b0\u1ee3c ki\u1ec3m so\u00e1t b\u1edfi Data Validation s\u1ebd b\u1ecb ghi \u0111\u00e8 l\u00ean b\u1edfi \u0111\u1ecbnh d\u1ea1ng \u00f4 tr\u1ed1ng.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch t\u1ea1o h\u1ed9p tho\u1ea1i x\u1ed5 xu\u1ed1ng Data Validation b\u1eb1ng B\u1ea3ng \u0111i\u1ec3u khi\u1ec3n Form c\u1ee7a h\u1ed9p tho\u1ea1i h\u1ed7n h\u1ee3p<\/strong><\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 1: Ch\u1ecdn thanh t\u00e1c v\u1ee5 Developer -&gt; Insert -&gt; t\u1eeb b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n Form b\u1ea1n ch\u1ecdn H\u1ed9p tho\u1ea1i h\u1ed7n h\u1ee3p Combo Box -&gt; Ch\u00e8n h\u1ed9p tho\u1ea1i b\u1eb1ng chu\u1ed9t<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 2: Th\u00eam d\u1eef li\u1ec7u theo h\u00e0ng dung \u0111\u1ec3 tham chi\u1ebfu<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 3: Click chu\u1ed9t ph\u1ea3i v\u00e0o Combo Box v\u1eeba \u0111\u01b0\u1ee3c t\u1ea1o v\u00e0 ch\u1ecdn \u201cFormat Control\u201d<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 4: Trong tab Control, ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u nh\u1eadp v\u00e0o v\u00e0 ch\u1ecdn \u00f4 t\u00ednh \u0111\u01b0\u1ee3c li\u00ean k\u1ebft \u0111\u1ebfn -&gt; Click OK<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9684 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/how-to-add-combo-box-drop-dow-lint-in-excel.png\" width=\"562\" height=\"411\" title=\"how-to-add-combo-box-drop-dow-lint-in-excel\"><\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch s\u1eed d\u1ee5ng d\u1eef li\u1ec7u Combo Box<\/strong><\/p>\n<p style=\"text-align: justify\">Kh\u00f4ng gi\u1ed1ng v\u1edbi h\u1ed9p ki\u1ec3m Data Validation, h\u1ed9p tho\u1ea1i h\u1ed7n h\u1ee3p kh\u00f4ng ph\u1ee5 thu\u1ed9c v\u00e0o b\u1ea5t c\u1ee9 \u00f4 t\u00ednh n\u00e0o n\u00ean b\u1ea1n kh\u00f4ng th\u1ec3 tr\u1ef1c ti\u1ebfp li\u00ean k\u1ebft c\u00f4ng th\u1ee9c \u0111\u1ebfn \u0111\u1ec3 tham chi\u1ebfu k\u1ebft qu\u1ea3 c\u1ee7a h\u1ed9p tho\u1ea1i \u0111\u01b0\u1ee3c.<\/p>\n<p style=\"text-align: justify\">Do t\u00ednh ch\u1ea5t c\u1ee7a m\u1ed9t h\u1ed9p tho\u1ea1i \u0111\u1ed9c l\u1eadp n\u00ean ta c\u1ea7n ph\u1ea3i \u0111i v\u00f2ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u n\u00e0y:<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 1: Sau khi thi\u1ebft l\u1eadp xong cho h\u1ed9p tho\u1ea1i h\u1ed7n h\u1ee3p Combo box, ch\u1ecdn 1 gi\u00e1 tr\u1ecb b\u1ea5t k\u00ec trong danh s\u00e1ch x\u1ed5 xu\u1ed1ng<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 2: B\u1ea1n s\u1ebd th\u1ea5y c\u00f3 1 d\u00e3y s\u1ed1 trong \u00f4 li\u00ean k\u1ebft<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 3: Quay l\u1ea1i \u00f4 t\u00ednh ch\u1ee9a d\u1eef li\u1ec7u tham chi\u1ebfu v\u00e0 th\u00eam d\u00e3y s\u1ed1 tr\u00ean v\u00e0o \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n tham chi\u1ebfu<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 4: Ch\u1ecdn 1 \u00f4 g\u1ea7n v\u1edbi form v\u00e0 th\u1ef1c hi\u1ec7n vi\u1ec7c tham chi\u1ebfu b\u1eb1ng Vlookup th\u00f4ng qua d\u00e3y s\u1ed1 tr\u00ean<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 5: S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Vlookup trong thanh c\u00f4ng th\u1ee9c.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9685\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/combo-box-drop-down-in-excel.png\" width=\"600\" height=\"268\" title=\"combo-box-drop-down-in-excel\"><\/p>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">H\u1ecdc l\u1eadp tr\u00ecnh VBA trong Excel \u1edf \u0111\u00e2u<\/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":"<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-537.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5993,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5992","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\/5992","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=5992"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5992\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5993"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}