{"id":8075,"date":"2024-12-21T21:16:24","date_gmt":"2024-12-21T21:16:24","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-goi-data-entry-form-trong-excel\/"},"modified":"2024-12-21T21:16:24","modified_gmt":"2024-12-21T21:16:24","slug":"huong-dan-goi-data-entry-form-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-goi-data-entry-form-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn g\u1ecdi Data Entry Form trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1c b\u01b0\u1edbc g\u1ecdi ra m\u1ed9t Form \u0111i\u1ec1n d\u1eef li\u1ec7u (Data Entry Form) c\u01a1 b\u1ea3n khi thao t\u00e1c trong Excel.<\/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-6767302770dc9\" 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\/data-entry-form-trong-excel.html#Data_Entry_Form_trong_Excel\" title=\"Data Entry Form trong Excel\">Data Entry Form trong Excel<\/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\/data-entry-form-trong-excel.html#Them_nut_lenh_Data_Entry_Form_vao_thanh_Ribbon_hoac_Quick_Access\" title=\"Th\u00eam n\u00fat l\u1ec7nh Data Entry Form v\u00e0o thanh Ribbon (ho\u1eb7c Quick Access):\">Th\u00eam n\u00fat l\u1ec7nh Data Entry Form v\u00e0o thanh Ribbon (ho\u1eb7c Quick Access):<\/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\/data-entry-form-trong-excel.html#Cac_thuoc_tinh_trong_Data_Entry_Form\" title=\"C\u00e1c thu\u1ed9c t\u00ednh trong Data Entry Form\">C\u00e1c thu\u1ed9c t\u00ednh trong Data Entry Form<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/data-entry-form-trong-excel.html#Tao_du_lieu_moi_voi_Form\" title=\"T\u1ea1o d\u1eef li\u1ec7u m\u1edbi v\u1edbi Form\">T\u1ea1o d\u1eef li\u1ec7u m\u1edbi v\u1edbi Form<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/data-entry-form-trong-excel.html#Di_chuyen_giua_cac_Record_thong_qua_Form\" title=\"Di chuy\u1ec3n gi\u1eefa c\u00e1c Record th\u00f4ng qua Form\">Di chuy\u1ec3n gi\u1eefa c\u00e1c Record th\u00f4ng qua Form<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Data_Entry_Form_trong_Excel\"><\/span>Data Entry Form trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng data entry form trong Excel b\u1ea1n c\u1ea7n ph\u1ea3i th\u00eam v\u00e0o tr\u01b0\u1edbc \u0111\u00f3 m\u1ed9t ch\u00fat thao t\u00e1c, b\u1edfi m\u1eb7c \u0111\u1ecbnh Excel s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb n\u00fat l\u1ec7nh \u0111\u1ec3 c\u00f3 th\u1ec3 g\u1ecdi form n\u00e0y ra.<\/p>\n<p>Tr\u01b0\u1edbc ti\u00ean, ta s\u1ebd \u0111\u01b0a n\u00f3 v\u00e0o Ribbon:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Them_nut_lenh_Data_Entry_Form_vao_thanh_Ribbon_hoac_Quick_Access\"><\/span>Th\u00eam n\u00fat l\u1ec7nh Data Entry Form v\u00e0o thanh Ribbon (ho\u1eb7c Quick Access):<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 th\u00eam v\u00e0o thanh Ribbon, ta\u1ecb thanh Ribbon click chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn\u00a0<strong>Customize the Ribbon\u00a0<\/strong>ho\u1eb7c v\u00e0o\u00a0<strong>File -&gt; Options -&gt; Customize Ribbon.<\/strong><\/p>\n<p>Trong m\u1ee5c\u00a0<em>Choose command from<\/em> ch\u1ecdn\u00a0<strong>All Commands.\u00a0<\/strong>K\u00e9o xu\u1ed1ng v\u00e0 ch\u1ecdn\u00a0<strong>Form.<\/strong><\/p>\n<p>Ti\u1ebfn h\u00e0nh th\u00eam v\u00e0o b\u1eb1ng c\u00e1ch ch\u1ecdn n\u00fat\u00a0<strong>Add<\/strong>. \u1ea4n OK \u0111\u1ec3 k\u1ebft th\u00fac.<\/p>\n<p>L\u00e0m t\u01b0\u01a1ng t\u1ef1 v\u1edbi thanh Quick Access Toolbar.<\/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-730.gif\" title=\"ex101_92019-nho-730\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-29454\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-entry-form-1.png\" width=\"839\" height=\"685\" title=\"data-entry-form-1\"><\/p>\n<p>\u00a0<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cac_thuoc_tinh_trong_Data_Entry_Form\"><\/span>C\u00e1c thu\u1ed9c t\u00ednh trong Data Entry Form<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>M\u1ed9t form s\u1ebd c\u00f3 giao di\u1ec7n nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-29455\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-entry-form-2.png\" width=\"266\" height=\"322\" title=\"data-entry-form-2\"><\/p>\n<p>C\u00e1c n\u00fat l\u1ec7nh ch\u1ee9c n\u0103ng trong form bao g\u1ed3m:<\/p>\n<p><strong>New:\u00a0<\/strong>T\u1ea1o m\u1edbi d\u1eef li\u1ec7u nh\u1eadp v\u00e0o Form.<\/p>\n<p><strong>Delete<\/strong>: X\u00f3a record hi\u1ec7n t\u1ea1i \u0111ang ghi.<\/p>\n<p><strong>Restore:<\/strong> Ph\u1ee5c h\u1ed3i l\u1ea1i d\u1eef li\u1ec7u tr\u01b0\u1edbc \u0111\u00f3 trong Form.<\/p>\n<p><strong>Find Prev<\/strong>: T\u00ecm d\u1eef li\u1ec7u ph\u00eda tr\u01b0\u1edbc trong danh s\u00e1ch nh\u1eadp tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n<p><strong>Find Next<\/strong>: T\u00ecm d\u1eef li\u1ec7u ti\u1ebfp theo trong danh s\u00e1ch nh\u1eadp tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n<p><strong>Criteria:<\/strong> S\u1eed d\u1ee5ng \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 t\u00ecm record c\u1ee5 th\u1ec3. Nh\u1eadp \u0111i\u1ec1u ki\u1ec7n v\u00e0o v\u00f9ng t\u01b0\u01a1ng \u1ee9ng v\u00e0 t\u00ecm v\u1edbi Find.<\/p>\n<p><strong>Close:<\/strong>\u00a0\u0110\u00f3ng Form.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tao_du_lieu_moi_voi_Form\"><\/span>T\u1ea1o d\u1eef li\u1ec7u m\u1edbi v\u1edbi Form<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 t\u1ea1o d\u1eef li\u1ec7u \u0111\u01a1n gi\u1ea3n b\u1ea1n l\u00e0m nh\u01b0 sau:<\/p>\n<p>1. T\u1ea1o ti\u00eau \u0111\u1ec1 cho b\u1ea3ng. Ch\u1eb3ng h\u1ea1n:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-29458\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-entry-form-3.png\" width=\"726\" height=\"161\" title=\"data-entry-form-3\"><\/p>\n<p>2. Click v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng\u00a0<strong>Form<\/strong>:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-29459\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-entry-form-4.png\" width=\"297\" height=\"104\" title=\"data-entry-form-4\"><\/p>\n<p>3. \u0110i\u1ec1n d\u1eef li\u1ec7u v\u00e0o trong Form:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-29460\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-entry-form-5.png\" width=\"338\" height=\"326\" title=\"data-entry-form-5\"><\/p>\n<p>4. Sau khi \u0111\u00e3 \u0111i\u1ec1n h\u1ebft, ta k\u1ebft th\u00fac b\u1eb1ng ph\u00edm Enter \u0111\u1ec3 \u0111\u01b0a record v\u00e0o trong b\u1ea3ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-29461\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-entry-form-6.png\" width=\"761\" height=\"460\" title=\"data-entry-form-6\"><\/p>\n<p>\u00a0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Di_chuyen_giua_cac_Record_thong_qua_Form\"><\/span>Di chuy\u1ec3n gi\u1eefa c\u00e1c Record th\u00f4ng qua Form<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t trong nh\u1eefng l\u1ee3i \u00edch c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng Data Entry Form \u0111\u00f3 l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng di chuy\u1ec3n hay \u0111i\u1ec1u h\u01b0\u1edbng t\u1edbi c\u00e1c record v\u00e0 ch\u1ec9nh s\u1eeda ch\u00fang m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i tho\u00e1t ra kh\u1ecfi h\u1ed9p tho\u1ea1i. \u0110i\u1ec1u n\u00e0y s\u1ebd \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch n\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t b\u1ed9 d\u1eef li\u1ec7u l\u1edbn.<\/p>\n<p>\u0110\u1ec3 di chuy\u1ec3n gi\u1eefa c\u00e1c record s\u1eed d\u1ee5ng form ta l\u00e0m nh\u01b0 sau:<\/p>\n<p>1. \u0110\u1ec3 di chuy\u1ec3n t\u1edbi d\u1eef li\u1ec7u k\u1ebf ti\u1ebfp, ch\u1ecdn\u00a0<strong>Find Next<\/strong>. \u0110\u1ec3 quay ng\u01b0\u1ee3c d\u1eef li\u1ec7u tr\u00ean, ch\u1ecdn\u00a0<strong>Find Prev<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-29534\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-entry-form-7.png\" width=\"265\" height=\"325\" title=\"data-entry-form-7\"><\/p>\n<p>2. \u0110\u1ec3 ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u, ta ch\u1ec9nh s\u1eeda th\u1eb3ng v\u00e0o d\u1eef li\u1ec7u c\u0169 trong Form sau \u0111\u00f3 \u1ea5n Enter. Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u c\u0169 (n\u1ebfu ch\u01b0a \u1ea5n Enter), click v\u00e0o\u00a0<strong>Restore.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-29535\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-entry-form-8.png\" width=\"266\" height=\"321\" title=\"data-entry-form-8\"><\/p>\n<p>3. \u0110\u1ec3 \u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n cho \u00f4, ta s\u1ebd g\u00f5 tr\u1ef1c ti\u1ebfp \u0111i\u1ec1u ki\u1ec7n v\u00e0o c\u1ed9t t\u01b0\u01a1ng \u1ee9ng v\u00e0 ch\u1ecdn\u00a0<strong>Criteria<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-29536\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-entry-form-9.png\" width=\"264\" height=\"325\" title=\"data-entry-form-9\"><\/p>\n<p>4. N\u1ebfu mu\u1ed1n x\u00f3a record, h\u00e3y ch\u1ecdn d\u1eef li\u1ec7u c\u1ea7n x\u00f3a v\u00e0 \u1ea5n\u00a0<strong>Delete<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-29537\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-entry-form-10.png\" width=\"264\" height=\"322\" title=\"data-entry-form-10\"><\/p>\n<hr>\n<p>B\u1ea1n c\u00f3 th\u1ec3 xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-tao-userform-dep-trong-excel-vba-voi-hieu-ung-button-thay-doi-khi.html\"><strong>H\u01b0\u1edbng d\u1eabn t\u1ea1o Userform \u0111\u1eb9p trong VBA<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/tao-form-nhap-lieu-trong-google-sheet.html\">T\u1ea1o form nh\u1eadp li\u1ec7u trong Google Sheet<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-tao-sheetform-phieu-thu-phieu-chi.html\"><strong>Sheetform phi\u1ebfu thu \u2013 chi<\/strong><\/a><\/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\/2024\/12\/ex101_92019-nho-730.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8076,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8075","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\/8075","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=8075"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8075\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8076"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8075"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8075"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}