{"id":7523,"date":"2024-12-21T17:54:12","date_gmt":"2024-12-21T17:54:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-xoa-tat-ca-cac-dong-trong-trong-file-excel-co-nhieu-dong\/"},"modified":"2024-12-21T17:54:12","modified_gmt":"2024-12-21T17:54:12","slug":"huong-dan-xoa-tat-ca-cac-dong-trong-trong-file-excel-co-nhieu-dong","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-xoa-tat-ca-cac-dong-trong-trong-file-excel-co-nhieu-dong\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn xo\u00e1 t\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng tr\u1ed1ng trong file excel c\u00f3 nhi\u1ec1u d\u00f2ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i bi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> <\/strong>s\u1ebd gi\u1ea3i th\u00edch t\u1ea1i sao c\u1ea7n x\u00f3a nh\u1eefng h\u00e0ng tr\u1ed1ng trong b\u1ea3ng t\u00ednh, \u0111\u1ed3ng th\u1eddi h\u01b0\u1edbng d\u1eabn b\u1ea1n nh\u1eefng c\u00e1ch nhanh v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t \u0111\u1ec3 lo\u1ea1i b\u1ecf h\u00e0ng tr\u1ed1ng m\u00e0 kh\u00f4ng l\u00e0m h\u1ecfng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-rows-excel.png\" alt=\"3 quick and correct ways to remove blank rows in Excel\" title=\"remove-rows-excel\"><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-676700c3e2a47\" 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\/huong-dan-xoa-tat-ca-cac-dong-trong-trong-file-excel-co-nhieu-dong.html#Dung_bao_gio_xoa_hang_trong_bang_cach_chon_nhung_o_trong\" title=\"\u0110\u1eebng bao gi\u1edd x\u00f3a h\u00e0ng tr\u1ed1ng b\u1eb1ng c\u00e1ch ch\u1ecdn nh\u1eefng \u00f4 tr\u1ed1ng:\">\u0110\u1eebng bao gi\u1edd x\u00f3a h\u00e0ng tr\u1ed1ng b\u1eb1ng c\u00e1ch ch\u1ecdn nh\u1eefng \u00f4 tr\u1ed1ng:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-xoa-tat-ca-cac-dong-trong-trong-file-excel-co-nhieu-dong.html#Xoa_hang_trong_thong_qua_cot_chinh\" title=\"X\u00f3a h\u00e0ng tr\u1ed1ng th\u00f4ng qua c\u1ed9t ch\u00ednh:\">X\u00f3a h\u00e0ng tr\u1ed1ng th\u00f4ng qua c\u1ed9t ch\u00ednh:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-xoa-tat-ca-cac-dong-trong-trong-file-excel-co-nhieu-dong.html#Xoa_hang_trong_khi_bang_du_lieu_khong_co_cot_chinh\" title=\"X\u00f3a h\u00e0ng tr\u1ed1ng khi b\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng c\u00f3 c\u1ed9t ch\u00ednh:\">X\u00f3a h\u00e0ng tr\u1ed1ng khi b\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng c\u00f3 c\u1ed9t ch\u00ednh:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-xoa-tat-ca-cac-dong-trong-trong-file-excel-co-nhieu-dong.html#Xoa_Dong_Trong_trong_Excel_su_dung_ham_Filter\" title=\"X\u00f3a D\u00f2ng Tr\u1ed1ng trong Excel s\u1eed d\u1ee5ng h\u00e0m Filter\">X\u00f3a D\u00f2ng Tr\u1ed1ng trong Excel s\u1eed d\u1ee5ng h\u00e0m Filter<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dung_bao_gio_xoa_hang_trong_bang_cach_chon_nhung_o_trong\"><\/span><strong>\u0110\u1eebng bao gi\u1edd x\u00f3a h\u00e0ng tr\u1ed1ng b\u1eb1ng c\u00e1ch ch\u1ecdn nh\u1eefng \u00f4 tr\u1ed1ng:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00ecm \u0111\u01b0\u1ee3c nh\u1eefng ph\u01b0\u01a1ng ph\u00e1p x\u00f3a h\u00e0ng tr\u1ed1ng sau \u0111\u00e2y:<\/p>\n<p>B\u01b0\u1edbc 1: Ch\u1ecdn to\u00e0n b\u1ed9 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n<\/p>\n<p>B\u01b0\u1edbc 2: Nh\u1ea5n <strong><em>F5<\/em><\/strong>, h\u1ed9p tho\u1ea1i <strong><em>Go To<\/em><\/strong> xu\u1ea5t hi\u1ec7n.<\/p>\n<p>B\u01b0\u1edbc 3: Nh\u1ea5n n\u00fat <em><strong>Special<\/strong>\u2026<\/em> trong h\u1ed9p tho\u1ea1i.<\/p>\n<p>B\u01b0\u1edbc 4: Trong h\u1ed9p tho\u1ea1i <strong><em>Go to special<\/em><\/strong>, ch\u1ecdn n\u00fat<strong><em> Blanks <\/em><\/strong>v\u00e0 nh\u1ea5n <strong>OK.<\/strong><\/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-303.gif\" title=\"vba101_92019-nho-303\"><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-675.gif\" title=\"ex101_92019-nho-675\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>B\u01b0\u1edbc 5: Nh\u1ea5p ph\u1ea3i v\u00e0o b\u1ea5t k\u1ef3 \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0o v\u00e0 ch\u1ecdn <strong><em>Delete\u2026<\/em>.<\/strong><\/p>\n<p>B\u01b0\u1edbc 6: Trong h\u1ed9p tho\u1ea1i <strong><em>Delete<\/em>,<\/strong> ch\u1ecdn <strong><em>Entire row<\/em> <\/strong>v\u00e0 nh\u1ea5p v\u00e0o<strong> <em>Entire row<\/em>.<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 m\u1ed9t c\u00e1ch r\u1ea5t d\u1edf, ch\u1ec9 s\u1eed d\u1ee5ng cho b\u1ea3ng bi\u1ec3u \u0111\u01a1n gi\u1ea3n g\u1ed3m v\u00e0i h\u00e0ng v\u00e0 th\u1eadm ch\u00ed, <strong>\u0111\u1eebng bao gi\u1edd s\u1eed d\u1ee5ng c\u00e1ch n\u00e0y<\/strong>.<\/p>\n<p style=\"text-align: justify\">Nguy\u00ean nh\u00e2n gi\u1ea3i th\u00edch cho vi\u1ec7c n\u00e0y l\u00e0 <strong>n\u1ebfu h\u00e0ng ch\u1ee9a d\u1eef li\u1ec7u quan tr\u1ecdng nh\u01b0ng c\u00f3 m\u1ed9t \u00f4 tr\u1ed1ng, to\u00e0n b\u1ed9 h\u00e0ng v\u1eabn b\u1ecb x\u00f3a b\u1ecf<\/strong>.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, t\u00f4i c\u00f3 b\u1ea3ng danh s\u00e1ch kh\u00e1ch h\u00e0ng sau, g\u1ed3m 6 h\u00e0ng. T\u00f4i mu\u1ed1n x\u00f3a h\u00e0ng 3 v\u00e0 5 v\u00ec ch\u00fang r\u1ed7ng.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/table-with-blank-rows.png\" alt=\"We want to remove rows 3 and 5 because they are empty\" title=\"table-with-blank-rows\"><\/p>\n<p style=\"text-align: justify\">Th\u1ef1c hi\u1ec7n theo c\u00e1c thao t\u00e1c tr\u00ean v\u00e0 k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-removed-with-blank-rows.png\" alt=\"Row 4 (Roger) is also gone because cell D4 in the\" title=\"data-removed-with-blank-rows\"><\/p>\n<p style=\"text-align: center\">H\u00e0ng 4 (Roger) \u0111\u00e3 b\u1ecb x\u00f3a v\u00ec \u00f4 D4 trong c\u1ed9t \u2018Traffic source\u2019 b\u1ecb r\u1ed7ng<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Xoa_hang_trong_thong_qua_cot_chinh\"><\/span><strong>X\u00f3a h\u00e0ng tr\u1ed1ng th\u00f4ng qua c\u1ed9t ch\u00ednh:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y c\u00f3 hi\u1ec7u qu\u1ea3 n\u1ebfu c\u00f3 m\u1ed9t c\u1ed9t trong b\u1ea3ng c\u1ee7a b\u1ea1n gi\u00fap quy\u1ebft \u0111\u1ecbnh r\u1eb1ng h\u00e0ng \u0111\u00f3 c\u00f3 tr\u1ed1ng hay kh\u00f4ng (c\u1ed9t ch\u00ednh). V\u00ed d\u1ee5, \u0111\u00f3 c\u00f3 th\u1ec3 l\u00e0 c\u1ed9t \u2018customer ID\u2019 ho\u1eb7c \u2018order number\u2019\u2026<\/p>\n<p style=\"text-align: justify\">Vi\u1ec7c gi\u1eef th\u1ee9 t\u1ef1 cho c\u00e1c h\u00e0ng r\u1ea5t quan tr\u1ecdng, v\u1eady ch\u00fang ta kh\u00f4ng n\u00ean s\u1eafp x\u1ebfp c\u00e1c h\u00e0ng tr\u1ed1ng xu\u1ed1ng d\u01b0\u1edbi c\u00f9ng b\u1ea3ng d\u1eef li\u1ec7u th\u00f4ng qua c\u1ed9t \u0111\u00f3.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng d\u1eef li\u1ec7u (nh\u1ea5n <strong><em>Ctrl + Home<\/em><\/strong>, ho\u1eb7c<strong><em> Ctrl + Shift +End<\/em><\/strong>)<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/table-with-key-column.png\" alt=\"Select the whole table\" title=\"table-with-key-column\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Th\u00eam <strong><em>AutoFilter <\/em><\/strong>v\u00e0o b\u1ea3ng, di chuy\u1ec3n \u0111\u1ebfn th\u1ebb <strong><em>Data <\/em><\/strong>v\u00e0 nh\u1ea5p n\u00fat <strong><em>Filter.<\/em><\/strong><strong><em>\u00a0<\/em><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong><em><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5821\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-82.png\" width=\"600\" height=\"336\" title=\"excel-dialog-box-launcher-1-82\"><\/em><\/strong><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>\u00c1p d\u1ee5ng n\u00fat l\u1ecdc v\u00e0o c\u1ed9t \u2018Cust#\u2019: nh\u1ea5p v\u00e0o m\u0169i t\u00ean trong ti\u00eau \u0111\u1ec1 c\u1ed9t, b\u1ecf ch\u1ecdn <strong><em>Select All<\/em><\/strong>, l\u0103n thanh cu\u1ed1n xu\u1ed1ng cu\u1ed1i danh s\u00e1ch v\u00e0 \u0111\u00e1nh d\u1ea5u ch\u1ecdn <strong><em>Blanks. <\/em><\/strong>Nh\u1ea5n OK.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/filter-blank-rows-only.png\" alt=\"Excel Autofilter: show empty rows only\" title=\"filter-blank-rows-only\"><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng \u0111\u01b0\u1ee3c l\u1ecdc: nh\u1ea5n <strong><em>Ctrl + Home<\/em><\/strong>, nh\u1ea5n ph\u00edm m\u0169i t\u00ean \u00e2 \u0111\u1ec3 di chuy\u1ec3n \u0111\u1ebfn h\u00e0ng \u0111\u1ea7u ti\u00ean, sau \u0111\u00f3 nh\u1ea5n <strong><em>Ctrl + Shift + End<\/em><\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-filtered-rows.png\" alt=\"Select all the filtered rows\" title=\"select-filtered-rows\"><\/p>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>Nh\u1ea5p ph\u1ea3i v\u00e0o b\u1ea5t k\u1ef3 \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn n\u00e0o v\u00e0 ch\u1ecdn <strong><em>Delete row <\/em><\/strong>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn, ho\u1eb7c ch\u1ec9 nh\u1ea5n <strong><em>Ctrl + \u2013<\/em><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/delete-blank-row.png\" alt=\"Right-click on any selected cell and choose Delete row\" title=\"delete-blank-row\"><\/em><\/strong><\/p>\n<ol style=\"text-align: justify\" start=\"6\">\n<li>Nh\u1ea5n v\u00e0o n\u00fat <strong>OK <\/strong>trong h\u1ed9p tho\u1ea1i \u201c<strong><em>Delete entire sheet row?<\/em><\/strong>\u201d.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/confirm-removing-blank-rows.png\" alt=\"Delete entire sheet row dialog box\" title=\"confirm-removing-blank-rows\"><\/p>\n<ol style=\"text-align: justify\" start=\"7\">\n<li>B\u1ecf n\u00fat l\u1ecdc: di chuy\u1ec3n \u0111\u1ebfn th\u1ebb <strong><em>Data <\/em><\/strong>v\u00e0 nh\u1ea5n n\u00fat <strong><em>Clear<\/em><\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5822\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-83.png\" width=\"600\" height=\"247\" title=\"excel-dialog-box-launcher-1-83\"><\/p>\n<ol style=\"text-align: justify\" start=\"8\">\n<li>T\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng tr\u1ed1ng \u0111\u1ec1u \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf nh\u01b0ng d\u00f2ng 3 (Roger) v\u1eabn \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/all-blank-rows-deleted.png\" alt=\"All the blank rows are completely removed\" title=\"all-blank-rows-deleted\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">Kho\u0301a ho\u0323c l\u00e2\u0323p tri\u0300nh VBA trong excel<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Xoa_hang_trong_khi_bang_du_lieu_khong_co_cot_chinh\"><\/span><strong>X\u00f3a h\u00e0ng tr\u1ed1ng khi b\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng c\u00f3 c\u1ed9t ch\u00ednh:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 nhi\u1ec1u \u00f4 tr\u1ed1ng r\u1ea3i r\u00e1c \u1edf nhi\u1ec1u c\u1ed9t kh\u00e1c nhau, nh\u01b0ng b\u1ea1n ch\u1ec9 mu\u1ed1n x\u00f3a nh\u1eefng h\u00e0ng kh\u00f4ng c\u00f3 \u00f4 ch\u1ee9a d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/blank-rows-complex-case.png\" alt=\"Excel Table with numerous empty cells scattered across different columns\" title=\"blank-rows-complex-case\"><\/p>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n kh\u00f4ng c\u00f3 c\u1ed9t ch\u00ednh \u0111\u1ec3 c\u00e2n nh\u1eafc xem h\u00e0ng \u0111\u00f3 c\u00f3 tr\u1ed1ng hay kh\u00f4ng, v\u1eady n\u00ean ch\u00fang ta ch\u00e8n th\u00eam c\u1ed9t ph\u1ee5:<\/p>\n<ol style=\"text-align: justify\">\n<li>Th\u00eam c\u1ed9t \u2018Blanks\u2019 v\u00e0o cu\u1ed1i b\u1ea3ng d\u1eef li\u1ec7u. Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t: <strong><em>=COUNTBLANK(A2:C2).<\/em><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd \u0111\u1ebfm s\u1ed1 \u00f4 tr\u1ed1ng trong v\u00f9ng d\u1eef li\u1ec7u c\u1ee5 th\u1ec3, A2 v\u00e0 C2 l\u1ea7n l\u01b0\u1ee3t l\u00e0 \u00f4 \u0111\u1ea7u v\u00e0 \u00f4 cu\u1ed1i c\u1ee7a h\u00e0ng hi\u1ec7n t\u1ea1i.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/counblank-formula.png\" alt=\"Excel formula to count blank cells in the specified range\" title=\"counblank-formula\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Sao ch\u00e9p c\u00f4ng th\u1ee9c sang to\u00e0n b\u1ed9 c\u1ed9t. M\u1eddi c\u00e1c b\u1ea1n xem th\u00eam b\u00e0i vi\u1ebft <strong><em>C\u00e1ch nh\u1eadp c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c v\u00e0o t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn c\u00f9ng l\u00fac.<\/em><\/strong><strong><em>\u00a0<\/em><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong><em><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-counblanks-all-rows.png\" alt=\"Copy the formula throughout the entire column\" title=\"copy-counblanks-all-rows\"><\/em><\/strong><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>B\u00e2y gi\u1edd ch\u00fang ta \u0111\u00e3 c\u00f3 c\u1ed9t ch\u00ednh. T\u01b0\u01a1ng t\u1ef1 nh\u01b0 ph\u1ea7n h\u01b0\u1edbng d\u1eabn tr\u01b0\u1edbc, g\u1eafn n\u00fat l\u1ecdc v\u00e0o c\u1ed9t \u2018Blanks\u2019 \u0111\u1ec3 ch\u1ec9 hi\u1ec3n th\u1ecb nh\u1eefng h\u00e0ng ch\u1ee9a gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5n (3). S\u1ed1 3 ngh\u0129a l\u00e0 t\u1ea5t c\u1ea3 \u00f4 t\u00ednh trong c\u1ed9t hi\u1ec7n t\u1ea1i \u0111\u00e3 \u0111\u01b0\u1ee3c x\u00f3a.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/filter-by-countblanks-column.png\" title=\"filter-by-countblanks-column\"><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng \u0111\u00e3 l\u1ecdc v\u00e0 x\u00f3a to\u00e0n b\u1ed9 c\u00e1c h\u00e0ng c\u00f2n l\u1ea1i nh\u01b0 \u0111\u00e3 h\u01b0\u1edbng d\u1eabn \u1edf tr\u00ean. Nh\u01b0 v\u1eady, h\u00e0ng 5 b\u1ecb x\u00f3a c\u00f2n t\u1ea5t c\u1ea3 nh\u1eefng h\u00e0ng c\u00f2n l\u1ea1i (ch\u1ee9a v\u00e0 kh\u00f4ng ch\u1ee9a \u00f4 tr\u1ed1ng) \u0111\u1ec1u \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/table-without-blank-rows.png\" alt=\"Empty row (row 5) is deleted\" title=\"table-without-blank-rows\"><\/p>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>X\u00f3a c\u1ed9t ph\u1ee5. Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 g\u1eafn n\u00fat l\u1ecdc m\u1edbi v\u00e0o c\u1ed9t n\u00e0y \u0111\u1ec3 hi\u1ec3n th\u1ecb nh\u1eefng h\u00e0ng ch\u1ee9a m\u1ed9t ho\u1eb7c nhi\u1ec1u h\u01a1n m\u1ed9t \u00f4 tr\u1ed1ng.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y, b\u1ecf ch\u1ecdn \u201c0\u201d v\u00e0 nh\u1ea5n OK.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/filter-by-helper-column.png\" alt=\"uncheck the\" title=\"filter-by-helper-column\"><\/p>\n<p style=\"text-align: justify\"><strong>Ngu\u1ed3n<\/strong>: Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi blog.hocexcel.online<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Xoa_Dong_Trong_trong_Excel_su_dung_ham_Filter\"><\/span>X\u00f3a D\u00f2ng Tr\u1ed1ng trong Excel s\u1eed d\u1ee5ng h\u00e0m Filter<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_31651\" aria-describedby=\"caption-attachment-31651\" style=\"width: 2034px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/ham-filter-loc-ra-dong-co-du-lieu-day-du.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31651\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-filter-loc-ra-dong-co-du-lieu-day-du-1.png\" alt=\"H\u00e0m Filter l\u1ecdc b\u1ecf d\u00f2ng c\u00f3 d\u1eef li\u1ec7u tr\u1ed1ng\" width=\"2034\" height=\"984\" title=\"ham-filter-loc-ra-dong-co-du-lieu-day-du-1\"><\/a><figcaption id=\"caption-attachment-31651\" class=\"wp-caption-text\">H\u00e0m Filter l\u1ecdc b\u1ecf d\u00f2ng c\u00f3 d\u1eef li\u1ec7u tr\u1ed1ng<\/figcaption><\/figure>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta c\u1ea7n ph\u1ea3i lo\u1ea1i b\u1ecf nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u c\u00f3 \u00edt nh\u1ea5t 1 \u00f4 tr\u1ed1ng ho\u1eb7c ch\u00fang ta ch\u1ec9 gi\u1eef l\u1ea1i nh\u1eefng d\u00f2ng d\u1eef li\u1ec7u m\u00e0 c\u1ea3 3 c\u1ed9t B, C, D \u0111\u01b0\u1ee3c \u0111i\u1ec1n \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin. Vi\u1ec7c n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n r\u1ea5t nhanh ch\u00f3ng v\u00e0 ti\u1ec7n l\u1ee3i b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m FILTER. C\u00f4ng th\u1ee9c t\u01b0\u01a1ng \u1ee9ng v\u1edbi tr\u01b0\u1eddng h\u1ee3p tr\u00ean l\u00e0:<\/p>\n<p><code class=\"excel-formula\">=FILTER(B5:D13,(B5:B13&lt;&gt;\"\")*(C5:C13&lt;&gt;\"\")*(D5:D13&lt;&gt;\"\"),\"Kh\u00f4ng t\u00ecm th\u1ea5y\")<\/code><\/p>\n<p>Nh\u01b0 v\u1eady, \u0111\u1ec3 hi\u1ec3u c\u00f4ng th\u1ee9c tr\u00ean, b\u1ea1n c\u1ea7n hi\u1ec3u h\u00e0m FILTER ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o, v\u00e0 c\u1ee5 th\u1ec3 l\u00e0 ph\u1ea7n v\u00f9ng \u0111i\u1ec1u ki\u1ec7n <code class=\"excel-formula\">(B5:B13&lt;&gt;\"\")*(C5:C13&lt;&gt;\"\")*(D5:D13&lt;&gt;\"\")<\/code> ngh\u0129a l\u00e0 g\u00ec. M\u1ed7i c\u1ee5m <code class=\"excel-formula\">(B5:B13&lt;&gt;\"\")<\/code> s\u1ebd so s\u00e1nh l\u1ea7n l\u01b0\u1ee3t c\u00e1c \u00f4 trong v\u00f9ng B5:B13 v\u1edbi \u201c\u201d, vi\u1ec7c so s\u00e1nh n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 1 m\u1ea3ng c\u00e1c gi\u00e1 tr\u1ecb TRUE \/ FALSE. Khi nh\u00e2n 3 m\u1ea3ng gi\u00e1 tr\u1ecb TRUE \/ FALSE n\u00e0y v\u1edbi nhau th\u00ec Excel s\u1ebd hi\u1ec3u \u0111i\u1ec1u ki\u1ec7n l\u00e0 ch\u1ecdn ra nh\u1eefng d\u00f2ng m\u00e0 c\u1ed9t B kh\u00f4ng r\u1ed7ng <strong>V\u00c0\u00a0<\/strong>c\u1ed9t C kh\u00f4ng r\u1ed7ng\u00a0<strong>V\u00c0\u00a0<\/strong>c\u1ed9t D kh\u00f4ng r\u1ed7ng.<\/p>\n<p>B\u1ea1n c\u00f3 g\u1eb7p kh\u00f3 kh\u0103n trong vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m c\u1ee7a Excel kh\u00f4ng?\u00a0Mu\u1ed1n hi\u1ec3u r\u00f5 v\u1ec1 c\u00e1c h\u00e0m trong Excel, s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Trong kh\u00f3a h\u1ecdc n\u00e0y b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u1ecdc c\u00e1c ki\u1ebfn th\u1ee9c v\u1ec1 c\u00e1ch\u00a0vi\u1ebft\u00a0c\u00e1c h\u00e0m t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao, c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 trong Excel, s\u1eed d\u1ee5ng PivotTable, v\u1ebd bi\u1ec3u \u0111\u1ed3\u2026 r\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c h\u1eefu \u00edch v\u00e0 c\u1ea7n thi\u1ebft trong c\u00f4ng vi\u1ec7c h\u00e0ng n\u00e0y.<\/p>\n<p>M\u1ed9t \u0111i\u1ec1u h\u1ea5p d\u1eabn n\u1eefa l\u00e0 hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i cho b\u1ea1n khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y.<\/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-303.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7524,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7523","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7523","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=7523"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7523\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7524"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}