{"id":6771,"date":"2024-12-21T16:07:52","date_gmt":"2024-12-21T16:07:52","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/chen-nhieu-checkboxes-trong-excel-mot-cach-nhanh-chong\/"},"modified":"2024-12-21T16:07:52","modified_gmt":"2024-12-21T16:07:52","slug":"chen-nhieu-checkboxes-trong-excel-mot-cach-nhanh-chong","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/chen-nhieu-checkboxes-trong-excel-mot-cach-nhanh-chong\/","title":{"rendered":"Ch\u00e8n nhi\u1ec1u Checkboxes trong Excel m\u1ed9t c\u00e1ch nhanh ch\u00f3ng."},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n nhi\u1ec1u checkbox trong Excel? H\u00e3y theo c\u00e1c c\u00e1ch sau \u0111\u00e2y.<\/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-6766e7d774c65\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/chen-nhieu-checkboxes-trong-excel-mot-cach-nhanh-chong.html#Chen_nhieu_Checkbox_voi_Fill_Handle_keo_tha_bang_tay\" title=\"Ch\u00e8n nhi\u1ec1u Checkbox v\u1edbi Fill Handle (k\u00e9o, th\u1ea3 b\u1eb1ng tay)\">Ch\u00e8n nhi\u1ec1u Checkbox v\u1edbi Fill Handle (k\u00e9o, th\u1ea3 b\u1eb1ng tay)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/chen-nhieu-checkboxes-trong-excel-mot-cach-nhanh-chong.html#Chen_nhieu_checkbox_voi_ma_VBA\" title=\"Ch\u00e8n nhi\u1ec1u checkbox v\u1edbi m\u00e3 VBA\">Ch\u00e8n nhi\u1ec1u checkbox v\u1edbi m\u00e3 VBA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chen_nhieu_Checkbox_voi_Fill_Handle_keo_tha_bang_tay\"><\/span>Ch\u00e8n nhi\u1ec1u Checkbox v\u1edbi Fill Handle (k\u00e9o, th\u1ea3 b\u1eb1ng tay)<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">Trong Excel, Fill Handle l\u00e0 m\u1ed9t ch\u1ee9c n\u0103ng r\u1ea5t m\u1ea1nh \u0111\u1ec3 l\u00e0m nhi\u1ec1u th\u1ee9. N\u00f3 c\u0169ng c\u00f3 th\u1ec3 d\u00f9ng \u0111\u1ec3 \u0111i\u1ec1n checkbox. \u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n ch\u00e8n m\u1ed9t checkbox, c\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn <strong>Developer <\/strong>tr\u00ean thanh c\u00f4ng c\u1ee5, sau \u0111\u00f3 nh\u1ea5n <strong>Insert, <\/strong>v\u00e0 ch\u1ecdn h\u00ecnh checkbox d\u01b0\u1edbi Form Control. H\u00e3y nh\u00ecn h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-multiple-checkboxes1-1.png\" alt=\"doc-insert-multiple-checkboxes1\" title=\"doc-insert-multiple-checkboxes1-1\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Ch\u1ecdn h\u00ecnh checkbox, v\u00e0 b\u1ea1n s\u1ebd th\u1ea5y d\u1ea5u con tr\u1ecf, ch\u1ecdn n\u01a1i b\u1ea1n mu\u1ed1n th\u00eam checkbox.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-multiple-checkboxes2-2.png\" alt=\"doc-insert-multiple-checkboxes2\" title=\"doc-insert-multiple-checkboxes2-2\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Ch\u1ecdn checkbox v\u00e0 di chuy\u1ec3n ch\u00fang v\u00e0o m\u1ed9t \u00f4, sau \u0111\u00f3 x\u00f3a t\u00ean c\u1ee7a checkbox \u0111i.<\/li>\n<li>Ch\u1ecdn \u00f4 c\u00f3 checkbox, v\u00e0 d\u00f9ng fill handle \u0111\u1ec3 sao ch\u00e9p ch\u00fang qua d\u00e3y c\u00e1c \u00f4 kh\u00e1c b\u1ea1n mu\u1ed1n. H\u00e3y nh\u00ecn h\u00ecnh sau:<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-multiple-checkboxes3-3.png\" alt=\"doc-insert-multiple-checkboxes3\" title=\"doc-insert-multiple-checkboxes3-3\"><\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chen_nhieu_checkbox_voi_ma_VBA\"><\/span>Ch\u00e8n nhi\u1ec1u checkbox v\u1edbi m\u00e3 VBA<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n ngh\u0129 ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ea7u ti\u00ean h\u01a1i phi\u1ec1n, <a href=\"http:\/\/blog.ezworkapp.com\/cach-chen-va-chay-ma-vba-trong-excel-2010-2016-huong-dan-cho-nguoi-moi-bat-dau.html\" target=\"_blank\"><strong>m\u00e3 VBA<\/strong><\/a> sau c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n nhanh ch\u00f3ng ch\u00e8n nhi\u1ec1u checkbox m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn <strong>Developer&gt;Visual Basic<\/strong>, m\u1ed9t c\u1eeda s\u1ed5 <strong>Microsoft Visual Basic for applications<\/strong> hi\u1ec7n ra, nh\u1ea5p <strong>Insert&gt;Module<\/strong>, v\u00e0 ch\u00e8n \u0111o\u1ea1n code sau v\u00e0o <strong>Module:<\/strong><\/li>\n<\/ol>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/32f61aa994d7fef07e2f72cf484993da\">Gist<\/a>.<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-267.gif\" title=\"vba101_92019-nho-267\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-607.gif\" title=\"ex101_92019-nho-607\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"line number1 index0 alt2\" style=\"text-align: justify\"><\/div>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Sau \u0111\u00f3 nh\u1ea5p n\u00fat \u0111\u1ec3 ch\u1ea1y \u0111o\u1ea1n m\u00e3. M\u1ed9t h\u1ed9p tho\u1ea1i c\u1ea3nh b\u00e1o xu\u1ea5t hi\u1ec7n \u0111\u1ec3 nh\u1eafc b\u1ea1n ch\u1ecdn v\u00f9ng m\u00e0 b\u1ea1n mu\u1ed1n ch\u00e8n c\u00e1c checkbox. X\u00e8m h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-multiple-checkboxes4-4.png\" alt=\"doc-insert-multiple-checkboxes4\" title=\"doc-insert-multiple-checkboxes4-4\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Ch\u1ecdn OK, c\u00e1c checkbox s\u1ebd \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o th\u1eb3ng h\u00e0ng v\u00e0 \u0111\u1eb9p \u0111\u1ebd. H\u00e3y nh\u00ecn h\u00ecnh sau:<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-insert-multiple-checkboxes5-5.png\" alt=\"doc-insert-multiple-checkboxes5\" title=\"doc-insert-multiple-checkboxes5-5\"><\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-267.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6772,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6771","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\/6771","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=6771"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6771\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6772"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6771"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6771"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}