{"id":492531,"date":"2025-09-23T08:14:40","date_gmt":"2025-09-23T01:14:40","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=492531"},"modified":"2025-09-23T08:14:40","modified_gmt":"2025-09-23T01:14:40","slug":"checkbox","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/","title":{"rendered":"C\u00e1ch t\u1ea1o Checkbox (h\u1ed9p ki\u1ec3m) nhanh ch\u00f3ng trong Excel"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel, ch\u1eafc h\u1eb3n b\u1ea1n \u0111\u00e3 nhi\u1ec1u l\u1ea7n c\u1ea7n m\u1ed9t c\u00f4ng c\u1ee5 \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u, qu\u1ea3n l\u00fd c\u00f4ng vi\u1ec7c ho\u1eb7c t\u1ea1o danh s\u00e1ch ki\u1ec3m tra. Thay v\u00ec ch\u1ec9 nh\u00ecn v\u00e0o d\u1eef li\u1ec7u kh\u00f4 khan, <\/span><b>Checkbox <\/b><span style=\"font-weight: 400;\">cho ph\u00e9p b\u1ea1n \u0111\u00e1nh d\u1ea5u nhanh c\u00e1c m\u1ee5c \u0111\u00e3 ho\u00e0n th\u00e0nh, ph\u00e2n lo\u1ea1i tr\u1ea1ng th\u00e1i ho\u1eb7c l\u1ecdc th\u00f4ng tin hi\u1ec7u qu\u1ea3. Sau \u0111\u00e2y, <strong>Ho\u00e0ng H\u00e0 Mobile<\/strong> h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch t\u1ea1o, ch\u1ec9nh s\u1eeda, \u0111\u1ebfm v\u00e0 x\u00f3a h\u1ed9p ki\u1ec3m trong Excel, gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng c\u1ee5 n\u00e0y t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao, ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch t\u1ea1o Checkbox trong Excel b\u1eb1ng th\u1ebb Developer<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong Excel, h\u1ed9p ki\u1ec3m l\u00e0 c\u00f4ng c\u1ee5 r\u1ea5t h\u1eefu \u00edch, th\u01b0\u1eddng d\u00f9ng \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u tr\u1ea1ng th\u00e1i, qu\u1ea3n l\u00fd danh s\u00e1ch c\u00f4ng vi\u1ec7c ho\u1eb7c thi\u1ebft k\u1ebf c\u00e1c bi\u1ec3u m\u1eabu t\u01b0\u01a1ng t\u00e1c. \u0110\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c t\u00ednh n\u0103ng n\u00e0y, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n k\u00edch ho\u1ea1t th\u1ebb Developer, v\u1ed1n m\u1eb7c \u0111\u1ecbnh b\u1ecb \u1ea9n trong Excel. Sau khi b\u1eadt, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng ch\u00e8n h\u1ed9p ki\u1ec3m v\u00e0o b\u1ea5t k\u1ef3 \u00f4 d\u1eef li\u1ec7u n\u00e0o, gi\u00fap b\u1ea3ng t\u00ednh tr\u1edf n\u00ean tr\u1ef1c quan v\u00e0 ti\u1ec7n l\u1ee3i h\u01a1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: B\u1eadt th\u1ebb Developer<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Truy c\u1eadp v\u00e0o File \u2192 Options.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong c\u1eeda s\u1ed5 Excel Options, ch\u1ecdn m\u1ee5c Customize Ribbon.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u00edch ch\u1ecdn Developer trong danh s\u00e1ch c\u00e1c tab hi\u1ec3n th\u1ecb.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1ea5n OK \u0111\u1ec3 ho\u00e0n t\u1ea5t. L\u00fac n\u00e0y, th\u1ebb Developer s\u1ebd xu\u1ea5t hi\u1ec7n tr\u00ean thanh c\u00f4ng c\u1ee5 c\u1ee7a b\u1ea1n.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-492533 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-1.jpg\" alt=\"Checkbox-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Th\u00eam h\u1ed9p ki\u1ec3m v\u00e0o b\u1ea3ng t\u00ednh<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Tr\u00ean th\u1ebb Developer, ch\u1ecdn Insert \u2192 Form Controls \u2192 Checkbox.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1ea5p v\u00e0o v\u1ecb tr\u00ed trong b\u1ea3ng t\u00ednh n\u01a1i b\u1ea1n mu\u1ed1n ch\u00e8n h\u1ed9p ki\u1ec3m. M\u1ed9t h\u1ed9p ki\u1ec3m m\u1eb7c \u0111\u1ecbnh s\u1ebd xu\u1ea5t hi\u1ec7n ngay l\u1eadp t\u1ee9c.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-492534 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-2.jpg\" alt=\"Checkbox-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Ch\u1ec9nh s\u1eeda c\u01a1 b\u1ea3n cho h\u1ed9p ki\u1ec3m<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Di chuy\u1ec3n ho\u1eb7c c\u0103n ch\u1ec9nh v\u1ecb tr\u00ed h\u1ed9p ki\u1ec3msao cho kh\u1edbp v\u1edbi b\u1ed1 c\u1ee5c b\u1ea3ng t\u00ednh.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1ea5p chu\u1ed9t ph\u1ea3i ch\u1ecdn Edit Text \u0111\u1ec3 \u0111\u1ed5i t\u00ean hi\u1ec3n th\u1ecb, v\u00ed d\u1ee5: \u201cHo\u00e0n th\u00e0nh\u201d, \u201c\u0110ang x\u1eed l\u00fd\u201d, ho\u1eb7c \u201cCh\u01b0a b\u1eaft \u0111\u1ea7u\u201d.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-492535 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-3.jpg\" alt=\"Checkbox-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch t\u1ea1o \u00f4 Checkbox h\u00e0ng lo\u1ea1t tr\u00ean file Excel<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong th\u1ef1c t\u1ebf, b\u1ea1n kh\u00f4ng ch\u1ec9 c\u1ea7n m\u1ed9t ho\u1eb7c hai h\u1ed9p ki\u1ec3m, m\u00e0 th\u01b0\u1eddng ph\u1ea3i t\u1ea1o h\u00e0ng lo\u1ea1t h\u1ed9p ki\u1ec3m cho c\u1ea3 m\u1ed9t danh s\u00e1ch c\u00f4ng vi\u1ec7c, b\u1ea3ng ch\u1ea5m c\u00f4ng ho\u1eb7c k\u1ebf ho\u1ea1ch d\u1ef1 \u00e1n. N\u1ebfu th\u1ef1c hi\u1ec7n th\u1ee7 c\u00f4ng b\u1eb1ng Developer, b\u1ea1n s\u1ebd m\u1ea5t nhi\u1ec1u th\u1eddi gian v\u00ec ph\u1ea3i ch\u00e8n t\u1eebng h\u1ed9p ki\u1ec3m.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1ea1o Checkbox h\u00e0ng lo\u1ea1t b\u1eb1ng code VBA<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi nh\u1eefng ai th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh l\u1edbn, vi\u1ec7c t\u1ea1o h\u1ed9p ki\u1ec3m th\u1ee7 c\u00f4ng t\u1eebng \u00f4 s\u1ebd m\u1ea5t r\u1ea5t nhi\u1ec1u th\u1eddi gian. VBA (Visual Basic for Applications) ch\u00ednh l\u00e0 gi\u1ea3i ph\u00e1p h\u1eefu hi\u1ec7u, cho ph\u00e9p b\u1ea1n ch\u00e8n nhi\u1ec1u h\u1ed9p ki\u1ec3m c\u00f9ng l\u00fac ch\u1ec9 v\u1edbi v\u00e0i thao t\u00e1c. \u0110\u00e2y l\u00e0 m\u1ed9t ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh nh\u1ecf \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p s\u1eb5n trong Excel, gi\u00fap t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c b\u01b0\u1edbc l\u1eb7p \u0111i l\u1eb7p l\u1ea1i.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: M\u1edf c\u1eeda s\u1ed5 VBA<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Tr\u00ean b\u00e0n ph\u00edm, nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Alt + F11 \u0111\u1ec3 truy c\u1eadp v\u00e0o giao di\u1ec7n VBA.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492536 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-4.jpg\" alt=\"Checkbox-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: T\u1ea1o Module m\u1edbi<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong c\u1eeda s\u1ed5 VBA, ch\u1ecdn Insert \u2192 Module.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">M\u1ed9t khung so\u1ea1n th\u1ea3o m\u1edbi s\u1ebd xu\u1ea5t hi\u1ec7n \u0111\u1ec3 b\u1ea1n nh\u1eadp m\u00e3 l\u1ec7nh.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492537 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-5.jpg\" alt=\"Checkbox-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Th\u00eam \u0111o\u1ea1n code VBA<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sao ch\u00e9p v\u00e0 d\u00e1n \u0111o\u1ea1n code VBA t\u1ea1o h\u1ed9p ki\u1ec3m h\u00e0ng lo\u1ea1t v\u00e0o Module.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, m\u1ed9t \u0111o\u1ea1n code \u0111\u01a1n gi\u1ea3n c\u00f3 th\u1ec3 gi\u00fap ch\u00e8n h\u1ed9p ki\u1ec3m v\u00e0o to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 ch\u1ecdn.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Ch\u1ea1y Macro<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sau khi nh\u1eadp code, nh\u1ea5n F5 ho\u1eb7c ch\u1ecdn Run \u0111\u1ec3 th\u1ef1c thi.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng th\u00eam h\u1ed9p ki\u1ec3m t\u1ea1i m\u1ed7i \u00f4 trong v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492538 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-6.jpg\" alt=\"Checkbox-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1ea1o Checkbox h\u00e0ng lo\u1ea1t v\u1edbi Fill Handle<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Fill Handle l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 quen thu\u1ed9c nh\u1ea5t trong Excel, th\u01b0\u1eddng d\u00f9ng \u0111\u1ec3 sao ch\u00e9p d\u1eef li\u1ec7u ho\u1eb7c c\u00f4ng th\u1ee9c. Tuy nhi\u00ean, \u00edt ng\u01b0\u1eddi bi\u1ebft r\u1eb1ng n\u00f3 c\u00f2n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c t\u1eadn d\u1ee5ng \u0111\u1ec3 nh\u00e2n b\u1ea3n h\u1ed9p ki\u1ec3m h\u00e0ng lo\u1ea1t m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng. \u0110\u00e2y l\u00e0 ph\u01b0\u01a1ng ph\u00e1p ph\u00f9 h\u1ee3p cho nh\u1eefng ai mu\u1ed1n t\u1ea1o nhi\u1ec1u h\u1ed9p ki\u1ec3m nh\u01b0ng kh\u00f4ng mu\u1ed1n s\u1eed d\u1ee5ng VBA.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1o h\u1ed9p ki\u1ec3m ban \u0111\u1ea7u<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Truy c\u1eadp th\u1ebb Developer \u2192 Insert \u2192 ch\u1ecdn <\/span><b>Checkbox <\/b><span style=\"font-weight: 400;\">(Form Controls).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u00e8n h\u1ed9p ki\u1ec3m v\u00e0o \u00f4 d\u1eef li\u1ec7u mong mu\u1ed1n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u0103n ch\u1ec9nh sao cho h\u1ed9p ki\u1ec3m n\u1eb1m g\u1ecdn trong ph\u1ea1m vi \u00f4, tr\u00e1nh b\u1ecb l\u1ec7ch ra ngo\u00e0i b\u1ea3ng.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492539 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-7.jpg\" alt=\"Checkbox-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: S\u1eed d\u1ee5ng Fill Handle \u0111\u1ec3 nh\u00e2n b\u1ea3n<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn \u00f4 ch\u1ee9a h\u1ed9p ki\u1ec3m v\u1eeba t\u1ea1o.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u01b0a con tr\u1ecf chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4, khi xu\u1ea5t hi\u1ec7n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u c\u1ed9ng nh\u1ecf (+), \u0111\u00f3 ch\u00ednh l\u00e0 Fill Handle.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1ea5n gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o xu\u1ed1ng ho\u1eb7c k\u00e9o ngang sang c\u00e1c \u00f4 kh\u00e1c.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492540 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-8.jpg\" alt=\"Checkbox-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Ho\u00e0n t\u1ea5t qu\u00e1 tr\u00ecnh<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Th\u1ea3 chu\u1ed9t, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng sao ch\u00e9p h\u1ed9p ki\u1ec3m sang to\u00e0n b\u1ed9 v\u00f9ng b\u1ea1n v\u1eeba ch\u1ecdn.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00e1c h\u1ed9p ki\u1ec3m \u0111\u01b0\u1ee3c sao ch\u00e9p v\u1eabn ho\u1ea1t \u0111\u1ed9ng \u0111\u1ed9c l\u1eadp, c\u00f3 th\u1ec3 t\u00edch ch\u1ecdn ho\u1eb7c li\u00ean k\u1ebft v\u1edbi d\u1eef li\u1ec7u kh\u00e1c.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492541 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-9.jpg\" alt=\"Checkbox-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tuy nhi\u00ean, Fill Handle s\u1ebd k\u00e9m hi\u1ec7u qu\u1ea3 n\u1ebfu b\u1ea3ng d\u1eef li\u1ec7u qu\u00e1 l\u1edbn, b\u1edfi thao t\u00e1c k\u00e9o th\u1ea3 c\u00f3 th\u1ec3 m\u1ea5t nhi\u1ec1u th\u1eddi gian v\u00e0 khi\u1ebfn h\u1ed9p ki\u1ec3m b\u1ecb l\u1ec7ch v\u1ecb tr\u00ed. Do \u0111\u00f3, c\u00e1ch n\u00e0y th\u00edch h\u1ee3p h\u01a1n cho danh s\u00e1ch ng\u1eafn \u0111\u1ebfn trung b\u00ecnh. V\u1edbi b\u1ea3ng c\u00f3 h\u00e0ng tr\u0103m d\u00f2ng, b\u1ea1n n\u00ean c\u00e2n nh\u1eafc s\u1eed d\u1ee5ng VBA \u0111\u1ec3 \u0111\u1ea1t hi\u1ec7u qu\u1ea3 t\u1ed1i \u01b0u.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch ch\u1ec9nh s\u1eeda Checkbox trong Excel<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau khi \u0111\u00e3 ch\u00e8n th\u00e0nh c\u00f4ng c\u00e1c h\u1ed9p ki\u1ec3m v\u00e0o b\u1ea3ng t\u00ednh, b\u01b0\u1edbc ti\u1ebfp theo th\u01b0\u1eddng l\u00e0 \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ec3 ch\u00fang hi\u1ec3n th\u1ecb \u0111\u1eb9p m\u1eaft v\u00e0 ph\u00f9 h\u1ee3p v\u1edbi b\u1ed1 c\u1ee5c d\u1eef li\u1ec7u. N\u1ebfu \u0111\u1ec3 m\u1eb7c \u0111\u1ecbnh, h\u1ed9p ki\u1ec3m c\u00f3 th\u1ec3 b\u1ecb l\u1ec7ch, k\u00edch th\u01b0\u1edbc kh\u00f4ng \u0111\u1ed3ng \u0111\u1ec1u ho\u1eb7c t\u00ean hi\u1ec3n th\u1ecb kh\u00f4ng r\u00f5 r\u00e0ng.\u00a0<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch s\u1eeda v\u1ecb tr\u00ed c\u1ee7a h\u1ed9p ki\u1ec3m<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, khi ch\u00e8n h\u1ed9p ki\u1ec3m v\u00e0o Excel, v\u1ecb tr\u00ed m\u1eb7c \u0111\u1ecbnh kh\u00f4ng tr\u00f9ng kh\u1edbp v\u1edbi \u00f4 d\u1eef li\u1ec7u mong mu\u1ed1n. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 khi\u1ebfn b\u1ea3ng bi\u1ec3u tr\u1edf n\u00ean r\u1ed1i m\u1eaft ho\u1eb7c kh\u00f3 theo d\u00f5i. \u0110\u1ec3 kh\u1eafc ph\u1ee5c, b\u1ea1n c\u00f3 th\u1ec3 di chuy\u1ec3n v\u00e0 ch\u1ec9nh s\u1eeda v\u1ecb tr\u00ed c\u1ee7a h\u1ed9p ki\u1ec3m theo c\u00e1ch th\u1ee7 c\u00f4ng ho\u1eb7c s\u1eed d\u1ee5ng c\u00e1c thi\u1ebft l\u1eadp n\u00e2ng cao trong Excel \u0111\u1ec3 \u0111\u1ea1t \u0111\u1ed9 ch\u00ednh x\u00e1c cao h\u01a1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Di chuy\u1ec3n th\u1ee7 c\u00f4ng<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1ea5p chu\u1ed9t v\u00e0o h\u1ed9p ki\u1ec3m c\u1ea7n \u0111i\u1ec1u ch\u1ec9nh.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o \u0111\u1ebfn v\u1ecb tr\u00ed mong mu\u1ed1n trong b\u1ea3ng t\u00ednh.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u0103n ch\u1ec9nh \u0111\u1ec3 h\u1ed9p ki\u1ec3m n\u1eb1m g\u1ecdn trong \u00f4, th\u01b0\u1eddng \u1edf ch\u00ednh gi\u1eefa \u0111\u1ec3 t\u1ea1o s\u1ef1 c\u00e2n \u0111\u1ed1i v\u00e0 d\u1ec5 nh\u00ecn.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492542 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-10.jpg\" alt=\"Checkbox-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Tinh ch\u1ec9nh b\u1eb1ng ph\u00edm m\u0169i t\u00ean<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu mu\u1ed1n d\u1ecbch chuy\u1ec3n ch\u00ednh x\u00e1c h\u01a1n t\u1eebng pixel, h\u00e3y ch\u1ecdn h\u1ed9p ki\u1ec3m r\u1ed3i s\u1eed d\u1ee5ng c\u00e1c ph\u00edm m\u0169i t\u00ean tr\u00ean b\u00e0n ph\u00edm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00e1ch n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n b\u1ed1 tr\u00ed h\u1ed9p ki\u1ec3m th\u1eb3ng h\u00e0ng ho\u1eb7c \u0111\u1ec1u nhau tr\u00ean nhi\u1ec1u \u00f4.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: C\u1ed1 \u0111\u1ecbnh h\u1ed9p ki\u1ec3m so v\u1edbi \u00f4 ch\u1ee9a<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o h\u1ed9p ki\u1ec3m, ch\u1ecdn Format Control.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong c\u1eeda s\u1ed5 hi\u1ec7n ra, chuy\u1ec3n sang tab Properties.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u00e1nh d\u1ea5u t\u00f9y ch\u1ecdn Don\u2019t move or size with cells \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh h\u1ed9p ki\u1ec3m.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi \u0111\u00f3, h\u1ed9p ki\u1ec3m s\u1ebd gi\u1eef nguy\u00ean v\u1ecb tr\u00ed ngay c\u1ea3 khi b\u1ea1n thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc \u00f4, th\u00eam h\u00e0ng ho\u1eb7c c\u1ed9t.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492543 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-11.jpg\" alt=\"Checkbox-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch s\u1eeda t\u00ean Checkbox<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi ch\u00e8n h\u1ed9p ki\u1ec3m trong Excel, m\u1eb7c \u0111\u1ecbnh h\u1ec7 th\u1ed1ng s\u1ebd g\u00e1n t\u00ean nh\u01b0 \u201cCheck Box 1\u201d, \u201cCheck Box 2\u201d\u2026 Nh\u1eefng t\u00ean n\u00e0y kh\u00f4ng mang \u00fd ngh\u0129a c\u1ee5 th\u1ec3, d\u1ec5 g\u00e2y nh\u1ea7m l\u1eabn n\u1ebfu b\u1ea1n c\u00f3 nhi\u1ec1u h\u1ed9p ki\u1ec3m tr\u00ean c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh. V\u00ec v\u1eady, vi\u1ec7c \u0111\u1ed5i t\u00ean h\u1ed9p ki\u1ec3m \u0111\u1ec3 m\u00f4 t\u1ea3 r\u00f5 n\u1ed9i dung ho\u1eb7c tr\u1ea1ng th\u00e1i l\u00e0 c\u1ea7n thi\u1ebft, gi\u00fap b\u1ea3ng d\u1eef li\u1ec7u tr\u1edf n\u00ean tr\u1ef1c quan v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ch\u1ec9nh s\u1eeda tr\u1ef1c ti\u1ebfp v\u0103n b\u1ea3n hi\u1ec3n th\u1ecb<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o h\u1ed9p ki\u1ec3m c\u1ea7n \u0111\u1ed5i t\u00ean.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn t\u00f9y ch\u1ecdn Edit Text.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1eadp n\u1ed9i dung b\u1ea1n mong mu\u1ed1n, v\u00ed d\u1ee5: \u201cHo\u00e0n th\u00e0nh\u201d, \u201c\u0110ang x\u1eed l\u00fd\u201d, \u201cCh\u01b0a th\u1ef1c hi\u1ec7n\u201d ho\u1eb7c \u201c\u0110\u1ed3ng \u00fd \u0111i\u1ec1u ki\u1ec7n\u201d.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: \u0110\u1eb7t t\u00ean c\u1ee5 th\u1ec3 theo ng\u1eef c\u1ea3nh<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">V\u1edbi danh s\u00e1ch c\u00f4ng vi\u1ec7c, h\u00e3y ch\u1ecdn t\u00ean m\u00f4 t\u1ea3 r\u00f5 r\u00e0ng t\u1eebng tr\u1ea1ng th\u00e1i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong c\u00e1c b\u1ea3ng theo d\u00f5i d\u1ef1 \u00e1n, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t t\u00ean theo t\u1eebng giai \u0111o\u1ea1n nh\u01b0: \u201cKh\u1ea3o s\u00e1t\u201d, \u201cThi\u1ebft k\u1ebf\u201d, \u201cTri\u1ec3n khai\u201d, \u201cNghi\u1ec7m thu\u201d.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492544 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-12.jpg\" alt=\"Checkbox-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: G\u00e1n Object Name trong Selection Pane (n\u00e2ng cao)<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Tr\u00ean thanh c\u00f4ng c\u1ee5, v\u00e0o Home \u2192 Find &amp; Select \u2192 Selection Pane.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn h\u1ed9p ki\u1ec3m trong danh s\u00e1ch, sau \u0111\u00f3 g\u00e1n l\u1ea1i t\u00ean \u0111\u1ed1i t\u01b0\u1ee3ng (Object Name).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Vi\u1ec7c n\u00e0y r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n c\u00f3 nhi\u1ec1u h\u1ed9p ki\u1ec3m v\u00e0 mu\u1ed1n qu\u1ea3n l\u00fd qua macro ho\u1eb7c c\u00f4ng th\u1ee9c.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc h\u1ed9p ki\u1ec3m<\/span><\/h3>\n<p style=\"text-align: justify;\"><b>Checkbox <\/b><span style=\"font-weight: 400;\">m\u1eb7c \u0111\u1ecbnh trong Excel kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng ph\u00f9 h\u1ee3p v\u1edbi b\u1ed1 c\u1ee5c b\u1ea3ng t\u00ednh. C\u00f3 tr\u01b0\u1eddng h\u1ee3p h\u1ed9p ki\u1ec3m qu\u00e1 nh\u1ecf khi\u1ebfn ng\u01b0\u1eddi d\u00f9ng kh\u00f3 quan s\u00e1t, ho\u1eb7c qu\u00e1 l\u1edbn l\u00e0m m\u1ea5t c\u00e2n \u0111\u1ed1i so v\u1edbi \u00f4 ch\u1ee9a. V\u00ec v\u1eady, vi\u1ec7c thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc h\u1ed9p ki\u1ec3m l\u00e0 m\u1ed9t b\u01b0\u1edbc ch\u1ec9nh s\u1eeda quan tr\u1ecdng, gi\u00fap b\u1ea3ng bi\u1ec3u tr\u00f4ng g\u1ecdn g\u00e0ng v\u00e0 d\u1ec5 theo d\u00f5i h\u01a1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: M\u1edf t\u00f9y ch\u1ecdn ch\u1ec9nh s\u1eeda<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o h\u1ed9p ki\u1ec3m c\u1ea7n \u0111i\u1ec1u ch\u1ec9nh.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn Format Control trong menu.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: \u0110i\u1ec1u ch\u1ec9nh k\u00edch th\u01b0\u1edbc trong Format Control<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong c\u1eeda s\u1ed5 Format Control, truy c\u1eadp tab Size.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1eadp gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 v\u00e0o \u00f4 Height (chi\u1ec1u cao) v\u00e0 Width (chi\u1ec1u r\u1ed9ng) \u0111\u1ec3 \u0111\u1ea1t \u0111\u1ed9 ch\u00ednh x\u00e1c mong mu\u1ed1n.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492545 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-13.jpg\" alt=\"Checkbox-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Thay \u0111\u1ed5i th\u1ee7 c\u00f4ng b\u1eb1ng chu\u1ed9t<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ngo\u00e0i c\u00e1ch nh\u1eadp s\u1ed1 li\u1ec7u, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 k\u00e9o c\u00e1c g\u00f3c ho\u1eb7c c\u1ea1nh c\u1ee7a h\u1ed9p ki\u1ec3m \u0111\u1ec3 ph\u00f3ng to ho\u1eb7c thu nh\u1ecf theo \u00fd mu\u1ed1n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00e1ch n\u00e0y linh ho\u1ea1t, th\u00edch h\u1ee3p khi b\u1ea1n c\u1ea7n \u0111i\u1ec1u ch\u1ec9nh nhanh m\u00e0 kh\u00f4ng y\u00eau c\u1ea7u \u0111\u1ed9 ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: \u0110\u1ed3ng b\u1ed9 k\u00edch th\u01b0\u1edbc cho nhi\u1ec1u h\u1ed9p ki\u1ec3m\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea3ng c\u00f3 nhi\u1ec1u h\u1ed9p ki\u1ec3m, h\u00e3y ch\u1ecdn to\u00e0n b\u1ed9 ch\u00fang c\u00f9ng l\u00fac.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Th\u1ef1c hi\u1ec7n thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc m\u1ed9t l\u1ea7n \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o s\u1ef1 \u0111\u1ed3ng nh\u1ea5t.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">V\u1edbi b\u00e1o c\u00e1o d\u00e0nh cho ng\u01b0\u1eddi l\u1edbn tu\u1ed5i ho\u1eb7c hi\u1ec3n th\u1ecb tr\u00ean m\u00e0n h\u00ecnh nh\u1ecf, vi\u1ec7c t\u0103ng k\u00edch th\u01b0\u1edbc h\u1ed9p ki\u1ec3m gi\u00fap ng\u01b0\u1eddi d\u00f9ng thao t\u00e1c d\u1ec5 d\u00e0ng h\u01a1n. Ng\u01b0\u1ee3c l\u1ea1i, khi b\u1ea3ng ch\u1ee9a nhi\u1ec1u c\u1ed9t v\u00e0 c\u1ea7n t\u1ed1i \u01b0u kh\u00f4ng gian, b\u1ea1n c\u00f3 th\u1ec3 thu nh\u1ecf h\u1ed9p ki\u1ec3m m\u00e0 v\u1eabn gi\u1eef \u0111\u01b0\u1ee3c t\u00ednh n\u0103ng \u0111\u00e1nh d\u1ea5u.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch \u0111\u1ebfm s\u1ed1 h\u1ed9p Checkbox \u0111\u00e3 ch\u1ecdn trong Excel<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t \u1ee9ng d\u1ee5ng r\u1ea5t h\u1eefu \u00edch l\u00e0 \u0111\u1ebfm s\u1ed1 h\u1ed9p ki\u1ec3m \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn \u0111\u1ec3 bi\u1ebft ti\u1ebfn \u0111\u1ed9 c\u00f4ng vi\u1ec7c ho\u1eb7c th\u1ed1ng k\u00ea nhanh danh s\u00e1ch ho\u00e0n th\u00e0nh. Tuy nhi\u00ean, Excel kh\u00f4ng c\u00f3 s\u1eb5n h\u00e0m \u0111\u1ebfm h\u1ed9p ki\u1ec3m tr\u1ef1c ti\u1ebfp. Thay v\u00e0o \u0111\u00f3, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng \u00f4 li\u00ean k\u1ebft (Linked Cell) k\u1ebft h\u1ee3p c\u00f4ng th\u1ee9c \u0111\u1ec3 x\u1eed l\u00fd.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Li\u00ean k\u1ebft h\u1ed9p ki\u1ec3m v\u1edbi m\u1ed9t \u00f4<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o h\u1ed9p ki\u1ec3m c\u1ea7n s\u1eed d\u1ee5ng.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492546 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-14.jpg\" alt=\"Checkbox-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ecdn Format Control \u2192 tab Control \u2192 m\u1ee5c Cell link.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492547 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-15.jpg\" alt=\"Checkbox-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ch\u1ec9 \u0111\u1ecbnh m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng t\u00ednh \u0111\u1ec3 l\u01b0u tr\u1ea1ng th\u00e1i. Khi h\u1ed9p ki\u1ec3m \u0111\u01b0\u1ee3c ch\u1ecdn, \u00f4 li\u00ean k\u1ebft s\u1ebd hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb TRUE; khi b\u1ecf ch\u1ecdn s\u1ebd hi\u1ec3n th\u1ecb FALSE.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492548 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-16.jpg\" alt=\"Checkbox-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: \u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c COUNTIF \u0111\u1ec3 \u0111\u1ebfm<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sau khi \u0111\u00e3 g\u1eafn \u00f4 li\u00ean k\u1ebft cho t\u1ea5t c\u1ea3 h\u1ed9p ki\u1ec3m, nh\u1eadp c\u00f4ng th\u1ee9c:<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span> <span style=\"font-weight: 400;\">=COUNTIF(D2:D15, TRUE)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3, D2:D15 l\u00e0 v\u00f9ng ch\u1ee9a c\u00e1c \u00f4 li\u00ean k\u1ebft. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 t\u1ed5ng s\u1ed1 h\u1ed9p ki\u1ec3m \u0111\u00e3 \u0111\u01b0\u1ee3c t\u00edch ch\u1ecdn.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492549 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-17.jpg\" alt=\"Checkbox-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: K\u1ebft h\u1ee3p v\u1edbi h\u00e0m n\u00e2ng cao<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c m\u1ee5c \u0111i k\u00e8m h\u1ed9p ki\u1ec3m \u0111\u00e3 ch\u1ecdn, h\u00e3y d\u00f9ng c\u00f4ng th\u1ee9c:<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span> <span style=\"font-weight: 400;\">=SUMPRODUCT((D2:D15=TRUE)*C2:C15)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u1ede \u0111\u00e2y, C2:C15 l\u00e0 c\u1ed9t gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh t\u1ed5ng.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-18-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492550 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-18.jpg\" alt=\"Checkbox-18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1c thao t\u00e1c x\u00f3a Checkbox trong Excel<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Sau khi t\u1ea1o v\u00e0 s\u1eed d\u1ee5ng h\u1ed9p ki\u1ec3m trong Excel, \u0111\u00f4i khi b\u1ea1n s\u1ebd c\u1ea7n x\u00f3a ch\u00fang \u0111i \u0111\u1ec3 l\u00e0m g\u1ecdn b\u1ea3ng t\u00ednh ho\u1eb7c thay th\u1ebf b\u1eb1ng m\u1ed9t ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c. T\u00f9y v\u00e0o nhu c\u1ea7u, b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a t\u1eebng h\u1ed9p ki\u1ec3m ri\u00eang l\u1ebb, x\u00f3a nhi\u1ec1u h\u1ed9p c\u00f9ng l\u00fac ho\u1eb7c x\u00f3a to\u00e0n b\u1ed9 h\u1ed9p ki\u1ec3m trong m\u1ed9t trang t\u00ednh.\u00a0<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">X\u00f3a t\u1eebng Checkbox<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n ch\u1ec9 c\u00f3 v\u00e0i h\u1ed9p ki\u1ec3m , c\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 x\u00f3a l\u00e0 thao t\u00e1c th\u1ee7 c\u00f4ng t\u1eebng c\u00e1i m\u1ed9t. B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5p chu\u1ed9t v\u00e0o h\u1ed9p ki\u1ec3m c\u1ea7n x\u00f3a, sau \u0111\u00f3 nh\u1ea5n ph\u00edm Delete tr\u00ean b\u00e0n ph\u00edm. H\u1ed9p ki\u1ec3m s\u1ebd bi\u1ebfn m\u1ea5t ngay l\u1eadp t\u1ee9c m\u00e0 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn d\u1eef li\u1ec7u trong c\u00e1c \u00f4 xung quanh.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n kh\u00f4ng th\u1ec3 ch\u1ecdn \u0111\u01b0\u1ee3c h\u1ed9p ki\u1ec3m b\u1eb1ng chu\u1ed9t tr\u00e1i, h\u00e3y th\u1eed click chu\u1ed9t ph\u1ea3i v\u00e0o h\u1ed9p ki\u1ec3m \u0111\u1ec3 xu\u1ea5t hi\u1ec7n khung vi\u1ec1n, r\u1ed3i nh\u1ea5n Delete. \u0110\u00e2y l\u00e0 t\u00ecnh hu\u1ed1ng th\u01b0\u1eddng g\u1eb7p khi h\u1ed9p ki\u1ec3m b\u1ecb ch\u00e8n \u0111\u00e8 l\u00ean nhi\u1ec1u l\u1edbp d\u1eef li\u1ec7u ho\u1eb7c n\u1eb1m qu\u00e1 s\u00e1t nhau.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-19-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492551 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-19.jpg\" alt=\"Checkbox-19\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-19-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tuy nhi\u00ean, n\u1ebfu danh s\u00e1ch d\u00e0i v\u1edbi h\u00e0ng ch\u1ee5c ho\u1eb7c h\u00e0ng tr\u0103m h\u1ed9p ki\u1ec3m , thao t\u00e1c th\u1ee7 c\u00f4ng n\u00e0y s\u1ebd t\u1ed1n nhi\u1ec1u th\u1eddi gian. L\u00fac \u0111\u00f3, b\u1ea1n n\u00ean \u00e1p d\u1ee5ng c\u00e1c ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c nh\u01b0 ch\u1ecdn nhi\u1ec1u h\u1ed9p ki\u1ec3m c\u00f9ng l\u00fac ho\u1eb7c s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Go To Special \u0111\u1ec3 x\u00f3a nhanh h\u01a1n.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">X\u00f3a nhi\u1ec1u Checkbox c\u00f9ng l\u00fac<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi b\u1ea1n c\u1ea7n lo\u1ea1i b\u1ecf nhi\u1ec1u h\u1ed9p ki\u1ec3m trong c\u00f9ng m\u1ed9t b\u1ea3ng, vi\u1ec7c x\u00f3a th\u1ee7 c\u00f4ng t\u1eebng c\u00e1i m\u1ed9t s\u1ebd m\u1ea5t r\u1ea5t nhi\u1ec1u th\u1eddi gian. Thay v\u00e0o \u0111\u00f3, Excel cho ph\u00e9p b\u1ea1n ch\u1ecdn nhi\u1ec1u h\u1ed9p ki\u1ec3m c\u00f9ng l\u00fac \u0111\u1ec3 x\u00f3a ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch l\u00e0m r\u1ea5t \u0111\u01a1n gi\u1ea3n: nh\u1ea5n gi\u1eef ph\u00edm Ctrl, sau \u0111\u00f3 l\u1ea7n l\u01b0\u1ee3t click v\u00e0o c\u00e1c h\u1ed9p ki\u1ec3m c\u1ea7n x\u00f3a. Khi \u0111\u00e3 ch\u1ecdn xong, ch\u1ec9 c\u1ea7n nh\u1ea5n ph\u00edm Delete l\u00e0 to\u00e0n b\u1ed9 h\u1ed9p ki\u1ec3m s\u1ebd bi\u1ebfn m\u1ea5t. Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y h\u1eefu \u00edch trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n ch\u1ec9 mu\u1ed1n lo\u1ea1i b\u1ecf m\u1ed9t nh\u00f3m h\u1ed9p ki\u1ec3m nh\u1ea5t \u0111\u1ecbnh, thay v\u00ec to\u00e0n b\u1ed9 tr\u00ean b\u1ea3ng t\u00ednh.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-20.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-20-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-20-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492552 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-20.jpg\" alt=\"Checkbox-20\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-20.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-20-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-20-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">M\u1ed9t c\u00e1ch kh\u00e1c nhanh h\u01a1n l\u00e0 d\u00f9ng c\u00f4ng c\u1ee5 Selection Pane. B\u1ea1n c\u00f3 th\u1ec3 m\u1edf t\u00ednh n\u0103ng n\u00e0y b\u1eb1ng c\u00e1ch v\u00e0o tab Home \u2192 Find &amp; Select \u2192 Selection Pane. T\u1ea1i \u0111\u00e2y, Excel hi\u1ec3n th\u1ecb danh s\u00e1ch t\u1ea5t c\u1ea3 \u0111\u1ed1i t\u01b0\u1ee3ng trong trang t\u00ednh, bao g\u1ed3m c\u00e1c h\u1ed9p ki\u1ec3m. B\u1ea1n ch\u1ec9 vi\u1ec7c ch\u1ecdn nhi\u1ec1u h\u1ed9p ki\u1ec3m trong danh s\u00e1ch v\u00e0 nh\u1ea5n Delete.\u00a0<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">X\u00f3a t\u1ea5t c\u1ea3 Checkbox tr\u00ean trang Excel<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u1ea7n d\u1ecdn s\u1ea1ch to\u00e0n b\u1ed9 h\u1ed9p ki\u1ec3m tr\u00ean m\u1ed9t sheet \u0111\u1ec3 b\u1eaft \u0111\u1ea7u thi\u1ebft k\u1ebf l\u1ea1i b\u1ea3ng t\u00ednh ho\u1eb7c thay \u0111\u1ed5i ph\u01b0\u01a1ng ph\u00e1p qu\u1ea3n l\u00fd d\u1eef li\u1ec7u. Excel cung c\u1ea5p m\u1ed9t c\u00e1ch r\u1ea5t nhanh \u0111\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y th\u00f4ng qua c\u00f4ng c\u1ee5 Go To Special.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">C\u00e1ch l\u00e0m c\u1ee5 th\u1ec3: tr\u01b0\u1edbc ti\u00ean, b\u1ea1n v\u00e0o tab Home \u2192 Editing \u2192 Find &amp; Select \u2192 Go To Special. Trong c\u1eeda s\u1ed5 v\u1eeba m\u1edf, ch\u1ecdn t\u00f9y ch\u1ecdn Objects, sau \u0111\u00f3 nh\u1ea5n OK.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-21.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-21-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-21-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492553 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-21.jpg\" alt=\"Checkbox-21\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-21.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-21-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-21-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u00fac n\u00e0y, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng ch\u1ecdn t\u1ea5t c\u1ea3 \u0111\u1ed1i t\u01b0\u1ee3ng trong trang t\u00ednh, bao g\u1ed3m h\u1ed9p ki\u1ec3m , n\u00fat b\u1ea5m ho\u1eb7c h\u00ecnh v\u1ebd. Khi to\u00e0n b\u1ed9 \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn, ch\u1ec9 c\u1ea7n nh\u1ea5n ph\u00edm Delete l\u00e0 t\u1ea5t c\u1ea3 h\u1ed9p ki\u1ec3m tr\u00ean sheet s\u1ebd b\u1ecb x\u00f3a s\u1ea1ch.<\/span><\/p>\n<p style=\"text-align: justify;\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-22.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-22-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/09\/Checkbox-22-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-492554 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-22.jpg\" alt=\"Checkbox-22\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-22.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-22-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox-22-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-weight: 400;\">L\u1eddi k\u1ebft<\/span><\/h2>\n<p style=\"text-align: justify;\"><b>Checkbox <\/b><span style=\"font-weight: 400;\">trong Excel kh\u00f4ng ch\u1ec9 \u0111\u01a1n thu\u1ea7n l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 \u0111\u00e1nh d\u1ea5u m\u00e0 c\u00f2n l\u00e0 tr\u1ee3 th\u1ee7 \u0111\u1eafc l\u1ef1c trong vi\u1ec7c qu\u1ea3n l\u00fd c\u00f4ng vi\u1ec7c, theo d\u00f5i ti\u1ebfn \u0111\u1ed9 v\u00e0 th\u1ed1ng k\u00ea d\u1eef li\u1ec7u. Khi bi\u1ebft c\u00e1ch t\u1ea1o, ch\u1ec9nh s\u1eeda, \u0111\u1ebfm v\u00e0 x\u00f3a h\u1ed9p ki\u1ec3m, b\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng bi\u1ebfn b\u1ea3ng t\u00ednh tr\u1edf th\u00e0nh m\u1ed9t h\u1ec7 th\u1ed1ng l\u00e0m vi\u1ec7c khoa h\u1ecdc, tr\u1ef1c quan v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n. Hy v\u1ecdng r\u1eb1ng v\u1edbi h\u01b0\u1edbng d\u1eabn chi ti\u1ebft trong b\u00e0i vi\u1ebft, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 t\u1ef1 tin \u00e1p d\u1ee5ng h\u1ed9p ki\u1ec3m m\u1ed9t c\u00e1ch linh ho\u1ea1t, t\u1eeb \u0111\u00f3 n\u00e2ng cao k\u1ef9 n\u0103ng s\u1eed d\u1ee5ng Excel ph\u1ee5c v\u1ee5 c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp.<\/span><\/p>\n<p style=\"text-align: justify;\"><strong>XEM TH\u00caM:<\/strong><\/p>\n<p><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-loc-trung-excel\/\">C\u00e1ch l\u1ecdc tr\u00f9ng trong Excel nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 cho m\u1ecdi t\u00ecnh hu\u1ed1ng<\/a><\/strong><\/p>\n<p><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/co-dinh-dong-trong-excel\/\">C\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng, c\u1ed9t trong Excel nhanh ch\u00f3ng b\u1eb1ng Freeze Panes<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi Excel, ch\u1eafc h\u1eb3n b\u1ea1n \u0111\u00e3 nhi\u1ec1u l\u1ea7n c\u1ea7n m\u1ed9t c\u00f4ng c\u1ee5 \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u, qu\u1ea3n l\u00fd c\u00f4ng vi\u1ec7c ho\u1eb7c t\u1ea1o danh s\u00e1ch ki\u1ec3m tra. Thay v\u00ec ch\u1ec9 nh\u00ecn v\u00e0o d\u1eef li\u1ec7u kh\u00f4 khan, Checkbox cho ph\u00e9p b\u1ea1n \u0111\u00e1nh d\u1ea5u nhanh c\u00e1c m\u1ee5c \u0111\u00e3 ho\u00e0n th\u00e0nh, ph\u00e2n lo\u1ea1i tr\u1ea1ng th\u00e1i [&hellip;]<\/p>\n","protected":false},"author":65,"featured_media":492532,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-492531","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch t\u1ea1o Checkbox (h\u1ed9p ki\u1ec3m) nhanh ch\u00f3ng trong Excel<\/title>\n<meta name=\"description\" content=\"Ho\u00e0ng H\u00e0 Mobile h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch t\u1ea1o, ch\u1ec9nh s\u1eeda, \u0111\u1ebfm v\u00e0 x\u00f3a Checkbox trong Excel, gi\u00fap b\u1ea1n t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch t\u1ea1o Checkbox (h\u1ed9p ki\u1ec3m) nhanh ch\u00f3ng trong Excel\" \/>\n<meta property=\"og:description\" content=\"Ho\u00e0ng H\u00e0 Mobile h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch t\u1ea1o, ch\u1ec9nh s\u1eeda, \u0111\u1ebfm v\u00e0 x\u00f3a Checkbox trong Excel, gi\u00fap b\u1ea1n t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-23T01:14:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vo Giang\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vo Giang\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"19 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/\"},\"author\":{\"name\":\"Vo Giang\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/802cf8334532d8295c39f79a4d9ab629\"},\"headline\":\"C\u00e1ch t\u1ea1o Checkbox (h\u1ed9p ki\u1ec3m) nhanh ch\u00f3ng trong Excel\",\"datePublished\":\"2025-09-23T01:14:40+00:00\",\"dateModified\":\"2025-09-23T01:14:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/\"},\"wordCount\":4057,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/\",\"name\":\"C\u00e1ch t\u1ea1o Checkbox (h\u1ed9p ki\u1ec3m) nhanh ch\u00f3ng trong Excel\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox.jpg\",\"datePublished\":\"2025-09-23T01:14:40+00:00\",\"dateModified\":\"2025-09-23T01:14:40+00:00\",\"description\":\"Ho\u00e0ng H\u00e0 Mobile h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch t\u1ea1o, ch\u1ec9nh s\u1eeda, \u0111\u1ebfm v\u00e0 x\u00f3a Checkbox trong Excel, gi\u00fap b\u1ea1n t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox.jpg\",\"width\":1200,\"height\":628,\"caption\":\"Checkbox\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch t\u1ea1o Checkbox (h\u1ed9p ki\u1ec3m) nhanh ch\u00f3ng trong Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/802cf8334532d8295c39f79a4d9ab629\",\"name\":\"Vo Giang\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/ee51d05cd327d88ac9efc5322092d37c.jpg?ver=1775469967\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/ee51d05cd327d88ac9efc5322092d37c.jpg?ver=1775469967\",\"caption\":\"Vo Giang\"},\"description\":\"M\u00ecnh l\u00e0 Giang, m\u1ed9t ng\u01b0\u1eddi k\u1ec3 chuy\u1ec7n c\u00f4ng ngh\u1ec7, ch\u1ecdn c\u00e1ch tr\u1ea3i nghi\u1ec7m v\u00e0 chia s\u1ebb nh\u1eefng gi\u1ea3i ph\u00e1p th\u1ef1c t\u1ebf. V\u1edbi m\u00ecnh, m\u1ed9t thi\u1ebft b\u1ecb t\u1ed1t ch\u1ec9 khi n\u00f3 th\u1ef1c s\u1ef1 l\u00e0m cho cu\u1ed9c s\u1ed1ng h\u00e0ng ng\u00e0y c\u1ee7a b\u1ea1n tr\u1edf n\u00ean d\u1ec5 d\u00e0ng v\u00e0 th\u00fa v\u1ecb h\u01a1n.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/giang-vo\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch t\u1ea1o Checkbox (h\u1ed9p ki\u1ec3m) nhanh ch\u00f3ng trong Excel","description":"Ho\u00e0ng H\u00e0 Mobile h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch t\u1ea1o, ch\u1ec9nh s\u1eeda, \u0111\u1ebfm v\u00e0 x\u00f3a Checkbox trong Excel, gi\u00fap b\u1ea1n t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch t\u1ea1o Checkbox (h\u1ed9p ki\u1ec3m) nhanh ch\u00f3ng trong Excel","og_description":"Ho\u00e0ng H\u00e0 Mobile h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch t\u1ea1o, ch\u1ec9nh s\u1eeda, \u0111\u1ebfm v\u00e0 x\u00f3a Checkbox trong Excel, gi\u00fap b\u1ea1n t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-09-23T01:14:40+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox.jpg","type":"image\/jpeg"}],"author":"Vo Giang","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Vo Giang","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"19 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/"},"author":{"name":"Vo Giang","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/802cf8334532d8295c39f79a4d9ab629"},"headline":"C\u00e1ch t\u1ea1o Checkbox (h\u1ed9p ki\u1ec3m) nhanh ch\u00f3ng trong Excel","datePublished":"2025-09-23T01:14:40+00:00","dateModified":"2025-09-23T01:14:40+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/"},"wordCount":4057,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/","name":"C\u00e1ch t\u1ea1o Checkbox (h\u1ed9p ki\u1ec3m) nhanh ch\u00f3ng trong Excel","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox.jpg","datePublished":"2025-09-23T01:14:40+00:00","dateModified":"2025-09-23T01:14:40+00:00","description":"Ho\u00e0ng H\u00e0 Mobile h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch t\u1ea1o, ch\u1ec9nh s\u1eeda, \u0111\u1ebfm v\u00e0 x\u00f3a Checkbox trong Excel, gi\u00fap b\u1ea1n t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/09\/Checkbox.jpg","width":1200,"height":628,"caption":"Checkbox"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/checkbox\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch t\u1ea1o Checkbox (h\u1ed9p ki\u1ec3m) nhanh ch\u00f3ng trong Excel"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/802cf8334532d8295c39f79a4d9ab629","name":"Vo Giang","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/ee51d05cd327d88ac9efc5322092d37c.jpg?ver=1775469967","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/ee51d05cd327d88ac9efc5322092d37c.jpg?ver=1775469967","caption":"Vo Giang"},"description":"M\u00ecnh l\u00e0 Giang, m\u1ed9t ng\u01b0\u1eddi k\u1ec3 chuy\u1ec7n c\u00f4ng ngh\u1ec7, ch\u1ecdn c\u00e1ch tr\u1ea3i nghi\u1ec7m v\u00e0 chia s\u1ebb nh\u1eefng gi\u1ea3i ph\u00e1p th\u1ef1c t\u1ebf. V\u1edbi m\u00ecnh, m\u1ed9t thi\u1ebft b\u1ecb t\u1ed1t ch\u1ec9 khi n\u00f3 th\u1ef1c s\u1ef1 l\u00e0m cho cu\u1ed9c s\u1ed1ng h\u00e0ng ng\u00e0y c\u1ee7a b\u1ea1n tr\u1edf n\u00ean d\u1ec5 d\u00e0ng v\u00e0 th\u00fa v\u1ecb h\u01a1n.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/giang-vo\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/492531","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/65"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=492531"}],"version-history":[{"count":3,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/492531\/revisions"}],"predecessor-version":[{"id":492674,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/492531\/revisions\/492674"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/492532"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=492531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=492531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=492531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}