{"id":9471,"date":"2025-01-02T08:15:15","date_gmt":"2025-01-02T08:15:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-xoa-nhung-o-co-so-0-va-don-du-lieu-sang-trai-trong-excel\/"},"modified":"2025-01-02T08:15:15","modified_gmt":"2025-01-02T08:15:15","slug":"huong-dan-cach-xoa-nhung-o-co-so-0-va-don-du-lieu-sang-trai-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-xoa-nhung-o-co-so-0-va-don-du-lieu-sang-trai-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00f3a nh\u1eefng \u00f4 c\u00f3 s\u1ed1 0 v\u00e0 d\u1ed3n d\u1eef li\u1ec7u sang tr\u00e1i trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>\u0110\u00f4i khi nh\u1eefng k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 0 khi\u1ebfn b\u1ea1n kh\u00f3 theo d\u00f5i k\u1ebft qu\u1ea3 trong c\u00e1c b\u1ea3ng t\u00ednh. L\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 x\u00f3a nh\u1eefng\u00a0\u00f4 c\u00f3 s\u1ed1 0 v\u00e0 d\u1ed3n nh\u1eefng\u00a0\u00f4 c\u00f3 d\u1eef li\u1ec7u sang tr\u00e1i, trong khi\u00a0\u0111\u00f3 v\u1eabn gi\u1eef\u00a0\u0111\u01b0\u1ee3c v\u1ecb tr\u00ed nh\u1eefng\u00a0\u00f4 kh\u00e1c? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u n\u1ed9i dung n\u00e0y c\u00f9ng H\u1ecdc\u00a0Excel Online nh\u00e9:<\/p>\n<p>\u0110\u1ec3 gi\u00fap c\u00e1c b\u1ea1n d\u1ec5 h\u00ecnh dung y\u00eau c\u1ea7u n\u00e0y, ch\u00fang ta x\u00e9t v\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24230\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/yeu-cau-xoa-so-0-trong-o.png\" width=\"596\" height=\"293\" title=\"yeu-cau-xoa-so-0-trong-o\"><\/p>\n<p>Trong b\u1ea3ng\u00a0\u0111\u1ec1 b\u00e0i, v\u00f9ng B2:F5 g\u1ed3m c\u00e1c s\u1ed1, trong\u00a0\u0111\u00f3 c\u00f3 nh\u1eefng\u00a0\u00f4 ch\u1ee9a s\u1ed1 0. Y\u00eau c\u1ea7u l\u00e0 ch\u00fang ta ph\u1ea3i x\u00f3a b\u1ecf nh\u1eefng\u00a0\u00f4 c\u00f3 s\u1ed1 0 m\u00e0 kh\u00f4ng l\u00e0m\u00a0\u1ea3nh h\u01b0\u1edfng t\u1edbi nh\u1eefng d\u1eef li\u1ec7u\u00a0\u1edf c\u1ed9t G. Sau khi x\u00f3a nh\u1eefng\u00a0\u00f4 c\u00f3 s\u1ed1 0, nh\u1eefng\u00a0\u00f4 c\u00f2n l\u1ea1i s\u1ebd\u00a0\u0111\u01b0\u1ee3c d\u1ed3n l\u1ea1i v\u1ec1 b\u00ean tr\u00e1i b\u1ea3ng d\u1eef li\u1ec7u.<\/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-67764b12ad13a\" 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-cach-xoa-nhung-o-co-so-0-va-don-du-lieu-sang-trai-trong-excel.html#Cach_xoa_nhung_o_co_so_0_va_don_du_lieu_sang_trai_trong_Excel\" title=\"C\u00e1ch x\u00f3a nh\u1eefng \u00f4 c\u00f3 s\u1ed1 0 v\u00e0 d\u1ed3n d\u1eef li\u1ec7u sang tr\u00e1i trong Excel\">C\u00e1ch x\u00f3a nh\u1eefng \u00f4 c\u00f3 s\u1ed1 0 v\u00e0 d\u1ed3n d\u1eef li\u1ec7u sang tr\u00e1i trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xoa-nhung-o-co-so-0-va-don-du-lieu-sang-trai-trong-excel.html#Xoa_so_0_trong_cac_o_co_gia_tri_bang_0\" title=\"X\u00f3a s\u1ed1 0 trong c\u00e1c\u00a0\u00f4 c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng 0\">X\u00f3a s\u1ed1 0 trong c\u00e1c\u00a0\u00f4 c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng 0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xoa-nhung-o-co-so-0-va-don-du-lieu-sang-trai-trong-excel.html#Loai_bo_o_trong_va_don_o_co_gia_tri_sang_trai\" title=\"Lo\u1ea1i b\u1ecf\u00a0\u00f4 tr\u1ed1ng v\u00e0 d\u1ed3n\u00a0\u00f4 c\u00f3 gi\u00e1 tr\u1ecb sang tr\u00e1i\">Lo\u1ea1i b\u1ecf\u00a0\u00f4 tr\u1ed1ng v\u00e0 d\u1ed3n\u00a0\u00f4 c\u00f3 gi\u00e1 tr\u1ecb sang tr\u00e1i<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_xoa_nhung_o_co_so_0_va_don_du_lieu_sang_trai_trong_Excel\"><\/span>C\u00e1ch x\u00f3a nh\u1eefng \u00f4 c\u00f3 s\u1ed1 0 v\u00e0 d\u1ed3n d\u1eef li\u1ec7u sang tr\u00e1i trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Xoa_so_0_trong_cac_o_co_gia_tri_bang_0\"><\/span>X\u00f3a s\u1ed1 0 trong c\u00e1c\u00a0\u00f4 c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng 0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu ch\u00fang ta s\u1eed d\u1ee5ng c\u00e1ch Replace s\u1ed1 0 th\u00e0nh kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb n\u00e0o (xem c\u00e1ch l\u00e0m c\u1ee5 th\u1ec3 t\u1ea1i b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-xoa-nhanh-phan-van-ban-truocsau-mot-ky-tu-cu-the-trong-excel.html\">C\u00e1ch xo\u00e1 nhanh ph\u1ea7n v\u0103n b\u1ea3n tr\u01b0\u1edbc\/sau m\u1ed9t k\u00fd t\u1ef1 c\u1ee5 th\u1ec3 trong Excel<\/a>) th\u00ec c\u00f3 1 v\u1ea5n\u00a0\u0111\u1ec1 l\u00e0 s\u1ed1 0 c\u00f2n xu\u1ea5t hi\u1ec7n c\u1ea3\u00a0\u1edf nh\u1eefng v\u1ecb tr\u00ed c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 0 (nh\u01b0\u00a0\u00f4 B3 c\u00f3 gi\u00e1 tr\u1ecb 400 g\u1ed3m 2 s\u1ed1 0)<\/p>\n<p>Do\u00a0\u0111\u00f3 c\u00e1ch l\u00e0m trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ph\u1ea3i x\u00e9t to\u00e0n b\u1ed9 gi\u00e1 tr\u1ecb trong m\u1ed7i\u00a0\u00f4 c\u00f3 =0 hay kh\u00f4ng.<\/p>\n<p><strong>B\u01b0\u1edbc 1: thay th\u1ebf\u00a0\u00f4 c\u00f3 gi\u00e1 tr\u1ecb 0 th\u00e0nh 1 k\u00fd t\u1ef1 text b\u1ea5t k\u1ef3<\/strong><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-59.gif\" title=\"ex101_92019-nho-59\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>C\u00f4ng th\u1ee9c t\u1ea1i\u00a0\u00f4 B8 nh\u01b0 sau:<\/p>\n<p>=IF(B2=0,\u201da\u201d,B2)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24233\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chuyen-so-0-thanh-ky-tu.png\" width=\"598\" height=\"338\" title=\"chuyen-so-0-thanh-ky-tu\"><\/p>\n<p>C\u00f4ng th\u1ee9c n\u00e0y c\u00f3 ngh\u0129a l\u00e0: n\u1ebfu gi\u00e1 tr\u1ecb trong\u00a0\u00f4 B2 =0 th\u00ec s\u1ebd thay b\u1eb1ng k\u00fd t\u1ef1 a, c\u00f2n kh\u00e1c 0 th\u00ec s\u1ebd gi\u1eef nguy\u00ean gi\u00e1 tr\u1ecb.<\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 t\u00e1ch ri\u00eang\u00a0\u0111\u01b0\u1ee3c\u00a0\u00f4 gi\u00e1 tr\u1ecb =0 v\u1edbi\u00a0\u00f4 c\u00f3 gi\u00e1 tr\u1ecb &gt;0 nh\u01b0ng ch\u1ee9a s\u1ed1 0.\u00a0\u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c t\u1ea1i B8 cho to\u00e0n b\u1ed9 v\u00f9ng B8:F11<\/p>\n<p><strong>B\u01b0\u1edbc\u00a02: chuy\u1ec3n c\u00e1c k\u1ebft qu\u1ea3 t\u1ea1i v\u00f9ng B8:F11 v\u1ec1 d\u1ea1ng Value thay v\u00ec c\u00f4ng th\u1ee9c.<\/strong><\/p>\n<p>C\u00e1ch l\u00e0m:<\/p>\n<ul>\n<li>Ch\u1ecdn v\u00f9ng B8:F11, nh\u1ea5n ch\u1ecdn copy (ph\u00edm t\u1eaft Ctrl + C)<\/li>\n<li>T\u1ea1i v\u1ecb tr\u00ed\u00a0\u00f4 B8, b\u1ea5m chu\u1ed9t ph\u1ea3i ch\u1ecdn Paste Special &gt; Value<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24236\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chuyen-cong-thuc-thanh-gia-tri.png\" width=\"1076\" height=\"464\" title=\"chuyen-cong-thuc-thanh-gia-tri\"><\/p>\n<p style=\"padding-left: 30px\">Tham kh\u1ea3o th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xoa-bo-cong-thuc-van-giu-nguyen-ket-qua-va-dinh-dang-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00f3a b\u1ecf c\u00f4ng th\u1ee9c v\u1eabn gi\u1eef nguy\u00ean k\u1ebft qu\u1ea3 v\u00e0 \u0111\u1ecbnh d\u1ea1ng trong Excel<\/a><\/p>\n<p><strong>B\u01b0\u1edbc 3:\u00a0s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p x\u00f3a n\u1ed9i dung v\u1edbi c\u00f4ng c\u1ee5 Replace<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24237\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/xoa-gia-tri-bang-replace.png\" width=\"1255\" height=\"265\" title=\"xoa-gia-tri-bang-replace\"><\/p>\n<p>M\u1edf c\u1eeda s\u1ed5 Find &amp; Replace (ph\u00edm t\u1eaft Ctrl + H). Trong c\u1eeda s\u1ed5 n\u00e0y th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>Find\u00a0what: nh\u1eadp k\u00fd t\u1ef1 a<\/li>\n<li>Replace\u00a0with: kh\u00f4ng nh\u1eadp n\u1ed9i dung g\u00ec<\/li>\n<li>B\u1ea5m v\u00e0o n\u00fat Replace\u00a0\u0111\u1ec3 thay th\u1ebf t\u1eebng gi\u00e1 tr\u1ecb a trong v\u00f9ng B8:F11<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24239\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-qua-buoc-1-xoa-so-0.png\" width=\"596\" height=\"295\" title=\"ket-qua-buoc-1-xoa-so-0\"><\/p>\n<p><strong>* L\u01b0u\u00a0\u00fd:<\/strong><\/p>\n<p>Thao t\u00e1c x\u00f3a n\u00e0y s\u1ebd khi\u1ebfn c\u00e1c\u00a0\u00f4 tr\u1ed1ng kh\u00f4ng c\u00f3 n\u1ed9i dung g\u00ec (l\u00e0 blank).<\/p>\n<p>\u0110i\u1ec1u n\u00e0y g\u1ea7n gi\u1ed1ng v\u1edbi vi\u1ec7c:<\/p>\n<ul>\n<li>B\u01b0\u1edbc 1: S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c\u00a0=IF(B2=0,\u201d\u201d,B2)<\/li>\n<li>B\u01b0\u1edbc 2: Copy &gt; paste value nh\u01b0 b\u00ecnh th\u01b0\u1eddng<\/li>\n<\/ul>\n<p>Tuy k\u1ebft qu\u1ea3 gi\u1ed1ng v\u1edbi k\u1ebft qu\u1ea3\u00a0\u1edf b\u01b0\u1edbc 3, nh\u01b0ng t\u1ea1i c\u00e1c\u00a0\u00f4 tr\u1ed1ng s\u1ebd coi l\u00e0 <strong>c\u00f3 gi\u00e1 tr\u1ecb r\u1ed7ng<\/strong> ch\u1ee9 kh\u00f4ng ph\u1ea3i\u00a0\u00f4 tr\u1ed1ng (blank)<\/p>\n<p>Ph\u1ea7n gi\u00e1 tr\u1ecb t\u1ea1i c\u1ed9t G, ch\u00fang ta t\u1ea1m th\u1eddi ch\u01b0a\u00a0\u00e1p d\u1ee5ng cho ph\u1ea7n k\u1ebft qu\u1ea3, ch\u1ec9 x\u00e9t ph\u1ea7n c\u00e1c\u00a0\u00f4 c\u1ea7n x\u1eed l\u00fd<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24253\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/loai-bo-cot-tinh-tong-ben-phai.png\" width=\"598\" height=\"292\" title=\"loai-bo-cot-tinh-tong-ben-phai\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loai_bo_o_trong_va_don_o_co_gia_tri_sang_trai\"><\/span>Lo\u1ea1i b\u1ecf\u00a0\u00f4 tr\u1ed1ng v\u00e0 d\u1ed3n\u00a0\u00f4 c\u00f3 gi\u00e1 tr\u1ecb sang tr\u00e1i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>B\u01b0\u1edbc 1:\u00a0ch\u1ecdn to\u00e0n b\u1ed9 c\u00e1c\u00a0\u00f4 tr\u1ed1ng trong v\u00f9ng B8:F11. <\/strong><\/p>\n<p>Thao t\u00e1c ch\u1ecdn nh\u01b0 sau:<\/p>\n<ul>\n<li>Ch\u1ecdn v\u00f9ng B8:F11, sau\u00a0\u0111\u00f3 nh\u1ea5n ph\u00edm F5\u00a0\u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 Go to\u2026<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24255\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chuyen-cong-thuc-thanh-gia-tri-02.png\" width=\"800\" height=\"293\" title=\"chuyen-cong-thuc-thanh-gia-tri-02\"><\/p>\n<ul>\n<li>Trong c\u1eeda s\u1ed5 Go to\u2026 ch\u1ecdn m\u1ee5c Special<\/li>\n<li>Trong c\u1eeda s\u1ed5 Go to Special ch\u1ecdn m\u1ee5c Blanks (ch\u1ec9 ch\u1ecdn c\u00e1c\u00a0\u00f4 tr\u1ed1ng)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24244\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chon-o-trong-voi-go-to-special-blank.png\" width=\"378\" height=\"430\" title=\"chon-o-trong-voi-go-to-special-blank\"><\/p>\n<p><strong>B\u01b0\u1edbc 2: X\u00f3a b\u1ecf c\u00e1c\u00a0\u00f4 tr\u1ed1ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0\u00a0\u0111\u1ea9y d\u1eef li\u1ec7u v\u1ec1 b\u00ean tr\u00e1i<\/strong><\/p>\n<p>B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o v\u1ecb tr\u00ed\u00a0\u00f4 b\u1ea5t k\u1ef3\u00a0\u0111ang\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn, r\u1ed3i t\u00ecm\u00a0\u0111\u1ebfn m\u1ee5c <strong>Delete<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24258\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/chon-delete-o-trong-02.png\" width=\"500\" height=\"290\" title=\"chon-delete-o-trong-02\"><\/p>\n<p>Trong c\u1eeda s\u1ed5 Delete ch\u1ecdn m\u1ee5c <strong>Shift cells left<\/strong> r\u1ed3i nh\u1ea5n OK<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24259\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/delete-shift-cell-to-left-02.png\" width=\"500\" height=\"141\" title=\"delete-shift-cell-to-left-02\"><\/p>\n<p>K\u1ebft qu\u1ea3 thu\u00a0\u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24260\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ket-qua-buoc-2-xoa-don-du-lieu-ve-ben-trai.png\" width=\"602\" height=\"295\" title=\"ket-qua-buoc-2-xoa-don-du-lieu-ve-ben-trai\"><\/p>\n<p>Vi\u1ec7c cu\u1ed1i c\u00f9ng l\u00e0 copy l\u1ea1i l\u1ea1i d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng k\u1ebft qu\u1ea3 v\u00f9ng B8:F11 l\u00ean v\u00f9ng B2:F5 (ho\u1eb7c copy ph\u1ea7n k\u1ebft qu\u1ea3 c\u1ed9t G t\u1eeb G2:G5 xu\u1ed1ng G8:G11)<\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u m\u1edbi\u00a0\u0111\u00fang m\u1ee5c\u00a0\u0111\u00edch c\u1ee7a y\u00eau c\u1ea7u ban\u00a0\u0111\u1ea7u r\u1ed3i.<\/p>\n<p>C\u00f3 th\u1ec3 th\u1ea5y v\u1edbi 1 y\u00eau c\u1ea7u t\u01b0\u1edfng nh\u01b0\u00a0\u0111\u01a1n gi\u1ea3n nh\u01b0ng khi th\u1ef1c hi\u1ec7n l\u1ea1i qua nhi\u1ec1u b\u01b0\u1edbc. Trong c\u00e1c b\u01b0\u1edbc\u00a0\u0111\u00f3 c\u00f3 th\u1ec3 c\u00f3 nh\u1eefng h\u01b0\u1edbng\u00a0\u0111i t\u01b0\u01a1ng t\u1ef1, ra k\u1ebft qu\u1ea3 g\u1ea7n gi\u1ed1ng, nh\u01b0ng l\u1ea1i kh\u00f4ng\u00a0\u0111\u00fang c\u00e1i m\u00e0 ch\u00fang ta c\u1ea7n. V\u00ec v\u1eady khi l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel, c\u00e1c b\u1ea1n c\u1ea7n x\u00e2y d\u1ef1ng cho m\u00ecnh 1 t\u01b0 duy\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7, ho\u00e0n thi\u1ec7n\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 c\u00e1c b\u01b0\u1edbc tr\u01b0\u1edbc khi b\u1eaft tay v\u00e0o th\u1ef1c h\u00e0nh\u0111\u1ec3 tr\u00e1nh b\u1ecb nh\u1ea7m l\u1eabn, l\u1ea1c\u00a0\u0111\u01b0\u1eddng.<\/p>\n<p>T\u00ecm hi\u1ec3u th\u00eam c\u00e1c n\u1ed9i dung t\u01b0\u01a1ng t\u1ef1 trong c\u00e1c b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cac-ky-thuat-xoa-dinh-dang-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1c k\u1ef9 thu\u1eadt xo\u00e1 \u0111\u1ecbnh d\u1ea1ng trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-xoa-noi-dung-bat-ky-trong-bang-danh-sach.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00f3a n\u1ed9i dung b\u1ea5t k\u1ef3 trong b\u1ea3ng danh s\u00e1ch trong Excel b\u1eb1ng VBA<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/thong-bao-xac-nhan-thong-tin-truoc-khi-xoa-noi-dung.html\">Th\u00f4ng b\u00e1o x\u00e1c nh\u1eadn th\u00f4ng tin tr\u01b0\u1edbc khi x\u00f3a n\u1ed9i dung b\u1eb1ng VBA<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-59.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9472,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9471","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9471","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=9471"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9471\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9472"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}