{"id":5314,"date":"2024-12-10T13:03:04","date_gmt":"2024-12-10T13:03:04","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/huong-dan-cach-keo-cong-thuc-trong-cac-o-co-su-dung-chuc-nang-tron-o-merge-cells\/"},"modified":"2024-12-10T13:03:04","modified_gmt":"2024-12-10T13:03:04","slug":"huong-dan-cach-keo-cong-thuc-trong-cac-o-co-su-dung-chuc-nang-tron-o-merge-cells","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/huong-dan-cach-keo-cong-thuc-trong-cac-o-co-su-dung-chuc-nang-tron-o-merge-cells\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch k\u00e9o c\u00f4ng th\u1ee9c trong c\u00e1c \u00f4 c\u00f3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng tr\u1ed9n \u00f4 merge cells"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u1ea1n c\u00f3 th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4 (merge cells) trong\u00a0Excel kh\u00f4ng? N\u1ebfu c\u00f3 th\u00ec b\u1ea1n n\u00ean t\u00ecm hi\u1ec3u th\u00eam v\u1ec1 c\u00e1ch k\u00e9o c\u00f4ng th\u1ee9c trong c\u00e1c\u00a0\u00f4 c\u00f3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4. B\u1edfi vi\u1ec7c n\u00e0y r\u1ea5t d\u1ec5 x\u1ea3y ra l\u1ed7i, sai s\u00f3t c\u1ea7n l\u01b0u\u00a0\u00fd. H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel online t\u00ecm hi\u1ec3u r\u00f5 h\u01a1n v\u1ea5n\u00a0\u0111\u1ec1 n\u00e0y nh\u00e9.<\/p>\n<p>Tr\u01b0\u1edbc h\u1ebft b\u1ea1n c\u00f3 th\u1ec3\u00a0\u0111\u1ecdc l\u1ea1i c\u00e1c b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn v\u1ec1 2 n\u1ed9i dung:<\/p>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cac-ky-thuat-sao-chep-cong-thuc-theo-y-muon-trong-excel.html\">C\u00e1ch k\u00e9o c\u00f4ng th\u1ee9c trong\u00a0Excel (Filldown v\u00e0 Fillright)<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/gop-o-trong-excel-voi-merge-cells.html\">C\u00e1ch tr\u1ed9n, g\u1ed9p\u00a0\u00f4 trong\u00a0Excel<\/a><\/li>\n<\/ul>\n<p>Khi l\u00e0m t\u1eebng n\u1ed9i dung ri\u00eang th\u00ec kh\u00f4ng c\u00f3 v\u1ea5n\u00a0\u0111\u1ec1 g\u00ec x\u1ea3y ra, nh\u01b0ng khi k\u00e9o c\u00f4ng th\u1ee9c c\u00f3 li\u00ean quan t\u1edbi nh\u1eefng\u00a0\u00f4\u00a0\u0111\u01b0\u1ee3c tr\u1ed9n, g\u1ed9p th\u00ec s\u1ebd c\u00f3 v\u1ea5n\u00a0\u0111\u1ec1 nh\u01b0 sau:<\/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-67583c073dbf4\" 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-keo-cong-thuc-trong-cac-o-co-su-dung-chuc-nang-tron-o-merge-cells.html#Nhung_truong_hop_xay_ra_loi_khi_keo_cong_thuc_voi_o_duoc_tron_gop\" title=\"Nh\u1eefng tr\u01b0\u1eddng h\u1ee3p x\u1ea3y ra l\u1ed7i khi k\u00e9o c\u00f4ng th\u1ee9c v\u1edbi\u00a0\u00f4\u00a0\u0111\u01b0\u1ee3c tr\u1ed9n, g\u1ed9p\">Nh\u1eefng tr\u01b0\u1eddng h\u1ee3p x\u1ea3y ra l\u1ed7i khi k\u00e9o c\u00f4ng th\u1ee9c v\u1edbi\u00a0\u00f4\u00a0\u0111\u01b0\u1ee3c tr\u1ed9n, g\u1ed9p<\/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-cach-keo-cong-thuc-trong-cac-o-co-su-dung-chuc-nang-tron-o-merge-cells.html#Cach_keo_cong_thuc_khi_ap_dung_chuc_nang_tron_o\" title=\"C\u00e1ch\u00a0k\u00e9o c\u00f4ng th\u1ee9c khi\u00a0\u00e1p d\u1ee5ng ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4\">C\u00e1ch\u00a0k\u00e9o c\u00f4ng th\u1ee9c khi\u00a0\u00e1p d\u1ee5ng ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-keo-cong-thuc-trong-cac-o-co-su-dung-chuc-nang-tron-o-merge-cells.html#Cach_1_Bo_chuc_nang_tron_o_truoc_khi_keo_cong_thuc\" title=\"C\u00e1ch 1: B\u1ecf ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4 tr\u01b0\u1edbc khi k\u00e9o c\u00f4ng th\u1ee9c\">C\u00e1ch 1: B\u1ecf ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4 tr\u01b0\u1edbc khi k\u00e9o c\u00f4ng th\u1ee9c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-keo-cong-thuc-trong-cac-o-co-su-dung-chuc-nang-tron-o-merge-cells.html#Cach_2_Loai_bo_cac_o_bi_tron_o_phia_duoi_roi_keo_cong_thuc_tu_dong_tren_xuong\" title=\"C\u00e1ch 2: Lo\u1ea1i b\u1ecf c\u00e1c\u00a0\u00f4 b\u1ecb tr\u1ed9n\u00a0\u1edf ph\u00eda d\u01b0\u1edbi r\u1ed3i k\u00e9o c\u00f4ng th\u1ee9c t\u1eeb d\u00f2ng tr\u00ean xu\u1ed1ng\">C\u00e1ch 2: Lo\u1ea1i b\u1ecf c\u00e1c\u00a0\u00f4 b\u1ecb tr\u1ed9n\u00a0\u1edf ph\u00eda d\u01b0\u1edbi r\u1ed3i k\u00e9o c\u00f4ng th\u1ee9c t\u1eeb d\u00f2ng tr\u00ean xu\u1ed1ng<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Nhung_truong_hop_xay_ra_loi_khi_keo_cong_thuc_voi_o_duoc_tron_gop\"><\/span>Nh\u1eefng tr\u01b0\u1eddng h\u1ee3p x\u1ea3y ra l\u1ed7i khi k\u00e9o c\u00f4ng th\u1ee9c v\u1edbi\u00a0\u00f4\u00a0\u0111\u01b0\u1ee3c tr\u1ed9n, g\u1ed9p<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24561\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/error-filldown-merge-cell-1.png\" width=\"950\" height=\"176\" title=\"error-filldown-merge-cell-1\"><\/p>\n<p>V\u00ed d\u1ee5 nh\u01b0 trong h\u00ecnh tr\u00ean, ch\u00fang ta mu\u1ed1n Filldown c\u00f4ng th\u1ee9c t\u1eeb d\u00f2ng 2 xu\u1ed1ng t\u1edbi d\u00f2ng 5, nh\u01b0ng\u00a0Excel b\u00e1o l\u1ed7i.<\/p>\n<p>L\u1ed7i n\u00e0y xu\u1ea5t hi\u1ec7n do trong ph\u1ea1m vi v\u00f9ng sao ch\u00e9p c\u00f4ng th\u1ee9c c\u00f3 nh\u1eefng\u00a0\u00f4\u00a0\u0111ang\u00a0\u0111\u01b0\u1ee3c tr\u1ed9n\u00a0\u00f4, m\u00e0\u00a0\u0111\u1ed9 l\u1edbn c\u00e1c\u00a0\u00f4 tr\u1ed9n l\u1ea1i kh\u00f4ng gi\u1ed1ng nhau:<\/p>\n<ul>\n<li>T\u1ea1i d\u00f2ng 2: tr\u1ed9n 3\u00a0\u00f4 D2, E2, F2<\/li>\n<li>T\u1ea1i d\u00f2ng 4: tr\u1ed9n 2\u00a0\u00f4 D4, E4<\/li>\n<li>T\u1ea1i d\u00f2ng 5: tr\u1ed9n 3\u00a0\u00f4 D5, E5, F5<\/li>\n<\/ul>\n<p>Khi\u00a0\u0111\u00f3 ch\u00fang ta kh\u00f4ng th\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c (filldown) m\u1ed9t c\u00e1ch b\u00ecnh th\u01b0\u1eddng\u00a0\u0111\u01b0\u1ee3c.<\/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\/2024\/12\/ex101_92019-nho-456.gif\" title=\"ex101_92019-nho-456\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ngo\u00e0i ra vi\u1ec7c tr\u1ed9n\u00a0\u00f4 c\u00f2n khi\u1ebfn ch\u00fang ta g\u1eb7p l\u1ed7i khi mu\u1ed1n s\u1eafp x\u1ebfp d\u1eef li\u1ec7u:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24562\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/error-on-sort-merge-cell-1024x462-2.gif\" width=\"800\" height=\"361\" title=\"error-on-sort-merge-cell-1024x462-2\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_keo_cong_thuc_khi_ap_dung_chuc_nang_tron_o\"><\/span>C\u00e1ch\u00a0k\u00e9o c\u00f4ng th\u1ee9c khi\u00a0\u00e1p d\u1ee5ng ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 kh\u1eafc ph\u1ee5c nh\u1eefng l\u1ed7i tr\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m theo 2 c\u00e1ch sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_1_Bo_chuc_nang_tron_o_truoc_khi_keo_cong_thuc\"><\/span>C\u00e1ch 1: B\u1ecf ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4 tr\u01b0\u1edbc khi k\u00e9o c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n k\u00e9o c\u00f4ng th\u1ee9c, t\u1ea1m th\u1eddi lo\u1ea1i b\u1ecf ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4 (B\u1ea5m tr\u1edf l\u1ea1i m\u1ee5c Merge cell &amp; center)<\/li>\n<li>Sau\u00a0\u0111\u00f3 filldown c\u00f4ng th\u1ee9c trong 1 c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3<\/li>\n<li>Cu\u1ed1i c\u00f9ng: Th\u1ef1c hi\u1ec7n ch\u1ee9c n\u0103ng Merge Across cho v\u00f9ng k\u1ebft qu\u1ea3<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24563\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-filldown-cong-thuc-khi-tron-o-01-1.gif\" width=\"672\" height=\"369\" title=\"cach-filldown-cong-thuc-khi-tron-o-01-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_2_Loai_bo_cac_o_bi_tron_o_phia_duoi_roi_keo_cong_thuc_tu_dong_tren_xuong\"><\/span>C\u00e1ch 2: Lo\u1ea1i b\u1ecf c\u00e1c\u00a0\u00f4 b\u1ecb tr\u1ed9n\u00a0\u1edf ph\u00eda d\u01b0\u1edbi r\u1ed3i k\u00e9o c\u00f4ng th\u1ee9c t\u1eeb d\u00f2ng tr\u00ean xu\u1ed1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1ch n\u00e0y th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24564\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-filldown-cong-thuc-khi-tron-o-02-1.gif\" width=\"672\" height=\"369\" title=\"cach-filldown-cong-thuc-khi-tron-o-02-1\"><\/p>\n<p>Hy v\u1ecdng r\u1eb1ng qua b\u00e0i vi\u1ebft n\u00e0y c\u00e1c b\u1ea1n s\u1ebd kh\u00f4ng c\u00f2n m\u1eafc ph\u1ea3i l\u1ed7i khi k\u00e9o c\u00f4ng th\u1ee9c trong c\u00e1c\u00a0\u00f4 b\u1ecb tr\u1ed9n, g\u1ed9p n\u1eefa.<\/p>\n<p>Ngo\u00e0i ra ch\u00fang ta h\u1ebft s\u1ee9c l\u01b0u\u00a0\u00fd khi s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4 trong\u00a0Excel. N\u00ean tr\u00e1nh s\u1eed d\u1ee5ng tr\u1ed9n\u00a0\u00f4 trong v\u00f9ng c\u00f3 th\u1ec3 ch\u1ee9a c\u00f4ng th\u1ee9c, ho\u1eb7c trong v\u00f9ng c\u1ea7n s\u1eafp x\u1ebfp d\u1eef li\u1ec7u.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft c\u00f9ng ch\u1ee7\u00a0\u0111\u1ec1 t\u1ea1i:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-goi-phim-tat-merge-cell-trong-excel-2007-2010-2013-2016.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch g\u1ecdi ph\u00edm t\u1eaft merge cell trong excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html\">C\u00e1ch g\u1ed9p hai ho\u1eb7c nhi\u1ec1u \u00f4 trong Excel m\u00e0 kh\u00f4ng m\u1ea5t d\u1eef li\u1ec7u<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tu-dong-tron-o-va-can-le-giua-nhieu-du-lieu-khac-nhau-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ef1 \u0111\u1ed9ng tr\u1ed9n \u00f4 v\u00e0 c\u0103n l\u1ec1 gi\u1eefa nhi\u1ec1u d\u1eef li\u1ec7u kh\u00e1c nhau trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tra-ve-thu-tu-ban-dau-truoc-khi-sap-xep-bang-sort-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch tr\u1ea3 v\u1ec1 th\u1ee9 t\u1ef1 ban \u0111\u1ea7u tr\u01b0\u1edbc khi s\u1eafp x\u1ebfp b\u1eb1ng sort trong Excel<\/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\/2024\/12\/ex101_92019-nho-456.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5315,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5314","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\/5314","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=5314"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5314\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5315"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}