{"id":4020,"date":"2024-12-04T08:35:50","date_gmt":"2024-12-04T08:35:50","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/cach-them-copy-va-xoa-nhieu-checkbox-trong-excel\/"},"modified":"2024-12-04T08:35:50","modified_gmt":"2024-12-04T08:35:50","slug":"cach-them-copy-va-xoa-nhieu-checkbox-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/cach-them-copy-va-xoa-nhieu-checkbox-trong-excel\/","title":{"rendered":"C\u00e1ch th\u00eam, copy v\u00e0 x\u00f3a nhi\u1ec1u checkbox trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i vi\u1ebft n\u00e0y, Blog <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch l\u00e0m nhanh ch\u00f3ng \u0111\u1ec3 th\u00eam nhi\u1ec1u checkbox trong Excel, thay \u0111\u1ed5i t\u00ean c\u1ee7a Excel v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a n\u00f3, c\u0169ng nh\u01b0 x\u00f3a m\u1ed9t hay nhi\u1ec1u checkbox tr\u00ean m\u1ed9t trang t\u00ednh.<\/em><\/p>\n<p style=\"text-align: justify\">\u1ede c\u00e1c b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 t\u00ecm hi\u1ec3u checkbox trong Excel c\u0169ng nh\u01b0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5 v\u1ec1 c\u00f4ng d\u1ee5ng c\u1ee7a checkbox trong Excel \u0111\u1ec3 c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t checklist khoa h\u1ecdc v\u00e0 \u0111\u1eb9p m\u1eaft, r\u1ea5t h\u1eefu \u00edch \u0111\u1ec3 t\u1ea1o ra m\u1ed9t danh s\u00e1ch c\u00e1c \u0111\u1ea7u vi\u1ec7c c\u1ea7n l\u00e0m, ho\u1eb7c t\u1ea1o ra nh\u1eefng b\u1ea3n b\u00e1o c\u00e1o hay bi\u1ec3u \u0111\u1ed3 d\u1ef1a tr\u00ean nh\u1eefng checklist \u0111\u00f3.<\/p>\n<p style=\"text-align: justify\">V\u1edbi b\u00e0i vi\u1ebft n\u00e0y, ch\u00ednh ta s\u1ebd t\u1eadp trung v\u00e0o nh\u1eefng l\u00fd thuy\u1ebft li\u00ean quan \u0111\u1ebfn checkbox v\u1edbi m\u1ee5c \u0111\u00edch gi\u00fap b\u1ea1n t\u1ea1o ra m\u1ed9t lo\u1ea1t c\u00e1c checkbox c\u0169ng nh\u01b0 qu\u1ea3n l\u00fd ch\u00fang trong Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/p>\n<p>Xem th\u00eam: <strong>C\u00e1ch <a href=\"http:\/\/blog.ezworkapp.com\/chen-hop-kiem-checkbox-vao-excel.html\">t\u1ea1o \u00f4 tick trong Excel<\/a> \/ t\u1ea1o checkbox trong Excel<\/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-67501465243ae\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-copy-va-xoa-nhieu-checkbox-trong-excel.html#Quan_ly_checkbox_bang_Form_Controls_va_ActiveX_Controls\" title=\"Qu\u1ea3n l\u00fd checkbox b\u1eb1ng Form Controls v\u00e0 ActiveX Controls:\">Qu\u1ea3n l\u00fd checkbox b\u1eb1ng Form Controls v\u00e0 ActiveX Controls:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-copy-va-xoa-nhieu-checkbox-trong-excel.html#Cach_them_checkbox_trong_Excel\" title=\"C\u00e1ch th\u00eam checkbox trong Excel:\">C\u00e1ch th\u00eam checkbox trong Excel:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-copy-va-xoa-nhieu-checkbox-trong-excel.html#Cach_them_nhieu_checkbox_vao_Excel\" title=\"C\u00e1ch th\u00eam nhi\u1ec1u checkbox v\u00e0o Excel\">C\u00e1ch th\u00eam nhi\u1ec1u checkbox v\u00e0o Excel<\/a><\/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\/cach-copy-va-xoa-nhieu-checkbox-trong-excel.html#Cac_thay_doi_ten_checkbox_va_chu_thich\" title=\"C\u00e1c thay \u0111\u1ed5i t\u00ean checkbox v\u00e0 ch\u00fa th\u00edch\">C\u00e1c thay \u0111\u1ed5i t\u00ean checkbox v\u00e0 ch\u00fa th\u00edch<\/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\/cach-copy-va-xoa-nhieu-checkbox-trong-excel.html#Cach_tick_dau_chon_checkbox_trong_Excel\" title=\"C\u00e1ch tick d\u1ea5u ch\u1ecdn checkbox trong Excel\">C\u00e1ch tick d\u1ea5u ch\u1ecdn checkbox trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-copy-va-xoa-nhieu-checkbox-trong-excel.html#Cach_xoa_checkbox_tren_Excel\" title=\"C\u00e1ch x\u00f3a checkbox tr\u00ean Excel:\">C\u00e1ch x\u00f3a checkbox tr\u00ean Excel:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-copy-va-xoa-nhieu-checkbox-trong-excel.html#Cach_dinh_dang_cac_checkbox_trong_Excel\" title=\"C\u00e1ch \u0111\u1ecbnh d\u1ea1ng c\u00e1c checkbox trong Excel\">C\u00e1ch \u0111\u1ecbnh d\u1ea1ng c\u00e1c checkbox trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Quan_ly_checkbox_bang_Form_Controls_va_ActiveX_Controls\"><\/span>Qu\u1ea3n l\u00fd checkbox b\u1eb1ng Form Controls v\u00e0 ActiveX Controls:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong Excel, c\u00f3 2 c\u00e1ch \u0111\u1ec3 b\u1ea1n qu\u1ea3n l\u00fd c\u00e1c checkbox l\u00e0 <strong>Form Controls<\/strong> v\u00e0 <strong>ActiveX Controls<\/strong>.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6508 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/checkbox-activex-control.png\" width=\"235\" height=\"241\" title=\"checkbox-activex-control\"><\/p>\n<p style=\"text-align: justify\">Form Controls \u0111\u01a1n gi\u1ea3n h\u01a1n ActiveX Controls v\u00e0 c\u0169ng l\u00e0 c\u00f4ng c\u1ee5 qu\u1ea3n l\u00fd b\u1ea1n s\u1ebd d\u00f9ng nhi\u1ec1u nh\u1ea5t. N\u1ebfu b\u1ea1n quy\u1ebft \u0111\u1ecbnh s\u1eed d\u1ee5ng ActiveX Controls, b\u1ea1n n\u00ean l\u01b0u \u00fd m\u1ed9t s\u1ed1 nh\u1eefng \u0111i\u1ec3m kh\u00e1c bi\u1ec7t sau:<\/p>\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-135.gif\" title=\"vba101_92019-nho-135\"><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-320.gif\" title=\"ex101_92019-nho-320\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li style=\"text-align: justify\">ActiveX Controls c\u00f3 nhi\u1ec1u l\u1ef1a ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng cho checkbox h\u01a1n v\u00e0 ph\u00f9 h\u1ee3p khi b\u1ea1n mu\u1ed1n checklist c\u1ee7a m\u00ecnh tr\u00f4ng ph\u1ee9c t\u1ea1p v\u00e0 linh ho\u1ea1t.<\/li>\n<li style=\"text-align: justify\">Trong khi Form Controls \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t s\u1eb5n trong Excel, ActiveX Controls \u0111\u00f4i khi khi\u1ebfn m\u00e1y b\u1ecb ch\u1eadm.<\/li>\n<li style=\"text-align: justify\">Nhi\u1ec1u m\u00e1y t\u00ednh \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t kh\u00f4ng \u2018tin t\u01b0\u1edfng\u2019 ActiveX, ch\u00ednh v\u00ec v\u1eady ActiveX Controls c\u00f3 th\u1ec3 s\u1ebd b\u1ecb t\u1eaft \u0111i cho \u0111\u1ebfn khi b\u1ea1n k\u00edch ho\u1ea1t ch\u00fang trong Trust Center tr\u00ean m\u00e1y t\u00ednh.<\/li>\n<li style=\"text-align: justify\">Kh\u00f4ng gi\u1ed1ng nh\u01b0 Form Controls, ActiveX Controls c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c truy c\u1eadp th\u00f4ng qua VBA.<\/li>\n<li style=\"text-align: justify\">ActiveX ch\u1ec9 c\u00f3 trong Windows, Mac OS s\u1ebd kh\u00f4ng h\u1ed7 tr\u1ee3 c\u00f4ng c\u1ee5 n\u00e0y.<\/li>\n<\/ul>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">H\u1ecdc Excel k\u1ebf to\u00e1n \u01a1\u0309 \u0111\u00e2u<\/a>?<\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_them_checkbox_trong_Excel\"><\/span>C\u00e1ch th\u00eam checkbox trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 th\u00eam checkbox trong Excel, b\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau \u0111\u00e2y:<br \/>\n1. Tr\u00ean tab <em>Developer<\/em>, ph\u1ea7n <em>Controls<\/em>, b\u1ea1n h\u00e3y click v\u00e0o <em>Insert<\/em> v\u00e0 click v\u00e0o <strong>k\u00fd hi\u1ec7u Checkbox<\/strong> trong <em>Form Controls<\/em> ho\u1eb7c <em>ActiveX Controls<\/em>.<br \/>\n2. Click v\u00e0o \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n ch\u00e8n checkbox, checkbox s\u1ebd ngay l\u1eadp t\u1ee9c xu\u1ea5t hi\u1ec7n g\u1ea7n \u00f4 n\u00e0y.<br \/>\n3. \u0110\u1ec3 thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u1ee7a checkbox cho ph\u00f9 h\u1ee3p, b\u1ea1n h\u00e3y di chuy\u1ec3n con tr\u1ecf chu\u1ed9t v\u00e0o khung checkbox cho \u0111\u1ebfn khi con tr\u1ecf bi\u1ebfn th\u00e0nh m\u0169i t\u00ean b\u1ed1n chi\u1ec1u, sau \u0111\u00f3 k\u00e9o checkbox \u0111\u1ebfn v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n.<br \/>\n4. Cu\u1ed1i c\u00f9ng, b\u1ea1n h\u00e3y x\u00f3a ho\u1eb7c thay \u0111\u1ed5i d\u00f2ng ch\u1eef ngay c\u1ea1nh checkbox nh\u00e9.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6505 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-checkbox-excel-300x191-1.png\" width=\"300\" height=\"191\" title=\"add-checkbox-excel-300x191-1\"><\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd.<\/strong> N\u1ebfu b\u1ea1n kh\u00f4ng nh\u00ecn th\u1ea5y tab <em>Developer<\/em>, b\u1ea1n h\u00e3y click chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t c\u1ee9 \u0111\u00e2u tr\u00ean thanh c\u00f4ng c\u1ee5 v\u00e0 ch\u1ecdn <strong>Customize the Ribbon\u2026<\/strong> C\u1eeda s\u1ed5 <em>Excel Options<\/em> s\u1ebd xu\u1ea5t hi\u1ec7n, b\u1ea1n ch\u1ec9 c\u1ea7n tick v\u00e0o \u00f4 <em>Developer<\/em> \u1edf b\u00ean c\u1ed9t b\u00ean tay ph\u1ea3i.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Chia se\u0309\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">t\u00e0i li\u1ec7u Excel c\u01a1 b\u1ea3n<\/a> ho\u0301t nh\u00e2\u0301t<\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_them_nhieu_checkbox_vao_Excel\"><\/span>C\u00e1ch th\u00eam nhi\u1ec1u checkbox v\u00e0o Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 th\u00eam nhi\u1ec1u checkbox v\u00e0o Excel, tr\u01b0\u1edbc h\u1ebft b\u1ea1n h\u00e3y ch\u00e8n m\u1ed9t \u00f4 v\u00e0o Excel theo h\u01b0\u1edbng d\u1eabn b\u00ean tr\u00ean, sau \u0111\u00f3 copy checkbox n\u00e0y b\u1eb1ng c\u00e1c b\u01b0\u1edbc sau \u0111\u00e2y:<\/p>\n<ul>\n<li style=\"text-align: justify\">C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 copy m\u1ed9t checkbox l\u00e0 ch\u1ecdn, sau \u0111\u00f3 nh\u1ea5n <strong>Ctrl + D<\/strong> \u0111\u1ec3 copy v\u00e0 paste. Ta s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/li>\n<\/ul>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6512 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-checkbox-excel-300x84-1.png\" width=\"300\" height=\"84\" title=\"copy-checkbox-excel-300x84-1\"><\/p>\n<ul>\n<li style=\"text-align: justify\">\u0110\u1ec3 copy checkbox \u0111\u1ebfn m\u1ed9t v\u1ecb tr\u00ed c\u1ee5 th\u1ec3, ch\u1ecdn checkbox \u0111\u00f3 v\u00e0 nh\u1ea5n <strong>Ctrl + C<\/strong> \u0111\u1ec3 copy, sau \u0111\u00f3 click chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 b\u1ea1n \u0111\u1ecbnh paste, ch\u1ecdn Paste tr\u00ean c\u1eeda s\u1ed5 hi\u1ec7n ra.<\/li>\n<\/ul>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6513 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-checkbox-location-300x93-1.png\" width=\"300\" height=\"93\" title=\"copy-checkbox-location-300x93-1\"><\/p>\n<ul>\n<li style=\"text-align: justify\">\u0110\u1ec3 copy checkbox v\u00e0o c\u00e1c \u00f4 li\u1ec1n k\u1ec1, b\u1ea1n h\u00e3y ch\u1ecdn \u00f4 ch\u1ee9a checkbox, sau \u0111\u00f3 k\u00e9o fill handle (h\u00ecnh ch\u1eef nh\u1eadt nh\u1ecf \u1edf g\u00f3c b\u00ean ph\u1ea3i d\u01b0\u1edbi c\u00f9ng c\u1ee7a \u00f4) v\u00e0 k\u00e9o xu\u1ed1ng b\u00ean d\u01b0\u1edbi ho\u1eb7c b\u00ean ph\u1ea3i c\u1ee7a \u00f4.<\/li>\n<\/ul>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6511 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-checkbox-cell.png\" width=\"151\" height=\"121\" title=\"copy-checkbox-cell\"><\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd: <\/strong><\/p>\n<ul>\n<li style=\"text-align: justify\">T\u00ean c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c checkbox \u0111\u01b0\u1ee3c copy s\u1ebd gi\u1ed1ng v\u1edbi checkbox g\u1ed1c cho \u0111\u1ebfn khi b\u1ea1n thay \u0111\u1ed5i n\u00f3.<\/li>\n<li style=\"text-align: justify\">N\u1ebfu checkbox g\u1ed1c \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi m\u1ed9t \u00f4 trong trang t\u00ednh th\u00ec t\u1ea5t c\u1ea3 c\u00e1c checkbox c\u0169ng s\u1ebd \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi \u00f4 \u0111\u00f3. B\u1ea1n s\u1ebd ph\u1ea3i thay \u0111\u1ed5i li\u00ean k\u1ebft \u00f4 \u0111\u1ed1i v\u1edbi t\u1eebng \u00f4 ri\u00eang l\u1ebb.<\/li>\n<\/ul>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cac_thay_doi_ten_checkbox_va_chu_thich\"><\/span>C\u00e1c thay \u0111\u1ed5i t\u00ean checkbox v\u00e0 ch\u00fa th\u00edch<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Khi s\u1eed d\u1ee5ng checkbox trong Excel, b\u1ea1n c\u1ea7n ph\u00e2n bi\u1ec7t t\u00ean c\u1ee7a checkbox (name) v\u1edbi ch\u00fa th\u00edch (caption).<\/p>\n<p style=\"text-align: justify\">Ch\u00fa th\u00edch \u00f4 ch\u00ednh l\u00e0 d\u00f2ng ch\u1eef b\u00ean c\u1ea1nh checkbox khi ta m\u1edbi th\u00eam checkbox v\u00e0o trang t\u00ednh, nh\u01b0 trong h\u00ecnh ch\u00ednh l\u00e0 <em>Check Box 1<\/em>. \u0110\u1ec3 thay \u0111\u1ed5i ch\u00fa th\u00edch, b\u1ea1n h\u00e3y click chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 checkbox, ch\u1ecdn <em>Edit Text<\/em> v\u00e0 g\u00f5 ch\u00fa th\u00edch m\u00e0 b\u1ea1n mu\u1ed1n.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6506 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-checkbox-caption-name.png\" width=\"241\" height=\"146\" title=\"change-checkbox-caption-name\"><\/p>\n<p style=\"text-align: justify\">T\u00ean c\u1ee7a checkbox s\u1ebd l\u00e0 d\u00f2ng ch\u1eef b\u1ea1n nh\u00ecn th\u1ea5y trong h\u1ed9p <strong>Name<\/strong> khi b\u1ea1n click ch\u1ecdn checkbox. \u0110\u1ec3 thay \u0111\u1ed5i t\u00ean, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn checkbox v\u00e0 g\u00f5 t\u00ean b\u1ea1n mu\u1ed1n trong h\u1ed9p <strong>Name<\/strong> nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6507 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-checkbox-name.png\" width=\"135\" height=\"105\" title=\"change-checkbox-name\"><\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd.<\/strong> Thay \u0111\u1ed5i ch\u00fa th\u00edch s\u1ebd kh\u00f4ng thay \u0111\u1ed5i t\u00ean c\u1ee7a checkbox.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tick_dau_chon_checkbox_trong_Excel\"><\/span>C\u00e1ch tick d\u1ea5u ch\u1ecdn checkbox trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t checkbox ri\u00eang l\u1ebb trong Excel v\u1edbi 2 c\u00e1ch:<\/p>\n<ul>\n<li style=\"text-align: justify\">Click chu\u1ed9t ph\u1ea3i v\u00e0o checkbox, sau \u0111\u00f3 click v\u00e0o b\u1ea5t c\u1ee9 v\u1ecb tr\u00ed n\u00e0o trong checkbox.<\/li>\n<li style=\"text-align: justify\">\u0110\u1ed3ng th\u1eddi click v\u00e0o \u00f4 checkbox v\u00e0 gi\u1eef ph\u00edm<strong> Ctrl<\/strong>.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">\u0110\u1ec3 tick d\u1ea5u ch\u1ecdn nhi\u1ec1u checkbox trong Excel, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ul>\n<li style=\"text-align: justify\">Nh\u1ea5n v\u00e0 gi\u1eef ph\u00edm <strong>Ctrl<\/strong>, sau \u0111\u00f3 click ch\u1ecdn \u00f4 checkbox m\u00e0 b\u1ea1n mu\u1ed1n tick d\u1ea5u.<\/li>\n<li style=\"text-align: justify\">T\u1ea1i tab<em> Home<\/em>, trong ph\u1ea7n <em>Editing<\/em>, ch\u1ecdn <em>Find &amp; Select &gt; Selection Pane<\/em>. B\u1ea3ng Selection s\u1ebd xu\u1ea5t hi\u1ec7n \u1edf ph\u00eda b\u00ean ph\u1ea3i c\u1ee7a trang t\u00ednh v\u00e0 li\u1ec7t k\u00ea ra t\u1ea5t c\u1ea3 c\u00e1c checkbox, bi\u1ec3u \u0111\u1ed3, h\u00ecnh kh\u1ed1i. \u0110\u1ec3 ch\u1ecdn nhi\u1ec1u checkbox, b\u1ea1n ch\u1ec9 c\u1ea7n click v\u00e0o t\u00ean c\u1ee7a checkbox hi\u1ec7n trong Selection, c\u00f9ng l\u00fac \u0111\u00f3 gi\u1eef ph\u00edm <strong>Ctrl<\/strong>.<\/li>\n<\/ul>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6517 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-multiple-checkboes-excel-300x132-1.png\" width=\"300\" height=\"132\" title=\"select-multiple-checkboes-excel-300x132-1\"><\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd.<\/strong> T\u00ean c\u1ee7a checkbox s\u1ebd hi\u1ec3n th\u1ecb tr\u00ean ph\u1ea7n Selection thay v\u00ec ch\u00fa th\u00edch c\u1ee7a checkbox.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_xoa_checkbox_tren_Excel\"><\/span>C\u00e1ch x\u00f3a checkbox tr\u00ean Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 x\u00f3a checkbox tr\u00ean Excel, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn checkbox n\u00e0y v\u00e0 nh\u1ea5n ph\u00edm Delete.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 x\u00f3a nhi\u1ec1u \u00f4 checkbox, b\u1ea1n h\u00e3y d\u00f9ng b\u1ea5t c\u1ee9 c\u00e1ch ch\u1ecdn nhi\u1ec1u \u00f4 checkbox n\u00e0o \u1edf tr\u00ean, v\u00e0 nh\u1ea5n ph\u00edm Delete.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 delete t\u1ea5t c\u1ea3 c\u00e1c checkbox, b\u1ea1n v\u00e0o tab <em>Home &gt; ph\u1ea7n Editing &gt; Find &amp; Select &gt; Go To Special<\/em>, tick ch\u1ecdn \u00f4 Objects v\u00e0 nh\u1ea5n OK. C\u00e1ch n\u00e0y s\u1ebd ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 checkbox trong trang t\u00ednh, v\u00e0 b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n ph\u00edm Delete \u0111\u1ec3 x\u00f3a to\u00e0n b\u1ed9 checkbox.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6514 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/delete-checkboxes-excel-293x300-1.png\" width=\"293\" height=\"300\" title=\"delete-checkboxes-excel-293x300-1\"><\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd.<\/strong> H\u00e3y c\u1ea9n th\u1eadn khi d\u00f9ng c\u00e1ch n\u00e0y v\u00ec kh\u00f4ng ch\u1ec9 to\u00e0n b\u1ed9 checkbox s\u1ebd b\u1ecb x\u00f3a, m\u00e0 ngay c\u1ea3 c\u00e1c h\u00ecnh kh\u1ed1i, bi\u1ec3u \u0111\u1ed3,\u2026 c\u0169ng s\u1ebd b\u1ecb x\u00f3a theo.<\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-nang-cao\">Excel n\u00e2ng cao<\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dinh_dang_cac_checkbox_trong_Excel\"><\/span>C\u00e1ch \u0111\u1ecbnh d\u1ea1ng c\u00e1c checkbox trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Form Controls c\u1ee7a Excel kh\u00f4ng c\u00f3 qu\u00e1 nhi\u1ec1u \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 ta l\u1ef1a ch\u1ecdn, nh\u01b0ng th\u1ef1c t\u1ebf v\u1eabn c\u00f3 m\u1ed9t v\u00e0i nh\u1eefng thay \u0111\u1ed5i m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n v\u1edbi checkbox c\u1ee7a m\u00ecnh. \u0110\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng, b\u1ea1n h\u00e3y click chu\u1ed9t ph\u1ea3i v\u00e0o checkbox, click v\u00e0o Format Control v\u00e0 l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p style=\"text-align: justify\">\u1ede tab <strong>Colors and Lines<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u00e0u t\u00f9y \u00fd cho checkbox trong ph\u1ea7n Fill, v\u00e0 ch\u1ecdn \u0111\u1ed9 \u0111\u1eadm nh\u1ea1t c\u0169ng nh\u01b0 ki\u1ec3u \u0111\u01b0\u1eddng vi\u1ec1n \u1edf ph\u1ea7n Line.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6515 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-checkbox-colors-300x281-1.png\" width=\"300\" height=\"281\" title=\"excel-checkbox-colors-300x281-1\"><\/p>\n<p style=\"text-align: justify\">V\u1edbi Form Control, \u0111\u00f3 l\u00e0 t\u1ea5t c\u1ea3 c\u00e1c l\u1ef1a ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng m\u00e0 b\u1ea1n c\u00f3. N\u1ebfu b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i checkbox c\u1ee7a m\u00ecnh nhi\u1ec1u h\u01a1n nh\u01b0 ki\u1ec3u ch\u1eef, k\u00edch c\u1ee1 ch\u1eef cho t\u00ean v\u00e0 ch\u00fa th\u00edch, b\u1ea1n h\u00e3y s\u1eed d\u1ee5ng ActiveX Control.<\/p>\n<p style=\"text-align: justify\">\u1ede tab <strong>Size<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i k\u00edch c\u1ee1 c\u1ee7a checkbox<\/p>\n<p style=\"text-align: justify\">\u1ede tab <strong>Protection<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 kh\u00f3a ho\u1eb7c h\u1ee7y kh\u00f3a checkbox. Vi\u1ec7c kh\u00f3a checkbox s\u1ebd c\u00f3 hi\u1ec7u l\u1ef1c khi b\u1ea1n kh\u00f3a trang t\u00ednh.<\/p>\n<p style=\"text-align: justify\">\u1ede tab <strong>Properties<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u1ee7a checkbox. C\u00e0i \u0111\u1eb7t m\u1eb7c \u0111\u1ecbnh \u2013 Move but don\u2019t size with cells \u2013 s\u1ebd c\u1ed1 \u0111\u1ecbnh checkbox v\u1edbi \u00f4 m\u00e0 b\u1ea1n \u0111\u1eb7t checkbox.<\/p>\n<ul>\n<li>N\u1ebfu b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a checkbox trong trang t\u00ednh, v\u00ed d\u1ee5 nh\u01b0 \u1edf tr\u00ean \u0111\u1ea7u trang t\u00ednh, h\u00e3y ch\u1ecdn Don\u2019t move or size with cells. Nh\u01b0 v\u1eady, d\u00f9 c\u00f3 bao nhi\u00eau \u00f4 v\u00e0 bao nhi\u00eau h\u00e0ng c\u1ed9t, checkbox s\u1ebd gi\u1eef nguy\u00ean \u1edf v\u1ecb tr\u00ed.<\/li>\n<li>N\u1ebfu b\u1ea1n mu\u1ed1n checkbox \u0111\u01b0\u1ee3c in c\u00f9ng trang t\u00ednh, h\u00e3y \u0111\u00e1nh d\u1ea5u tick v\u00e0o \u00f4 Print object nh\u00e9.<\/li>\n<\/ul>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6516 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fix-checkbox-position-300x281-1.png\" width=\"300\" height=\"281\" title=\"fix-checkbox-position-300x281-1\"><\/p>\n<p style=\"text-align: justify\">\u1ede tab <strong>Alt Text<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 ghi r\u00f5 t\u00ean thay th\u1ebf cho checkbox. Theo c\u00e0i \u0111\u1eb7t m\u1eb7c \u0111\u1ecbnh, t\u00ean thay th\u1ebf n\u00e0y s\u1ebd gi\u1ed1ng v\u1edbi ch\u00fa th\u00edch c\u1ee7a checkbox.<\/p>\n<p style=\"text-align: justify\">\u1ede tab <strong>Control<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 c\u00e0i \u0111\u1eb7t m\u1eb7c \u0111\u1ecbnh cho checkbox nh\u01b0 sau:<\/p>\n<ul>\n<li style=\"text-align: justify\">Checked: m\u1ecdi \u00f4 checkbox b\u1ea1n th\u00eam v\u00e0o trang t\u00ednh s\u1ebd c\u00f3 d\u1ea5u tick<\/li>\n<li style=\"text-align: justify\">Unchecked: m\u1ecdi \u00f4 checkbox b\u1ea1n th\u00eam v\u00e0o trang t\u00ednh s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ec3 tr\u1ed1ng<\/li>\n<li style=\"text-align: justify\">Mixed: mixed checkbox s\u1ebd ph\u00f9 h\u1ee3p khi b\u1ea1n s\u1eed d\u1ee5ng VBA.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t thi\u1ebft k\u1ebf kh\u00e1c l\u1ea1 cho checkbox b\u1eb1ng c\u00e1ch tick v\u00e0o \u00f4 <strong>3D shading<\/strong>.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 k\u1ebft n\u1ed1i checkbox v\u1edbi m\u1ed9t \u00f4 c\u1ee5 th\u1ec3, b\u1ea1n h\u00e3y \u0111i\u1ec1n \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 \u0111\u00f3 v\u00e0o h\u1ed9p <strong>Cell link<\/strong>. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o v\u1ec1 vi\u1ec7c k\u1ebft n\u1ed1i checkbox v\u1edbi m\u1ed9t \u00f4 c\u1ee5 th\u1ec3 v\u00e0 l\u1ee3i \u00edch c\u1ee7a vi\u1ec7c n\u00e0y t\u1ea1i c\u00e1c b\u00e0i vi\u1ebft ti\u1ebfp theo trong H\u1ecdc Excel Online nh\u00e9.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6510 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/checkbox-state-300x281-1.png\" width=\"300\" height=\"281\" title=\"checkbox-state-300x281-1\"><\/p>\n<p style=\"text-align: justify\">B\u00e0i vi\u1ebft tr\u00ean \u0111\u00e3 h\u01b0\u1edbng d\u1eabn b\u1ea1n nh\u1eefng c\u00e1ch th\u1ee9c \u0111\u1ec3 th\u00eam, thay \u0111\u1ed5i v\u00e0 x\u00f3a checkbox trong Excel. C\u1ea3m \u01a1n v\u00e0 h\u1eb9n g\u1eb7p l\u1ea1i trong nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo.<\/p>\n<p style=\"text-align: justify\"><em>Ngu\u1ed3n: Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi <a href=\"http:\/\/blog.ezworkapp.com\/excel-nang-cao\">blog.hocexcel.online<\/a><\/em><\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/chen-hop-kiem-checkbox-vao-excel.html\">Ch\u00e8n h\u1ed9p ki\u1ec3m\/checkbox v\u00e0o Excel<\/a><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-tao-combo-box-trong-excel.html\">C\u00e1ch t\u1ea1o Combo Box trong Excel<\/a><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc<\/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-135.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4021,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4020","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\/4020","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=4020"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4020\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4021"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}