{"id":6530,"date":"2024-12-21T15:32:10","date_gmt":"2024-12-21T15:32:10","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-gioi-han-loai-du-lieu-nhap-vao-o-trong-excel\/"},"modified":"2024-12-21T15:32:10","modified_gmt":"2024-12-21T15:32:10","slug":"cach-gioi-han-loai-du-lieu-nhap-vao-o-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-gioi-han-loai-du-lieu-nhap-vao-o-trong-excel\/","title":{"rendered":"C\u00e1ch gi\u1edbi h\u1ea1n lo\u1ea1i d\u1eef li\u1ec7u nh\u1eadp v\u00e0o \u00f4 trong Excel"},"content":{"rendered":"
\n

Th\u1ec9nh tho\u1ea3ng khi thi\u1ebft k\u1ebf m\u1ed9t b\u1ea3ng t\u00ednh, b\u1ea1n mu\u1ed1n ki\u1ec3m so\u00e1t lo\u1ea1i d\u1eef li\u1ec7u m\u00e0 ng\u01b0\u1eddi d\u00f9ng s\u1ebd nh\u1eadp v\u00e0o. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 gi\u1edbi h\u1ea1n ki\u1ec3u d\u1eef li\u1ec7u nh\u1eadp v\u00e0o l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1 ho\u1eb7c t\u1eeb m\u1ed9t danh s\u00e1ch ch\u1ec9 \u0111\u1ecbnh. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch nhanh ch\u00f3ng \u0111\u1ec3 gi\u1edbi h\u1ea1n d\u1eef li\u1ec7u.<\/p>\n

Gi\u1edbi h\u1ea1n d\u1eef li\u1ec7u \u00f4 l\u00e0 s\u1ed1 ho\u1eb7c nh\u1eefng s\u1ed1 cho tr\u01b0\u1edbc<\/strong><\/p>\n

B\u1ea1n c\u00f3 th\u1ec3 c\u00e0i \u0111\u1eb7t lo\u1ea1i d\u1eef li\u1ec7u s\u1ed1 v\u1edbi nh\u1eefng gi\u1edbi h\u1ea1n c\u1ee5 th\u1ec3 b\u1eb1ng c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

1. Ch\u1ecdn v\u00f9ng b\u1ea1n s\u1ebd c\u00e0i d\u1eef li\u1ec7u s\u1ed1, v\u00e0o Data > Data Validation<\/strong><\/p>\n

<\/p>\n

2. Trong h\u1ed9p tho\u1ea1i Data Validation<\/strong>, \u0111\u1ebfn tab Setting<\/strong>:<\/p>\n

<\/p>\n

(1) Ch\u1ecdn Whole number<\/strong> trong danh s\u00e1ch t\u00f9y ch\u1ecdn c\u1ee7a Allow<\/strong>. Nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

<\/p>\n

(2) Ch\u1ecdn ph\u01b0\u01a1ng th\u1ee9c so s\u00e1nh b\u1ea1n c\u1ea7n trong danh s\u00e1ch t\u00f9y ch\u1ecdn c\u1ee7a Data<\/strong> nh\u01b0 h\u00ecnh tr\u00ean.<\/p>\n

(3) Nh\u1eadp c\u00e1c gi\u00e1 tr\u1ecb\u00a0 c\u1ee5 th\u1ec3 trong h\u1ed9p tho\u1ea1i Maximum<\/strong>\/Minimum<\/strong>\/Length<\/strong> cho c\u00e1c gi\u1edbi h\u1ea1n theo nhu c\u1ea7u c\u1ee7a b\u1ea1n.<\/p>\n

3. Nh\u1ea5n OK.<\/p>\n

Gi\u1edbi h\u1ea1n gi\u00e1 tr\u1ecb \u00f4 t\u1eeb m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n:<\/p>\n

B\u1ea1n c\u00f3 th\u1ec3 c\u00e0i \u0111\u1eb7t gi\u1edbi h\u1ea1n cho gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n b\u1eb1ng c\u00e1c b\u01b0\u1edbc sau:<\/strong><\/p>\n

1. Thi\u1ebft l\u1eadp t\u1ea5t c\u1ea3 c\u00e1c chu\u1ed7i m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 nh\u1eadp v\u00e0o, t\u1ea1m coi l\u00e0 t\u1eeb A2:A10 nh\u01b0 h\u00ecnh:<\/p>\n

<\/p>\n

2. Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n s\u1ebd thi\u1ebft l\u1eadp gi\u1edbi h\u1ea1n, Data > Data Validation<\/strong>.<\/p>\n

<\/p>\n

3. Trong h\u1ed9p tho\u1ea1i , v\u00e0o tab Setting:<\/p>\n

(1) Ch\u1ecdn ki\u1ec3u List<\/strong> t\u1eeb h\u1ed9p Allow<\/strong>;<\/p>\n

(2) Ch\u1ecdn In-cell dropdown<\/strong><\/p>\n

(3) Ch\u1ec9 \u0111\u1ecbnh ngu\u1ed3n \u0111\u00e3 thi\u1ebft l\u1eadp. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 danh s\u00e1ch A2:A10<\/p>\n

4. Nh\u1ea5n OK.<\/p>\n

Sau \u0111\u00f3 ch\u1ecdn m\u1ed9t \u00f4 trong v\u00f9ng c\u00f3 thi\u1ebft l\u1eadp gi\u1edbi h\u1ea1n v\u0103n b\u1ea3n, n\u00f3 s\u1ebd c\u00f3 m\u0169i t\u00ean b\u00ean c\u1ea1nh, nh\u1ea5n v\u00e0o m\u0169i t\u00ean v\u00e0 m\u1ed9t danh s\u00e1ch t\u00f9y ch\u1ecdn xu\u1ea5t hi\u1ec7n v\u1edbi c\u00e1c t\u00ean \u0111\u00e3 \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp ban \u0111\u1ea7u.<\/p>\n

<\/p>\n

B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp Input Message<\/strong> v\u00e0 Error Message<\/strong> cho gi\u1edbi h\u1ea1n d\u1ea1ng s\u1ed1 ho\u1eb7c ch\u1eef.<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6531,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6530","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\/6530","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=6530"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6530\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6531"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6530"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6530"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}