{"id":9594,"date":"2025-01-02T10:55:09","date_gmt":"2025-01-02T10:55:09","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-gioi-han-so-luong-ki-tu-trong-1-o-excel\/"},"modified":"2025-01-02T10:55:09","modified_gmt":"2025-01-02T10:55:09","slug":"huong-dan-cach-gioi-han-so-luong-ki-tu-trong-1-o-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-gioi-han-so-luong-ki-tu-trong-1-o-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 trong 1 \u00f4 Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong m\u1ed9t s\u1ed1 s\u1ed5 t\u00ednh, nh\u1ea5t l\u00e0 s\u1ed5 t\u00ednh cho nhi\u1ec1u ng\u01b0\u1eddi truy c\u1eadp ch\u1ec9nh s\u1eeda, \u0111\u00f4i l\u00fac b\u1ea1n s\u1ebd mu\u1ed1n gi\u1edbi h\u1ea1n c\u00e1c quy\u1ec1n tr\u00ean s\u1ed5 t\u00ednh \u0111\u00f3. M\u1ed9t trong \u0111\u00f3 l\u00e0 vi\u1ec7c gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 trong 1 \u00f4. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3 v\u1edbi ch\u1ee9c n\u0103ng\u00a0<strong>Data Validation.<\/strong><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6776708d18f9b\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-gioi-han-so-luong-ki-tu-trong-1-o-excel.html#Gioi_han_so_luong_ki_tu_trong_1_o_Excel_voi_chuc_nang_Data_Validation\" title=\"Gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 trong 1 \u00f4 Excel v\u1edbi ch\u1ee9c n\u0103ng Data Validation\">Gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 trong 1 \u00f4 Excel v\u1edbi ch\u1ee9c n\u0103ng Data Validation<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-gioi-han-so-luong-ki-tu-trong-1-o-excel.html#Su_dung_Data_Validation_gioi_han_so_luong_ki_tu_trong_1_o\" title=\"S\u1eed d\u1ee5ng Data Validation gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 trong 1 \u00f4\">S\u1eed d\u1ee5ng Data Validation gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 trong 1 \u00f4<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-gioi-han-so-luong-ki-tu-trong-1-o-excel.html#Dat_thong_bao_cho_nguoi_su_dung\" title=\"\u0110\u1eb7t th\u00f4ng b\u00e1o cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng\">\u0110\u1eb7t th\u00f4ng b\u00e1o cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-gioi-han-so-luong-ki-tu-trong-1-o-excel.html#Bao_loi_khi_vi_pham_gioi_han\" title=\"B\u00e1o l\u1ed7i khi vi ph\u1ea1m gi\u1edbi h\u1ea1n\">B\u00e1o l\u1ed7i khi vi ph\u1ea1m gi\u1edbi h\u1ea1n<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Gioi_han_so_luong_ki_tu_trong_1_o_Excel_voi_chuc_nang_Data_Validation\"><\/span>Gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 trong 1 \u00f4 Excel v\u1edbi ch\u1ee9c n\u0103ng Data Validation<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_Data_Validation_gioi_han_so_luong_ki_tu_trong_1_o\"><\/span>S\u1eed d\u1ee5ng Data Validation gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 trong 1 \u00f4<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Ta th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p><em>1.\u00a0<\/em>Ch\u1ecdn v\u00f9ng mu\u1ed1n gi\u1edbi h\u1ea1n.<\/p>\n<p><em>2.\u00a0<\/em>Trong th\u1ebb\u00a0<strong>Data<\/strong>, nh\u00f3m\u00a0<strong>Data Tools<\/strong>, ch\u1ecdn\u00a0<strong>Data Validation.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23918\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/gioi-han-chu-trong-o-1.png\" width=\"540\" height=\"120\" title=\"gioi-han-chu-trong-o-1\"><\/p>\n<p>\u00a0<\/p>\n<p><em>3.\u00a0<\/em>Trong h\u1ed9p tho\u1ea1i Data Validation, ch\u1ecdn\u00a0<strong>Text Length\u00a0<\/strong>t\u1eeb m\u1ee5c Allow.<\/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\/2025\/01\/ex101_92019-nho-70.gif\" title=\"ex101_92019-nho-70\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23919\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/gioi-han-chu-trong-o-2.png\" width=\"402\" height=\"316\" title=\"gioi-han-chu-trong-o-2\"><\/p>\n<p><em>4.<\/em> T\u1ea1i ph\u1ea7n Data:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23920\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/gioi-han-chu-trong-o-3.png\" width=\"400\" height=\"319\" title=\"gioi-han-chu-trong-o-3\"><\/p>\n<ul>\n<li>N\u1ebfu mu\u1ed1n gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng ch\u1eef b\u1eb1ng m\u1ed9t s\u1ed1\u00a0<strong>x<\/strong> c\u1ee5 th\u1ec3, ch\u1ecdn\u00a0<strong>equal to<\/strong><\/li>\n<li>V\u1edbi s\u1ed1 l\u01b0\u1ee3ng ch\u1eef kh\u00f4ng l\u1edbn h\u01a1n s\u1ed1\u00a0<strong>x\u00a0<\/strong>c\u1ee5 th\u1ec3, ch\u1ecdn\u00a0<strong>less than<\/strong><\/li>\n<li>\u0110\u1ec3 s\u1ed1 l\u01b0\u1ee3ng ch\u1eef kh\u00f4ng nh\u1ecf h\u01a1n s\u1ed1\u00a0<strong>x<\/strong> c\u1ee5 th\u1ec3, ch\u1ecdn\u00a0<strong>greater than<\/strong><\/li>\n<\/ul>\n<p><em>5.\u00a0<\/em>\u0110i\u1ec1n s\u1ed1\u00a0<strong>x<\/strong> v\u00e0o v\u00f9ng\u00a0<strong>Length:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23922\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/gioi-han-chu-trong-o-4.png\" width=\"397\" height=\"318\" title=\"gioi-han-chu-trong-o-4\"><\/p>\n<p>Sau \u0111\u00f3, v\u00f9ng \u0111\u01b0\u1ee3c gi\u1edbi h\u1ea1n s\u1ebd ch\u1ec9 cho ph\u00e9p ng\u01b0\u1eddi s\u1eed d\u1ee5ng nh\u1eadp theo quy t\u1eafc \u0111\u00e3 \u0111\u1eb7t ra trong Data Validation.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Dat_thong_bao_cho_nguoi_su_dung\"><\/span>\u0110\u1eb7t th\u00f4ng b\u00e1o cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u00f4i khi ng\u01b0\u1eddi s\u1eed d\u1ee5ng kh\u00f4ng bi\u1ebft v\u1ec1 nh\u1eefng gi\u1edbi h\u1ea1n \u0111\u00f3 v\u00e0 v\u00f4 t\u00ecnh nh\u1eadp sai, ta c\u1ea7n ph\u1ea3i \u201c\u0111\u1ec3 l\u1ea1i l\u1eddi nh\u1eafn\u201d cho h\u1ecd qua ch\u1ee9c n\u0103ng\u00a0<em>Input Message<\/em>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23923\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/gioi-han-chu-trong-o-5.png\" width=\"400\" height=\"318\" title=\"gioi-han-chu-trong-o-5\"><\/p>\n<ol>\n<li>Ch\u1ecdn\u00a0th\u1ebb\u00a0<strong>Input Message<\/strong>.<\/li>\n<li>Ch\u1ecdn \u00f4 \u201cShow input message when cell is selected\u201d \u0111\u1ec3 hi\u1ec3n th\u1ecb tin nh\u1eafn m\u1ed7i khi click v\u00e0o \u00f4.<\/li>\n<li>Trong ph\u1ea7n Title, nh\u1eadp ti\u00eau \u0111\u1ec1 tin nh\u1eafn.<\/li>\n<li>T\u1ea1i m\u1ee5c Input Message, nh\u1eadp n\u1ed9i dung tin nh\u1eafn.<\/li>\n<\/ol>\n<h4><span class=\"ez-toc-section\" id=\"Bao_loi_khi_vi_pham_gioi_han\"><\/span>B\u00e1o l\u1ed7i khi vi ph\u1ea1m gi\u1edbi h\u1ea1n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 n\u00f3i cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng bi\u1ebft gi\u1edbi h\u1ea1n, \u0111\u00f3 l\u00e0 \u0111\u1eb7t b\u00e1o l\u1ed7i. Khi ng\u01b0\u1eddi d\u00f9ng vi ph\u1ea1m, m\u1ed9t th\u00f4ng b\u00e1o s\u1ebd hi\u1ec7n l\u00ean v\u1edbi m\u1ed9t trong c\u00e1c m\u1ee9c \u0111\u1ed9:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23925\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/gioi-han-chu-trong-o-6.png\" width=\"401\" height=\"315\" title=\"gioi-han-chu-trong-o-6\"><\/p>\n<p>\u2013<strong>Stop:\u00a0<\/strong>Kh\u00f4ng cho th\u1ef1c hi\u1ec7n h\u00e0nh \u0111\u1ed9ng, b\u1eaft nh\u1eadp l\u1ea1i.<\/p>\n<p>\u2013<strong>Warning:<\/strong> C\u1ea3nh b\u00e1o, h\u1ecfi ng\u01b0\u1eddi d\u00f9ng c\u00f3 ch\u1eafc ch\u1eafn mu\u1ed1n \u201cph\u00e1 lu\u1eadt\u201d kh\u00f4ng.<\/p>\n<p>\u2013<strong>Information:\u00a0<\/strong>Th\u00f4ng tin cho ng\u01b0\u1eddi d\u00f9ng bi\u1ebft h\u1ecd \u0111\u00e3 nh\u1eadp sai, nh\u01b0ng kh\u00f4ng c\u1ea5m.<\/p>\n<ul>\n<li>M\u1ee5c Title l\u00e0 ti\u00eau \u0111\u1ec1 c\u1ee7a b\u00e1o l\u1ed7i.<\/li>\n<li>Nh\u1eadp n\u1ed9i dung v\u00e0o Error Message.<\/li>\n<\/ul>\n<figure id=\"attachment_23926\" aria-describedby=\"caption-attachment-23926\" style=\"width: 326px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-23926\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/gioi-han-chu-trong-o-7.png\" width=\"326\" height=\"115\" title=\"gioi-han-chu-trong-o-7\"><figcaption id=\"caption-attachment-23926\" class=\"wp-caption-text\">Stop<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<figure id=\"attachment_23927\" aria-describedby=\"caption-attachment-23927\" style=\"width: 404px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-23927\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/gioi-han-chu-trong-o-8.png\" width=\"404\" height=\"122\" title=\"gioi-han-chu-trong-o-8\"><figcaption id=\"caption-attachment-23927\" class=\"wp-caption-text\">Warning<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<figure id=\"attachment_23928\" aria-describedby=\"caption-attachment-23928\" style=\"width: 321px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-23928\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/gioi-han-chu-trong-o-9.png\" width=\"321\" height=\"115\" title=\"gioi-han-chu-trong-o-9\"><figcaption id=\"caption-attachment-23928\" class=\"wp-caption-text\">Information<\/figcaption><\/figure>\n<p>R\u1ea5t \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t.<\/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\/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-70.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9595,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9594","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\/9594","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=9594"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9594\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9595"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9594"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9594"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}