{"id":6793,"date":"2024-12-21T16:10:42","date_gmt":"2024-12-21T16:10:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chia-tach-bang-tinh-thanh-cac-tep-excel-rieng-biet-cuc-ki-don-gian\/"},"modified":"2024-12-21T16:10:42","modified_gmt":"2024-12-21T16:10:42","slug":"cach-chia-tach-bang-tinh-thanh-cac-tep-excel-rieng-biet-cuc-ki-don-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chia-tach-bang-tinh-thanh-cac-tep-excel-rieng-biet-cuc-ki-don-gian\/","title":{"rendered":"C\u00e1ch chia t\u00e1ch b\u1ea3ng t\u00ednh th\u00e0nh c\u00e1c t\u1ec7p Excel ri\u00eang bi\u1ec7t c\u1ef1c k\u00ec \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>B\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n <strong>chia t\u00e1ch m\u1ed9t b\u1ea3ng t\u00ednh l\u1edbn th\u00e0nh c\u00e1c t\u1ec7p Excel ri\u00eang bi\u1ec7t<\/strong> v\u00e0 sao l\u01b0u m\u1ed7i trang t\u00ednh c\u1ee7a b\u1ea3ng t\u00ednh th\u00e0nh m\u1ed9t t\u1ec7p Excel ri\u00eang. Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u1edbi thi\u1ec7u c\u00e1ch chia t\u00e1ch b\u1ea3ng t\u00ednh l\u1edbn th\u00e0nh c\u00e1c t\u1ec7p Excel d\u1ef1a tr\u00ean t\u1eebng trang t\u00ednh.<\/em><\/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-6766e8811a9c9\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-chia-tach-bang-tinh-thanh-cac-tep-excel-rieng-biet.html#Chia_tach_bang_tinh_thanh_nhieu_tep_Excel_bang_Copy_va_Paste\" title=\"Chia t\u00e1ch b\u1ea3ng t\u00ednh th\u00e0nh nhi\u1ec1u t\u1ec7p Excel b\u1eb1ng Copy v\u00e0 Paste\">Chia t\u00e1ch b\u1ea3ng t\u00ednh th\u00e0nh nhi\u1ec1u t\u1ec7p Excel b\u1eb1ng Copy v\u00e0 Paste<\/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\/cach-chia-tach-bang-tinh-thanh-cac-tep-excel-rieng-biet.html#Chia_tach_mot_bang_tinh_thanh_nhieu_tep_bang_VBA_Code\" title=\"Chia t\u00e1ch m\u1ed9t b\u1ea3ng t\u00ednh th\u00e0nh nhi\u1ec1u t\u1ec7p b\u1eb1ng VBA Code\">Chia t\u00e1ch m\u1ed9t b\u1ea3ng t\u00ednh th\u00e0nh nhi\u1ec1u t\u1ec7p b\u1eb1ng VBA Code<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chia_tach_bang_tinh_thanh_nhieu_tep_Excel_bang_Copy_va_Paste\"><\/span><strong>Chia t\u00e1ch b\u1ea3ng t\u00ednh th\u00e0nh nhi\u1ec1u t\u1ec7p Excel b\u1eb1ng Copy v\u00e0 Paste<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Th\u00f4ng th\u01b0\u1eddng, s\u1eed d\u1ee5ng <strong>Copy<\/strong> v\u00e0 <strong>Paste<\/strong> c\u00f3 th\u1ec3 sao l\u01b0u b\u1ea3ng t\u00ednh th\u00e0nh c\u00e1c t\u1ec7p Excel m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng. \u0110\u1ea7u ti\u00ean, ch\u1ecdn to\u00e0n b\u1ed9 trang t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n t\u00e1ch th\u00e0nh t\u1ec7p, t\u1ea1o b\u1ea3ng t\u00ednh m\u1edbi v\u00e0 d\u00e1n ch\u00fang v\u00e0o b\u1ea3ng t\u00ednh m\u1edbi, cu\u1ed1i c\u00f9ng sao l\u01b0u n\u00f3.<\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 c\u00e1ch d\u1ec5 nh\u1ea5t n\u1ebfu b\u1ea1n ch\u1ec9 c\u1ea7n t\u00e1ch m\u1ed9t v\u00e0i trang t\u00ednh th\u00e0nh t\u1ec7p ri\u00eang bi\u1ec7t. Tuy nhi\u00ean, c\u00e1ch n\u00e0y kh\u00e1 t\u1ed1n th\u1eddi gian v\u00e0 m\u1ea5t c\u00f4ng n\u1ebfu b\u1ea1n ph\u1ea3i sao ch\u00e9p v\u00e0 d\u00e1n nhi\u1ec1u trang t\u00ednh c\u00f9ng l\u00fac.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chia_tach_mot_bang_tinh_thanh_nhieu_tep_bang_VBA_Code\"><\/span><strong>Chia t\u00e1ch m\u1ed9t b\u1ea3ng t\u00ednh th\u00e0nh nhi\u1ec1u t\u1ec7p b\u1eb1ng VBA Code<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-chen-va-chay-ma-vba-trong-excel-2010-2016-huong-dan-cho-nguoi-moi-bat-dau.html\" target=\"_blank\" rel=\"noopener noreferrer\">M\u00e3 VBA<\/a> <\/strong>sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n nhanh ch\u00f3ng chia t\u00e1ch nhi\u1ec1u trang t\u00ednh trong b\u1ea3ng t\u00ednh hi\u1ec7n t\u1ea1i th\u00e0nh nhi\u1ec1u t\u1ec7p Excel kh\u00e1c nhau, h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>T\u1ea1o th\u01b0 m\u1ee5c m\u1edbi m\u00e0 b\u1ea1n mu\u1ed1n l\u01b0u tr\u1eef b\u1ea3ng t\u00ednh \u1edf \u0111\u00f3, b\u1edfi v\u00ec c\u00e1c t\u1ec7p Excel sau khi t\u00e1ch s\u1ebd \u0111\u01b0\u1ee3c l\u01b0u trong c\u00f9ng m\u1ed9t th\u01b0 m\u1ee5c.<\/li>\n<li>Nh\u1ea5n gi\u1eef <strong><em>Alt + F11<\/em><\/strong>, c\u1eeda s\u1ed5 <strong><em>Microsoft Visual Basic for Applications<\/em><\/strong> m\u1edf ra.<\/li>\n<li>Nh\u1ea5p <strong><em>Insert &gt; Module<\/em><\/strong>, d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o c\u1eeda s\u1ed5 Module.<\/li>\n<\/ol>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/566b53e05f19fa5933b41e429af2b77f\">Gist<\/a>.<\/div>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Nh\u1ea5n <strong><em>F5<\/em><\/strong> \u0111\u1ec3 ch\u1ea1y m\u00e3. Nh\u01b0 v\u1eady, b\u1ea3ng t\u00ednh s\u1ebd \u0111\u01b0\u1ee3c t\u00e1ch th\u00e0nh nhi\u1ec1u t\u1ec7p Excel trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1ea3ng t\u00ednh g\u1ed1c nh\u01b0 h\u00ecnh ch\u1ee5p d\u01b0\u1edbi \u0111\u00e2y:<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6174\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-150.png\" width=\"600\" height=\"370\" title=\"excel-dialog-box-launcher-1-150\"><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong> N\u1ebfu m\u1ed9t trong c\u00e1c trang t\u00ednh tr\u00f9ng t\u00ean v\u1edbi b\u1ea3ng t\u00ednh, m\u00e3 VBA s\u1ebd kh\u00f4ng ch\u1ea1y \u0111\u01b0\u1ee3c.<\/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-268.gif\" title=\"vba101_92019-nho-268\"><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-609.gif\" title=\"ex101_92019-nho-609\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>VBA\u00a0gi\u00fap \u00edch\u00a0r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c: gi\u00fap b\u1ea1n t\u0103ng t\u1ed1c trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd tr\u00ean Excel, gi\u00fap l\u1eadp c\u00e1c b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng, \u0111i\u1ec1u khi\u1ec3n c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh kh\u00e1c nh\u01b0 Word, Power Point, Outlook\u2026 gi\u00fap bi\u1ebfn file Excel c\u1ee7a b\u1ea1n tr\u1edf th\u00e0nh 1 ph\u1ea7n m\u1ec1m chuy\u00ean nghi\u1ec7p\u2026<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 h\u1ecdc <a href=\"http:\/\/blog.ezworkapp.com\/excel-vba\"><strong>VBA Excel<\/strong><\/a> m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng, b\u1ea1n h\u00e3y tham gia kho\u00e1 h\u1ecdc <a href=\"http:\/\/bit.ly\/2OAUBOg\">VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i:<\/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-268.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6794,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6793","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\/6793","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=6793"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6793\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6794"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}