{"id":5149,"date":"2025-11-21T17:18:02","date_gmt":"2025-11-21T10:18:02","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-su-dung-data-validation-trong-excel-cuc-de-hieu\/"},"modified":"2025-11-21T17:18:02","modified_gmt":"2025-11-21T10:18:02","slug":"cach-su-dung-data-validation-trong-excel-cuc-de-hieu","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-su-dung-data-validation-trong-excel-cuc-de-hieu\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng Data Validation trong Excel c\u1ef1c d\u1ec5 hi\u1ec3u"},"content":{"rendered":"
\n
\u00a0<\/div>\n

Trong qu\u00e1 tr\u00ecnh nh\u1eadp li\u1ec7u, Excel r\u1ea5t d\u1ec5 ph\u00e1t sinh sai s\u00f3t n\u1ebfu kh\u00f4ng c\u00f3 c\u01a1 ch\u1ebf ki\u1ec3m so\u00e1t ph\u00f9 h\u1ee3p. \u0110\u1ec3 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 v\u00e0 gi\u1eef cho b\u1ea3ng t\u00ednh lu\u00f4n ch\u00ednh x\u00e1c, Data Validation tr\u1edf th\u00e0nh c\u00f4ng c\u1ee5 h\u1eefu \u00edch gi\u00fap thi\u1ebft l\u1eadp c\u00e1c quy t\u1eafc nh\u1eadp li\u1ec7u r\u00f5 r\u00e0ng, th\u1ed1ng nh\u1ea5t v\u00e0 h\u1ea1n ch\u1ebf l\u1ed7i ngay t\u1eeb \u0111\u1ea7u. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch s\u1eed d\u1ee5ng Data Validation trong Excel \u0111\u1ec3 b\u1ea1n \u00e1p d\u1ee5ng d\u1ec5 d\u00e0ng v\u00e0o c\u00f4ng vi\u1ec7c.<\/p>\n

\"Bi\u1ec3uH\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch d\u00f9ng Data Validation trong Excel \u0111\u01a1n gi\u1ea3n, nhanh ch\u00f3ng<\/em><\/p>\n

\n

1. Data Validation l\u00e0 g\u00ec?<\/h2>\n<\/div>\n

Data Validation (hay danh s\u00e1ch s\u1ed5 xu\u1ed1ng) trong Excel l\u00e0 t\u00ednh n\u0103ng gi\u00fap b\u1ea1n ki\u1ec3m so\u00e1t d\u1eef li\u1ec7u nh\u1eadp v\u00e0o \u00f4. Khi thi\u1ebft l\u1eadp, ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u00f3 th\u1ec3 ch\u1ecdn ho\u1eb7c nh\u1eadp nh\u1eefng gi\u00e1 tr\u1ecb \u0111\u00e3 \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh s\u1eb5n, tr\u00e1nh nh\u1eadp sai d\u1eef li\u1ec7u. Nh\u1edd \u0111\u00f3, vi\u1ec7c nh\u1eadp li\u1ec7u tr\u1edf n\u00ean nhanh h\u01a1n, ch\u00ednh x\u00e1c h\u01a1n v\u00e0 d\u1ec5 qu\u1ea3n l\u00fd h\u01a1n.<\/p>\n

\n

2. Ch\u1ee9c n\u0103ng c\u1ee7a Data Validation trong Excel<\/h2>\n<\/div>\n

Data Validation gi\u00fap ki\u1ec3m so\u00e1t d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o \u00f4 \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o th\u00f4ng tin \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng v\u00e0 \u0111\u00fang v\u1ecb tr\u00ed. T\u00ednh n\u0103ng n\u00e0y h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng nh\u1eadp li\u1ec7u chu\u1ea9n x\u00e1c v\u00e0 h\u1ea1n ch\u1ebf t\u1ed1i \u0111a sai s\u00f3t.<\/p>\n

M\u1ed9t s\u1ed1 ch\u1ee9c n\u0103ng ch\u00ednh g\u1ed3m:<\/strong><\/p>\n

    \n
  • T\u1ea1o danh s\u00e1ch th\u1ea3 xu\u1ed1ng \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng ch\u1ecdn nhanh c\u00e1c gi\u00e1 tr\u1ecb c\u00f3 s\u1eb5n trong Excel.<\/li>\n
  • Thi\u1ebft l\u1eadp quy t\u1eafc v\u00e0 c\u1ea3nh b\u00e1o v\u1ec1 lo\u1ea1i d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p cho t\u1eebng \u00f4 (s\u1ed1, ng\u00e0y th\u00e1ng, k\u00fd t\u1ef1\u2026).<\/li>\n
  • Hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o l\u1ed7i khi nh\u1eadp sai ho\u1eb7c kh\u00f4ng h\u1ee3p l\u1ec7, gi\u00fap ng\u01b0\u1eddi d\u00f9ng ph\u00e1t hi\u1ec7n v\u00e0 ch\u1ec9nh s\u1eeda k\u1ecbp th\u1eddi.<\/li>\n<\/ul>\n

    Ngo\u00e0i ra, Data Validation v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n n\u00e2ng cao c\u00f2n \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng trong nhi\u1ec1u t\u00e1c v\u1ee5 nh\u01b0 nh\u1eadp c\u00e1c k\u00fd t\u1ef1 gi\u1ed1ng nhau trong m\u1ed9t c\u1ed9t, t\u1ea1o b\u1ed9 ti\u00eau ch\u00ed c\u1ed1 \u0111\u1ecbnh cho b\u00e1o c\u00e1o t\u00e0i ch\u00ednh theo th\u00e1ng\/qu\u00fd\/n\u0103m hay ph\u00e2n lo\u1ea1i theo khu v\u1ef1c v\u00e0 qu\u1ed1c gia. T\u00ednh n\u0103ng n\u00e0y gi\u00fap qu\u00e1 tr\u00ecnh nh\u1eadp li\u1ec7u v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u tr\u1edf n\u00ean \u0111\u1ed3ng b\u1ed9 v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n

    \"B\u1ea3ngS\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Data Validation \u0111\u1ec3 t\u1ea1o danh s\u00e1ch th\u1ea3 xu\u1ed1ng trong Excel<\/em><\/p>\n

    \n

    3. C\u00e1ch s\u1eed d\u1ee5ng Data Validation trong Excel<\/h2>\n<\/div>\n

    B\u01b0\u1edbc 1: <\/strong>Ch\u1ecdn \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng danh s\u00e1ch ho\u1eb7c quy t\u1eafc nh\u1eadp li\u1ec7u.<\/p>\n

    Tr\u00ean thanh c\u00f4ng c\u1ee5, truy c\u1eadp th\u1ebb Data<\/strong> v\u00e0 ch\u1ecdn Data Validation<\/strong> trong nh\u00f3m Data Tools<\/strong>.<\/p>\n

    \"Ch\u1ecdnNh\u1ea5n v\u00e0o th\u1ebb Data<\/em><\/p>\n

    B\u01b0\u1edbc 2:<\/strong> T\u1ea1i tab Settings<\/strong>, x\u00e1c \u0111\u1ecbnh lo\u1ea1i d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ph\u00e9p nh\u1eadp trong m\u1ee5c Allow<\/strong>, sau \u0111\u00f3 thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n t\u1ea1i Data<\/strong> t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u00f4 \u0111\u00e3 ch\u1ecdn.<\/p>\n

    C\u00e1c t\u00f9y ch\u1ecdn trong Allow g\u1ed3m:<\/p>\n

      \n
    • Any Value:<\/strong> Kh\u00f4ng gi\u1edbi h\u1ea1n d\u1eef li\u1ec7u.<\/li>\n
    • Whole number:<\/strong> Ch\u1ec9 cho ph\u00e9p s\u1ed1 nguy\u00ean.<\/li>\n
    • Decimal:<\/strong> Cho ph\u00e9p nh\u1eadp s\u1ed1 th\u1ef1c.<\/li>\n
    • List: <\/strong>T\u1ea1o danh s\u00e1ch s\u1ed5 xu\u1ed1ng.<\/li>\n
    • Date:<\/strong> Ch\u1ec9 nh\u1eadp \u0111\u01b0\u1ee3c ng\u00e0y th\u00e1ng.<\/li>\n
    • Time:<\/strong> Ch\u1ec9 nh\u1eadp \u0111\u01b0\u1ee3c th\u1eddi gian.<\/li>\n
    • Text Length:<\/strong> Gi\u1edbi h\u1ea1n \u0111\u1ed9 d\u00e0i chu\u1ed7i k\u00fd t\u1ef1.<\/li>\n
    • Custom:<\/strong> T\u1ea1o \u0111i\u1ec1u ki\u1ec7n theo c\u00f4ng th\u1ee9c t\u00f9y ch\u1ec9nh.<\/li>\n<\/ul>\n

      \"H\u1ed9pC\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong Data Validation<\/em><\/p>\n

      V\u1edbi List<\/strong>, b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u v\u00e0o \u00f4 Source<\/strong> \u0111\u1ec3 t\u1ea1o danh s\u00e1ch th\u1ea3 xu\u1ed1ng. C\u00f3 3 c\u00e1ch ch\u1ecdn ngu\u1ed3n d\u1eef li\u1ec7u cho m\u1ee5c Source:<\/p>\n

        \n
      • C\u00e1ch 1:<\/strong> Ch\u1ecdn tr\u1ef1c ti\u1ebfp d\u00e3y \u00f4 l\u00e0m ngu\u1ed3n d\u1eef li\u1ec7u cho danh s\u00e1ch.<\/li>\n
      • C\u00e1ch 2:<\/strong> S\u1eed d\u1ee5ng m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean t\u1eeb tr\u01b0\u1edbc.<\/li>\n
      • C\u00e1ch 3<\/strong>: Nh\u1eadp th\u1ee7 c\u00f4ng c\u00e1c gi\u00e1 tr\u1ecb mu\u1ed1n hi\u1ec3n th\u1ecb v\u00e0o \u00f4 Source.<\/li>\n<\/ul>\n

        \"C\u00e0iThi\u1ebft l\u1eadp ngu\u1ed3n d\u1eef li\u1ec7u cho danh s\u00e1ch<\/em><\/p>\n

        V\u1edbi c\u00e1c lo\u1ea1i Whole number, Decimal, Date, Time, Text Length, Custom, Excel cho ph\u00e9p thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n \u1edf m\u1ee5c Data<\/strong> nh\u01b0:<\/p>\n

          \n
        • between:<\/strong> Gi\u00e1 tr\u1ecb n\u1eb1m trong kho\u1ea3ng Minimum \u2013 Maximum<\/li>\n
        • not between:<\/strong> Gi\u00e1 tr\u1ecb n\u1eb1m ngo\u00e0i kho\u1ea3ng<\/li>\n
        • equal to:<\/strong> B\u1eb1ng gi\u00e1 tr\u1ecb x\u00e1c \u0111\u1ecbnh<\/li>\n
        • not equal to:<\/strong> Kh\u00e1c gi\u00e1 tr\u1ecb x\u00e1c \u0111\u1ecbnh<\/li>\n
        • greater than \/ less than:<\/strong> L\u1edbn h\u01a1n ho\u1eb7c nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb nh\u1eadp<\/li>\n
        • greater than or equal to \/ less than or equal to: <\/strong>L\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng, nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng<\/li>\n<\/ul>\n

          \"Thi\u1ebftT\u00f9y ch\u1ecdn \u0111i\u1ec1u ki\u1ec7n trong m\u1ee5c Data<\/em><\/p>\n

          B\u01b0\u1edbc 3: <\/strong>Chuy\u1ec3n sang tab Input Message<\/strong> \u0111\u1ec3 t\u1ea1o h\u01b0\u1edbng d\u1eabn cho ng\u01b0\u1eddi d\u00f9ng. \u0110\u00e1nh d\u1ea5u ch\u1ecdn Show input message when cell is selected<\/strong>, sau \u0111\u00f3 nh\u1eadp Title<\/strong> v\u00e0 Input message<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb g\u1ee3i \u00fd khi ng\u01b0\u1eddi d\u00f9ng ch\u1ecdn \u00f4.<\/p>\n

          \"T\u1ea1oThi\u1ebft l\u1eadp th\u00f4ng b\u00e1o h\u01b0\u1edbng d\u1eabn nh\u1eadp li\u1ec7u<\/em><\/p>\n

          B\u01b0\u1edbc 4: <\/strong>\u0110\u1ec3 hi\u1ec3n th\u1ecb c\u1ea3nh b\u00e1o n\u1ebfu d\u1eef li\u1ec7u nh\u1eadp kh\u00f4ng h\u1ee3p l\u1ec7, v\u00e0o tab Error Alert<\/strong>.<\/p>\n

          B\u1eadt Show error alert after invalid data is entered<\/strong>, r\u1ed3i ch\u1ecdn Style (Stop, Warning ho\u1eb7c Information)<\/strong>. Ti\u1ebfp theo nh\u1eadp Title<\/strong> v\u00e0 Error message<\/strong> cho th\u00f4ng b\u00e1o l\u1ed7i.<\/p>\n

          \"T\u00f9yC\u00e0i \u0111\u1eb7t th\u00f4ng b\u00e1o b\u00e1o l\u1ed7i nh\u1eadp sai<\/em><\/p>\n

          B\u01b0\u1edbc 5:<\/strong> Ki\u1ec3m tra l\u1ea1i c\u00e1c thi\u1ebft l\u1eadp, sau \u0111\u00f3 nh\u1ea5n OK<\/strong> \u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/p>\n

          \"X\u00e1cX\u00e1c nh\u1eadn thi\u1ebft l\u1eadp Data Validation<\/em><\/p>\n

          Xem th\u00eam: <\/strong>C\u00e1ch t\u1ea1o Header v\u00e0 Footer trong Excel c\u1ef1c d\u1ec5 th\u1ef1c hi\u1ec7n<\/div>\n
          \n

          4. C\u00e1ch b\u1ecf \u0111\u1ecbnh d\u1ea1ng Data Validation<\/h2>\n<\/div>\n

          \u0110\u1ec3 x\u00f3a b\u1ecf thi\u1ebft l\u1eadp Data Validation<\/strong> trong Excel, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

          B\u01b0\u1edbc 1: <\/strong>Ch\u1ecdn \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u \u0111ang \u00e1p d\u1ee5ng Data Validation<\/strong>. Tr\u00ean thanh c\u00f4ng c\u1ee5, nh\u1ea5p chu\u1ed9t ch\u1ecdn Data<\/strong> \u2192 Data Validation<\/strong>.<\/p>\n

          \"m\u1edfCh\u1ecdn v\u00f9ng d\u1eef li\u1ec7u v\u00e0 m\u1edf Data Validation<\/em><\/p>\n

          B\u01b0\u1edbc 2: <\/strong>Trong h\u1ed9p tho\u1ea1i xu\u1ea5t hi\u1ec7n, nh\u1ea5n Clear All<\/strong> \u0111\u1ec3 lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 quy t\u1eafc ki\u1ec3m tra d\u1eef li\u1ec7u \u0111\u00e3 thi\u1ebft l\u1eadp.<\/p>\n

          \"H\u1ed9pNh\u1ea5n Clear All \u0111\u1ec3 x\u00f3a Data Validation<\/em><\/p>\n

          Data Validation l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch gi\u00fap b\u1ea1n ki\u1ec3m so\u00e1t d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3, gi\u1ea3m sai s\u00f3t v\u00e0 n\u00e2ng cao \u0111\u1ed9 ch\u00ednh x\u00e1c cho m\u1ecdi b\u1ea3ng t\u00ednh Excel. Khi n\u1eafm v\u1eefng c\u00e1ch thi\u1ebft l\u1eadp v\u00e0 \u00e1p d\u1ee5ng, vi\u1ec7c nh\u1eadp li\u1ec7u s\u1ebd tr\u1edf n\u00ean nhanh ch\u00f3ng v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n. \u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u th\u1ee7 thu\u1eadt h\u1eefu \u00edch.<\/p>\n

          N\u1ebfu b\u1ea1n th\u01b0\u1eddng xuy\u00ean x\u1eed l\u00fd b\u1ea3ng t\u00ednh Excel, m\u1ed9t chi\u1ebfc m\u00e1y t\u00ednh b\u1ea3ng c\u1ea5u h\u00ecnh m\u1ea1nh v\u00e0 m\u00e0n h\u00ecnh r\u1ed9ng s\u1ebd gi\u00fap thao t\u00e1c nh\u1eadp li\u1ec7u, thi\u1ebft l\u1eadp Data Validation v\u00e0 ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u nhanh ch\u00f3ng h\u01a1n. Tham kh\u1ea3o c\u00e1c m\u1eabu m\u00e1y t\u00ednh b\u1ea3ng ch\u00ednh h\u00e3ng, gi\u00e1 t\u1ed1t t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c m\u1ed7i ng\u00e0y.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

          \u00a0 Trong qu\u00e1 tr\u00ecnh nh\u1eadp li\u1ec7u, Excel r\u1ea5t d\u1ec5 ph\u00e1t sinh sai s\u00f3t n\u1ebfu kh\u00f4ng c\u00f3 c\u01a1 ch\u1ebf ki\u1ec3m so\u00e1t ph\u00f9 h\u1ee3p. \u0110\u1ec3 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 v\u00e0 gi\u1eef cho b\u1ea3ng t\u00ednh lu\u00f4n ch\u00ednh x\u00e1c, Data Validation tr\u1edf th\u00e0nh c\u00f4ng c\u1ee5 h\u1eefu \u00edch gi\u00fap thi\u1ebft l\u1eadp c\u00e1c quy t\u1eafc nh\u1eadp li\u1ec7u r\u00f5 r\u00e0ng, […]<\/p>\n","protected":false},"author":1,"featured_media":5150,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5149","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19414.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5149","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=5149"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5149\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5150"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}