{"id":6975,"date":"2024-12-21T16:39:00","date_gmt":"2024-12-21T16:39:00","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/merge-cells-bi-quyet-song-hanh-phuc\/"},"modified":"2024-12-21T16:39:00","modified_gmt":"2024-12-21T16:39:00","slug":"merge-cells-bi-quyet-song-hanh-phuc","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/merge-cells-bi-quyet-song-hanh-phuc\/","title":{"rendered":"Merge Cells \u2013 B\u00ed quy\u1ebft s\u1ed1ng h\u1ea1nh ph\u00fac"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/merge-cells-bi-quyet-song-hanh-phuc.html\"><strong>Merge Cells<\/strong><\/a> s\u1ebd c\u00f3 trong b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a>. \u0110\u00e2y l\u00e0 m\u1ed9t ch\u1ee9c n\u0103ng m\u00e0 \u0111\u00f4i khi c\u00f3 th\u1ec3 l\u00e0m kh\u00f3 cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng. N\u1ebfu b\u1ea1n \u0111ang g\u1eb7p ph\u1ea3i kh\u00f3 kh\u0103n nh\u01b0 v\u1eady th\u00ec ch\u1ea7n ch\u1edd g\u00ec m\u00e0 kh\u00f4ng \u0111\u1ecdc ngay.\u00a0<\/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-6766ef23d167e\" 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\/merge-cells-bi-quyet-song-hanh-phuc.html#Merge_Cells_la_gi\" title=\"Merge Cells l\u00e0 g\u00ec?\">Merge Cells l\u00e0 g\u00ec?<\/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\/merge-cells-bi-quyet-song-hanh-phuc.html#Cach_dung\" title=\"C\u00e1ch d\u00f9ng:\">C\u00e1ch d\u00f9ng:<\/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\/merge-cells-bi-quyet-song-hanh-phuc.html#Nhung_sai_lam_khi_dung_Merge_Cells\" title=\"Nh\u1eefng sai l\u1ea7m khi d\u00f9ng Merge Cells\">Nh\u1eefng sai l\u1ea7m khi d\u00f9ng Merge Cells<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/merge-cells-bi-quyet-song-hanh-phuc.html#Tai_sao_ham_tra_ve_ket_qua_khong_dung\" title=\"T\u1ea1i sao h\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u00f4ng \u0111\u00fang?\">T\u1ea1i sao h\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u00f4ng \u0111\u00fang?<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/merge-cells-bi-quyet-song-hanh-phuc.html#Cach_dung_Merge_Cells_nhung_van_giu_nguyen_gia_tri_cac_o\" title=\"C\u00e1ch d\u00f9ng Merge Cells nh\u01b0ng v\u1eabn gi\u1eef nguy\u00ean gi\u00e1 tr\u1ecb c\u00e1c \u00f4.\">C\u00e1ch d\u00f9ng Merge Cells nh\u01b0ng v\u1eabn gi\u1eef nguy\u00ean gi\u00e1 tr\u1ecb c\u00e1c \u00f4.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/merge-cells-bi-quyet-song-hanh-phuc.html#Huong_dan_gop_o_van_giu_nguyen_gia_tri_cua_o\" title=\"H\u01b0\u1edbng d\u1eabn g\u1ed9p \u00f4 v\u1eabn gi\u1eef nguy\u00ean gi\u00e1 tr\u1ecb c\u1ee7a \u00f4:\">H\u01b0\u1edbng d\u1eabn g\u1ed9p \u00f4 v\u1eabn gi\u1eef nguy\u00ean gi\u00e1 tr\u1ecb c\u1ee7a \u00f4:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/merge-cells-bi-quyet-song-hanh-phuc.html#Huong_dan_tu_dong_canh_chinh_do_rong_cua_dong_khi_dung_Merge_Cells\" title=\"H\u01b0\u1edbng d\u1eabn t\u1ef1 \u0111\u1ed9ng canh ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng c\u1ee7a d\u00f2ng khi d\u00f9ng Merge Cells.\">H\u01b0\u1edbng d\u1eabn t\u1ef1 \u0111\u1ed9ng canh ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng c\u1ee7a d\u00f2ng khi d\u00f9ng Merge Cells.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/merge-cells-bi-quyet-song-hanh-phuc.html#Huong_dan_tu_dong_co_gian_do_rong_cua_o_khi_dung_Merge_Cells\" title=\"H\u01b0\u1edbng d\u1eabn t\u1ef1 \u0111\u1ed9ng co gi\u00e3n \u0111\u1ed9 r\u1ed9ng c\u1ee7a \u00f4 khi d\u00f9ng Merge Cells:\">H\u01b0\u1edbng d\u1eabn t\u1ef1 \u0111\u1ed9ng co gi\u00e3n \u0111\u1ed9 r\u1ed9ng c\u1ee7a \u00f4 khi d\u00f9ng Merge Cells:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/merge-cells-bi-quyet-song-hanh-phuc.html#Cach_xu_ly_du_lieu_voi_Merge_Cells\" title=\"C\u00e1ch x\u1eed l\u00fd d\u1eef li\u1ec7u v\u1edbi Merge Cells\">C\u00e1ch x\u1eed l\u00fd d\u1eef li\u1ec7u v\u1edbi Merge Cells<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/merge-cells-bi-quyet-song-hanh-phuc.html#Cach_dien_du_lieu_vao_cac_o_trong_sau_khi_bo_gop_o_un-merge_cells\" title=\"C\u00e1ch \u0111i\u1ec1n d\u1eef li\u1ec7u v\u00e0o c\u00e1c \u00f4 tr\u1ed1ng sau khi b\u1ecf g\u1ed9p \u00f4 (un-merge cells)\">C\u00e1ch \u0111i\u1ec1n d\u1eef li\u1ec7u v\u00e0o c\u00e1c \u00f4 tr\u1ed1ng sau khi b\u1ecf g\u1ed9p \u00f4 (un-merge cells)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/merge-cells-bi-quyet-song-hanh-phuc.html#Cac_bai_viet_huu_ich_ve_Gop_o_Merge_Cells\" title=\"C\u00e1c b\u00e0i vi\u1ebft h\u1eefu \u00edch v\u1ec1 G\u1ed9p \u00f4 (Merge Cells)\">C\u00e1c b\u00e0i vi\u1ebft h\u1eefu \u00edch v\u1ec1 G\u1ed9p \u00f4 (Merge Cells)<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Merge_Cells_la_gi\"><\/span>Merge Cells l\u00e0 g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p><span style=\"font-family: 'andale mono', monospace\"><strong><em><span style=\"font-size: 18pt\">T\u1eeb b\u1ecf th\u00f3i quen Merge Cells, l\u00e0 h\u1ea1nh ph\u00fac!<\/span><\/em><\/strong><\/span><\/p>\n<\/blockquote>\n<p>Merge Cells, hay c\u00f2n g\u1ecdi l\u00e0 g\u1ed9p \u00f4, ngh\u0129a l\u00e0 c\u00e1c \u00f4 s\u1ebd \u0111\u01b0\u1ee3c g\u1ed9p l\u1ea1i (ph\u1ed1i l\u1ea1i) v\u1edbi nhau. V\u00e0 khi \u00e1p d\u1ee5ng Merge Cells, th\u00ec ch\u1ec9 c\u00f3 \u00f4 \u0111\u1ea7u ti\u00ean c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb, n\u1ed9i dung c\u00e1c \u00f4 c\u00f2n l\u1ea1i s\u1ebd b\u1ecb x\u00f3a gi\u00e1 tr\u1ecb.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/merge-cells-bi-quyet-song-hanh-phuc.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31793 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/merge-cells-bi-quyet-song-hanh-phuc.jpg\" alt=\"merge-cells-1\" width=\"640\" height=\"265\" title=\"merge-cells-bi-quyet-song-hanh-phuc\"><\/a><\/p>\n<p>Trong \u1ea3nh minh h\u1ecda, nh\u01b0 c\u00e1c b\u1ea1n th\u1ea5y B\u1ea3ng Ch\u1ea5m C\u00f4ng \u1edf \u00f4 A1 ch\u01b0a \u0111\u01b0\u1ee3c d\u00f9ng Merge Cells, v\u00e0 \u1edf d\u00f2ng 4, \u0111\u00e3 \u0111\u01b0\u1ee3c Merge Cells t\u1eeb \u00f4 A4:G4. Sau khi Merge Cells b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn Align canh tr\u00e1i, ph\u1ea3i, ho\u1eb7c \u0111\u1ec3 gi\u1eefa theo m\u1eb7c \u0111\u1ecbnh sau khi Merge Cells.<\/p>\n<p>Merge Cells ch\u1ec9 khuy\u1ebfn kh\u00edch n\u00ean d\u00f9ng, v\u1edbi d\u00f2ng \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 ti\u00eau \u0111\u1ec1, c\u00f2n l\u1ea1i h\u1ea1n ch\u1ebf, v\u00e0 kh\u00f4ng n\u00ean d\u00f9ng khi n\u00f3 l\u00e0 d\u1eef li\u1ec7u trong m\u1ed9t b\u1ea3ng. Khi b\u1ea1n d\u00f9ng Merge Cells l\u00e0 d\u1eef li\u1ec7u theo d\u00f2ng trong m\u1ed9t b\u1ea3ng t\u00ednh, th\u00ec l\u00fac n\u00e0y b\u1ea1n s\u1ebd kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Sort \u0111\u01b0\u1ee3c. Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y, \u00f4 D6:E6 (ti\u1ec1n \u0111i\u1ec7n tho\u1ea1i) \u0111\u00e3 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng g\u1ed9p \u00f4. L\u00fac n\u00e0y, b\u1ea1n s\u1ebd g\u1eb7p l\u1ed7i \u201cThis operation requires the merged cells to be identically sized\u201d ho\u1eb7c \u201cTo do this, all the merged cells need to be the same size.\u201d<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/merge-cells-khong-the-ap-dung-sort-duoc.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31795 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/merge-cells-khong-the-ap-dung-sort-duoc.jpg\" alt=\"merge-cells-2\" width=\"641\" height=\"415\" title=\"merge-cells-khong-the-ap-dung-sort-duoc\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_dung\"><\/span>C\u00e1ch d\u00f9ng:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/merge-cells-cach-su-dung.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31797 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/merge-cells-cach-su-dung.jpg\" alt=\"merge-cells-3\" width=\"644\" height=\"357\" title=\"merge-cells-cach-su-dung\"><\/a><\/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-629.gif\" title=\"ex101_92019-nho-629\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>+ G\u1ed9p \u00f4: B\u1ea1n ch\u1ecdn c\u00e1c \u00f4 c\u1ea7n g\u1ed9p, sau \u0111\u00f3 ch\u1ecdn Merge Cells, th\u00ec l\u00fac n\u00e0y c\u00e1c \u00f4 s\u1ebd \u0111\u01b0\u1ee3c g\u1ed9p l\u1ea1i v\u1edbi nhau. V\u00e0 nh\u01b0 m\u00ecnh \u0111\u00e3 n\u00f3i t\u1eeb ban \u0111\u1ea7u, ch\u1ec9 c\u00f3 \u00f4 \u0111\u1ea7u ti\u00ean ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i c\u00f3 gi\u00e1 tr\u1ecb, c\u00e1c \u00f4 c\u00f2n l\u1ea1i s\u1ebd b\u1ecb x\u00f3a gi\u00e1 tr\u1ecb.<\/p>\n<p>+ B\u1ecf g\u1ed9p \u00f4: B\u1ea1n ch\u1ecdn \u00f4 \u0111\u00e3 g\u1ed9p, sau \u0111\u00f3 ch\u1ecdn Merge Cells, th\u00ec l\u00fac n\u00e0y c\u00e1c \u00f4 s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00e1ch ri\u00eang ra nhau.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nhung_sai_lam_khi_dung_Merge_Cells\"><\/span>Nh\u1eefng sai l\u1ea7m khi d\u00f9ng Merge Cells<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p><span style=\"font-family: 'andale mono', monospace\"><strong><em><span style=\"font-size: 18pt\">Merge Cells g\u00e2y ra nh\u1eefng hi\u1ec3u l\u1ea7m, v\u00e0 l\u00e0m chia r\u1ebb h\u1ea1nh ph\u00fac l\u1ee9a \u0111\u00f4i!<\/span><\/em><\/strong><\/span><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Tai_sao_ham_tra_ve_ket_qua_khong_dung\"><\/span>T\u1ea1i sao h\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 kh\u00f4ng \u0111\u00fang?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/merge-cells-tai-sao-cong-thuc-tinh-ket-qua-sai.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31798 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/merge-cells-tai-sao-cong-thuc-tinh-ket-qua-sai.jpg\" alt=\"merge-cells-4\" width=\"643\" height=\"355\" title=\"merge-cells-tai-sao-cong-thuc-tinh-ket-qua-sai\"><\/a><\/p>\n<p>Cho v\u00ed d\u1ee5 nh\u01b0 \u1ea3nh minh h\u1ecda, \u0111\u1ed1 c\u00e1c b\u1ea1n bi\u1ebft v\u00ec sao l\u1ea1i l\u00e0 15, khi d\u00f9ng h\u00e0m SUM(E5:E9), thay v\u00ec k\u1ebft qu\u1ea3 t\u1ed5ng ph\u1ea3i l\u00e0 1+2+4+5 = 12. \u0110i\u1ec1u g\u00ec \u0111\u00e3 x\u1ea3y ra? T\u1ea1i sao b\u1ecb l\u1ec7ch 3? S\u1ed1 3 \u0111ang \u1edf \u0111\u00e2u? Qu\u1ef9 \u0111en \u0111\u00e3 b\u1ecb gi\u1ea5u \u0111i nh\u01b0 th\u1ebf n\u00e0o? Ch\u00fang ta c\u00f9ng \u0111i qua ph\u1ea7n 3 \u0111\u1ec3 t\u00ecm c\u00e2u tr\u1ea3 l\u1eddi.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_dung_Merge_Cells_nhung_van_giu_nguyen_gia_tri_cac_o\"><\/span>C\u00e1ch d\u00f9ng Merge Cells nh\u01b0ng v\u1eabn gi\u1eef nguy\u00ean gi\u00e1 tr\u1ecb c\u00e1c \u00f4.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p><span style=\"font-family: 'andale mono', monospace\"><strong><em><span style=\"font-size: 18pt\">B\u00ed k\u00edp gi\u1eef g\u00ecn h\u1ea1nh ph\u00fac gia \u0111\u00ecnh.<\/span><\/em><\/strong><\/span><\/p>\n<\/blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/cach-dung-merge-cells-giu-nguyen-gia-tri-cua-o.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31800 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-dung-merge-cells-giu-nguyen-gia-tri-cua-o.jpg\" alt=\"merge-cells-5\" width=\"640\" height=\"433\" title=\"cach-dung-merge-cells-giu-nguyen-gia-tri-cua-o\"><\/a><\/p>\n<p>C\u00e1c b\u1ea1n th\u1ea5y \u00f4 B4:C4, m\u00ecnh \u0111\u00e3 Merge Cells, v\u1ec1 nguy\u00ean t\u1eafc th\u00ec \u00f4 C4 s\u1ebd kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb, s\u1ebd nh\u01b0 \u00f4 C9, E9, G9, v\u00e0 I9, nh\u01b0ng t\u1ea1i sao n\u00f3 l\u1ea1i c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb? Gi\u1ed1ng c\u00e2u h\u1ecfi tr\u01b0\u1edbc \u0111\u00f3, t\u1ea1i sao l\u1ea1i th\u1eeba 3? C\u00f3 m\u1ed9t s\u1ef1 th\u1eadt \u1edf \u0111\u00e2y l\u00e0 \u00f4 \u0111\u00e3 b\u1ecb merge cells v\u1eabn gi\u1eef gi\u00e1 tr\u1ecb c\u1ee7a ch\u00ednh n\u00f3. V\u00e0 \u1edf c\u00e2u \u0111\u1ed1 tr\u01b0\u1edbc, \u00f4 E6 ch\u1ee9a gi\u00e1 tr\u1ecb 2, \u00f4 E7 ch\u1ee9a gi\u00e1 tr\u1ecb l\u00e0 3, n\u00ean k\u1ebft qu\u1ea3 h\u00e0m SUM m\u1edbi tr\u1ea3 v\u1ec1 15. T\u01b0\u01a1ng t\u1ef1 trong v\u00ed d\u1ee5 c\u1ee7a ph\u1ea7n n\u00e0y, ch\u00fang ta tuy \u0111\u00e3 g\u1ed9p 2 \u00f4 l\u1ea1i, nh\u01b0ng \u00f4 C4 v\u1eabn mang gi\u00e1 tr\u1ecb c\u1ee7a n\u00f3.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_gop_o_van_giu_nguyen_gia_tri_cua_o\"><\/span>H\u01b0\u1edbng d\u1eabn g\u1ed9p \u00f4 v\u1eabn gi\u1eef nguy\u00ean gi\u00e1 tr\u1ecb c\u1ee7a \u00f4:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/cach-merge-cells-van-giu-gia-tri-cua-o.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31801 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-merge-cells-van-giu-gia-tri-cua-o.jpg\" alt=\"merge-cells-6\" width=\"644\" height=\"433\" title=\"cach-merge-cells-van-giu-gia-tri-cua-o\"><\/a><\/p>\n<ul>\n<li>B\u01b0\u1edbc 1: Ch\u1ecdn s\u1ed1 \u00f4 t\u01b0\u01a1ng \u1ee9ng \u0111\u1ec3 merge \u1edf b\u00ean ngo\u00e0i, v\u00ed d\u1ee5 m\u00ecnh ch\u1ecdn 2 \u00f4 B13:C13, m\u00ecnh \u0111\u00e3 t\u00f4 v\u00e0ng cho c\u00e1c b\u1ea1n d\u1ec5 nh\u00ecn.<\/li>\n<li>B\u01b0\u1edbc 2: Ch\u1ecdn Merge Cells cho 2 \u00f4 \u0111\u00f3.<\/li>\n<li>B\u01b0\u1edbc 3: Ta ch\u1ecdn Format Painter.<\/li>\n<li>B\u01b0\u1edbc 4: Ch\u1ecdn \u00f4 \u0111\u1ea7u ti\u00ean c\u1ea7n Merge, l\u00fac n\u00e0y ta ch\u1ecdn \u00f4 B4.<\/li>\n<li>B\u01b0\u1edbc 5: B\u1ea1n c\u1ea7n ch\u1ecdn Format Cells, \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng l\u1ea1i gi\u00e1 tr\u1ecb trong \u00f4 (n\u1ebfu c\u1ea7n). K\u1ebft qu\u1ea3 ta c\u00f3 nh\u01b0 b\u00ean d\u01b0\u1edbi.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/ket-qua-merge-cells-van-giu-gia-tri.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31802 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-merge-cells-van-giu-gia-tri.jpg\" alt=\"merge-cells-7\" width=\"643\" height=\"434\" title=\"ket-qua-merge-cells-van-giu-gia-tri\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_tu_dong_canh_chinh_do_rong_cua_dong_khi_dung_Merge_Cells\"><\/span>H\u01b0\u1edbng d\u1eabn t\u1ef1 \u0111\u1ed9ng canh ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng c\u1ee7a d\u00f2ng khi d\u00f9ng Merge Cells.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p><span style=\"font-family: 'andale mono', monospace\"><strong><em><span style=\"font-size: 18pt\">H\u1ea1nh ph\u00fac l\u00e0 bi\u1ebft chia s\u1ebb v\u00e0 nh\u01b0\u1eddng nh\u1ecbn.<\/span><\/em><\/strong><\/span><\/p>\n<\/blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/merge-cell-auto-fit-row-height.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31805 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/merge-cell-auto-fit-row-height.jpg\" alt=\"merge-cells-8\" width=\"802\" height=\"400\" title=\"merge-cell-auto-fit-row-height\"><\/a><\/p>\n<p>Khi b\u1ea1n l\u00e0m c\u00e1c m\u1eabu form Word trong file Excel, ch\u00fang ta c\u00f3 th\u00f3i quen hay g\u1ed9p c\u00e1c \u00f4 l\u1ea1i. V\u00e0 t\u1eeb \u0111\u00f3 ph\u00e1t sinh th\u00eam v\u1ea5n \u0111\u1ec1 l\u00e0 \u0111\u1ed9 r\u1ed9ng c\u1ee7a d\u00f2ng kh\u00f4ng t\u1ef1 co gi\u00e3n ra v\u1eeba v\u1edbi n\u1ed9i dung c\u1ee7a \u00f4.\u00a0 V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eeda l\u1ed7i n\u00e0y?<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_tu_dong_co_gian_do_rong_cua_o_khi_dung_Merge_Cells\"><\/span>H\u01b0\u1edbng d\u1eabn t\u1ef1 \u0111\u1ed9ng co gi\u00e3n \u0111\u1ed9 r\u1ed9ng c\u1ee7a \u00f4 khi d\u00f9ng Merge Cells:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/tu-dong-chinh-do-rong-cua-dong-khi-merge-cells.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31806 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tu-dong-chinh-do-rong-cua-dong-khi-merge-cells.jpg\" alt=\"merge-cells-9\" width=\"802\" height=\"513\" title=\"tu-dong-chinh-do-rong-cua-dong-khi-merge-cells\"><\/a><\/p>\n<ul>\n<li>B\u01b0\u1edbc 1: Ta ch\u1ecdn 1 \u00f4 b\u00ean ngo\u00e0i v\u00f9ng in, b\u1ea1n n\u00ean ch\u1ecdn qua ch\u1ebf \u0111\u1ed9 Page Break View, k\u00e9o v\u00f9ng in ph\u00f9 h\u1ee3p kh\u1ed5 gi\u1ea5y. V\u00e0 thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c b\u00ean ngo\u00e0i v\u00f9ng in \u0111\u00f3.<\/li>\n<li>B\u01b0\u1edbc 2: T\u1ea1i \u00f4 I5, nh\u1eadp c\u00f4ng th\u1ee9c =\u00f4 ch\u1ee9a n\u1ed9i dung, \u1edf \u0111\u00e2y ta c\u00f3: =A5. Sau khi Enter ta th\u1ea5y \u00f4 c\u00f3 n\u1ed9i dung y h\u1ec7t \u00f4 \u0111\u00e3 merge cells b\u00ean c\u1ea1nh: A5:G5.<\/li>\n<li>B\u01b0\u1edbc 3: T\u00f9y ch\u1ec9nh chi\u1ec1u ngang c\u1ee7a c\u1ed9t I ph\u00f9 h\u1ee3p kh\u1edbp v\u1edbi n\u1ed9i dung c\u1ee7a \u00f4 A5. L\u00fac n\u00e0y ta th\u1ea5y c\u00f3 kho\u1ea3ng 4 d\u00f2ng v\u0103n b\u1ea3n. N\u1ebfu kh\u00f4ng th\u1ea5y xu\u1ed1ng d\u00f2ng, b\u1ea1n c\u1ea7n ch\u1ecdn thi\u1ebft l\u1eadp Wrap Text cho \u00f4 I5, c\u00f3 th\u1ec3 ch\u1ecdn \u1edf menu ho\u1eb7c v\u00e0o Format Cells, ph\u1ea7n Alignment nh\u00e9!<\/li>\n<li>B\u01b0\u1edbc 4: B\u1ea1n click double v\u00e0o ch\u1ed7 gi\u1eefa hai d\u00f2ng 5 v\u00e0 d\u00f2ng 6, n\u00f3 s\u1ebd t\u1ef1 \u0111\u1ed9ng co gi\u00e3n theo nh\u01b0 \u00fd. N\u1ebfu file c\u1ee7a b\u1ea1n c\u00f3 nhi\u1ec1u \u00f4 t\u01b0\u01a1ng t\u1ef1, ta ch\u1ec9 vi\u1ec7c k\u00e9o c\u00f4ng th\u1ee9c \u00e1p d\u1ee5ng cho c\u1ed9t I, v\u00e0 th\u1ef1c hi\u1ec7n vi\u1ec7c t\u1ef1 \u0111\u1ed9ng ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng c\u1ee7a d\u00f2ng, n\u00f3 s\u1ebd t\u1ef1 \u0111\u1ed9ng gi\u00e3n ra nh\u01b0 \u00fd!<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_xu_ly_du_lieu_voi_Merge_Cells\"><\/span>C\u00e1ch x\u1eed l\u00fd d\u1eef li\u1ec7u v\u1edbi Merge Cells<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p><span style=\"font-family: 'andale mono', monospace\"><strong><em><span style=\"font-size: 18pt\">Merge Cells l\u00e0 n\u1ed7i \u0111au chia c\u1eaft c\u1ee7a h\u1ea1nh ph\u00fac l\u1ee9a \u0111\u00f4i.<\/span><\/em><\/strong><\/span><\/p>\n<\/blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/cong-thuc-ap-dung-xu-ly-cho-vung-merge-cells.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31808 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cong-thuc-ap-dung-xu-ly-cho-vung-merge-cells.jpg\" alt=\"merge-cells-10\" width=\"804\" height=\"452\" title=\"cong-thuc-ap-dung-xu-ly-cho-vung-merge-cells\"><\/a><\/p>\n<p>Trong \u1ea3nh minh h\u1ecda, ta th\u1ea5y r\u00f5 r\u00e0ng \u00f4 C5 kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb, t\u01b0\u01a1ng t\u1ef1 c\u00e1c \u00f4 E5, G5, I5 c\u0169ng \u0111\u1ec1u kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ta g\u00e1n gi\u00e1 tr\u1ecb khi n\u00f3 r\u1ed7ng. Vi\u1ec7c n\u00e0y th\u01b0\u1eddng g\u1eb7p khi c\u00e1c b\u1ea1n hay Merge d\u00f2ng ti\u00eau \u0111\u1ec1 khi l\u00e0m b\u00e1o c\u00e1o s\u1ed1 li\u1ec7u theo ng\u00e0y, theo th\u00e1ng. C\u00e1ch x\u1eed l\u00fd \u1edf \u0111\u00e2y, ta s\u1ebd ch\u00e8n 1 d\u00f2ng b\u00ean tr\u00ean d\u00f2ng \u0111\u00e3 Merge Cells, l\u00fac n\u00e0y l\u00e0 d\u00f2ng s\u1ed1 4. \u00d4 B4, m\u00ecnh nh\u1eadp c\u00f4ng th\u1ee9c: =IF(B5&lt;&gt;\u201d\u201d,B5, A4), n\u1ebfu \u00f4 B5 kh\u00e1c r\u1ed7ng, th\u00ec l\u1ea5y gi\u00e1 tr\u1ecb \u00f4 B5, ng\u01b0\u1ee3c l\u1ea1i s\u1ebd l\u1ea5y gi\u00e1 tr\u1ecb \u00f4 A4 (l\u00e0 \u00f4 tr\u01b0\u1edbc \u0111\u00f3). Khi ta k\u00e9o c\u00f4ng th\u1ee9c sang ngang, l\u00fac n\u00e0y \u00f4 C4 s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c t\u01b0\u01a1ng \u1ee9ng: =IF(C5&lt;&gt;\u201d\u201d, C5, B4), t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i. V\u00e0 tada, nh\u01b0 b\u1ea1n \u0111\u00e3 th\u1ea5y d\u1eef li\u1ec7u d\u00f2ng s\u1ed1 4 c\u1ee7a m\u00ecnh \u0111\u00e3 mang \u0111\u1ea7y \u0111\u1ee7 gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u00f4.<\/p>\n<p>Trong v\u00ed d\u1ee5 c\u1ee7a m\u00ecnh \u0111ang theo chi\u1ec1u ngang, v\u1eady th\u00ec n\u1ebfu theo chi\u1ec1u d\u1ecdc th\u00ec c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd th\u1ebf n\u00e0o?<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/cach-dung-ham-if-de-xu-ly-du-lieu-merge-cells.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31809 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-dung-ham-if-de-xu-ly-du-lieu-merge-cells.jpg\" alt=\"merge-cells-11\" width=\"801\" height=\"433\" title=\"cach-dung-ham-if-de-xu-ly-du-lieu-merge-cells\"><\/a><\/p>\n<p>B\u1ea1n th\u1ea5y r\u1ed3i \u0111\u00f3, b\u1edfi v\u00ec Merge Cells n\u00ean c\u00e1c \u00f4 b\u1ecb Merge n\u00f3 mang gi\u00e1 tr\u1ecb r\u1ed7ng, v\u00e0 khi c\u1ea7n t\u00ednh to\u00e1n n\u00f3 l\u1ea1i kh\u00f4ng \u0111\u00fang. Ch\u00fang ta c\u1ea7n ph\u1ea3i x\u1eed l\u00fd d\u1eef li\u1ec7u th\u00f4ng qua c\u1ed9t ph\u1ee5 D, \u0111\u1ec3 l\u1ea5p \u0111\u1ea7y nh\u1eefng ch\u1ed7 c\u00f2n thi\u1ebfu s\u00f3t \u0111\u1ec3 ho\u00e0n thi\u1ec7n d\u1eef li\u1ec7u. N\u1ebfu thay v\u00ec c\u1ed9t D, m\u00e0 h\u00e0m SUMIF($A$3:$A$6,C10,$C$3:$C$6) b\u1ea1n vi\u1ebft l\u1ea1i d\u1ef1a v\u00e0o c\u1ed9t A, th\u00ec l\u00fac n\u00e0y l\u1ea7n l\u01b0\u1ee3t s\u1ebd l\u00e0: 100.000 v\u00e0 300.000. N\u1ebfu kh\u00f4ng tin, b\u1ea1n c\u00f3 th\u1ec3 th\u1eed!<\/p>\n<p>C\u00e2u h\u1ecfi \u0111\u1eb7t ra, b\u00e2y gi\u1edd ch\u00fang ta t\u1eeb b\u1ecf Merge Cells cho c\u1ed9t A, v\u00e0 thay v\u00ec l\u1eadp c\u1ed9t ph\u1ee5 D, ta x\u1eed l\u00fd d\u1eef li\u1ec7u c\u1ed9t A \u0111\u01b0\u1ee3c kh\u00f4ng? C\u00e2u tr\u1ea3 l\u1eddi l\u00e0 \u0111\u01b0\u1ee3c, ch\u00fang ta qua ph\u1ea7n 6.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_dien_du_lieu_vao_cac_o_trong_sau_khi_bo_gop_o_un-merge_cells\"><\/span>C\u00e1ch \u0111i\u1ec1n d\u1eef li\u1ec7u v\u00e0o c\u00e1c \u00f4 tr\u1ed1ng sau khi b\u1ecf g\u1ed9p \u00f4 (un-merge cells)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<blockquote>\n<p><span style=\"font-family: 'andale mono', monospace\"><strong><em><span style=\"font-size: 18pt\">H\u00e0n g\u1eafn v\u1ebft th\u01b0\u01a1ng sau khi t\u1eeb b\u1ecf merge cells<\/span><\/em><\/strong><\/span><\/p>\n<\/blockquote>\n<p>Theo c\u00e1c b\u1ea1n, ch\u00fang ta s\u1ebd x\u1eed l\u00fd c\u1ed9t A \u1edf ph\u1ea7n 5 nh\u01b0 th\u1ebf n\u00e0o? C\u00f3 nhi\u1ec1u c\u00e1ch.<\/p>\n<p>C\u00e1ch 1: Ch\u1ecdn c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p \u00f4 (merged cells), ch\u1ecdn Un-Merge Cells. Sau \u0111\u00f3, copy d\u1eef li\u1ec7u \u1edf c\u1ed9t D3:D6, v\u00e0 Paste Specials &gt; Value sang cho v\u00f9ng A3:A6 (nh\u1edb l\u00e0 Paste Value nh\u00e9, \u0111\u1eebng Paste v\u1edbi CTRL+V n\u00f3 s\u1ebd ra l\u1ed7i \u0111\u1ea5y!).<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/paste-value-cho-o-merge-cells.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31812 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/paste-value-cho-o-merge-cells.jpg\" alt=\"merge-cells-12\" width=\"801\" height=\"522\" title=\"paste-value-cho-o-merge-cells\"><\/a><\/p>\n<p>C\u00e1ch 2: Ta l\u01b0\u1eddi vi\u1ebft th\u00eam c\u1ed9t D, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 b\u1ecf Merge v\u00e0 \u0111i\u1ec1n v\u00e0o c\u00e1c \u00f4 c\u00f2n tr\u1ed1ng?<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/dien-du-lieu-vao-cac-o-trong-sau-un-merge.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31810 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dien-du-lieu-vao-cac-o-trong-sau-un-merge.jpg\" alt=\"merge-cells-13\" width=\"799\" height=\"562\" title=\"dien-du-lieu-vao-cac-o-trong-sau-un-merge\"><\/a><\/p>\n<ul>\n<li>B\u01b0\u1edbc 1: Ch\u1ecdn c\u00e1c \u00f4 c\u1ea7n b\u1ecf Merge Cells (A3:A6).<\/li>\n<li>B\u01b0\u1edbc 2: Ch\u1ecdn Un-Merge Cells<\/li>\n<li>B\u01b0\u1edbc 3: Ch\u1ecdn menu Edit =&gt; Go to\u2026 (ho\u1eb7c ph\u00edm t\u1eaft CTRL+G).<\/li>\n<li>B\u01b0\u1edbc 4: Ta ch\u1ecdn ti\u1ebfp Special\u2026 (ph\u00edm t\u1eaft \u0111i t\u1edbi Special, ta c\u00f3 th\u1ec3 nh\u1ea5n F5, thay v\u00ec ph\u1ea3i l\u00e0m t\u1eeb b\u01b0\u1edbc 3).<\/li>\n<li>B\u01b0\u1edbc 5: Ta ch\u1ecdn [x] Blanks, v\u00e0 ch\u1ecdn OK.<\/li>\n<li>B\u01b0\u1edbc 6: Ta nh\u1eadp v\u00e0o c\u00f4ng th\u1ee9c: =A3, k\u1ebft th\u00fac v\u1edbi ph\u00edm CTRL+ENTER.<\/li>\n<li>B\u01b0\u1edbc 7: L\u00fac n\u00e0y b\u1ea1n s\u1ebd th\u1ea5y c\u00e1c \u00f4 tr\u1ed1ng \u0111\u1ec1u \u0111\u01b0\u1ee3c \u0111i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0o.<\/li>\n<li>B\u01b0\u1edbc 8: Nhi\u1ec7m v\u1ee5 cu\u1ed1i c\u00f9ng, l\u00e0 sao ch\u00e9p to\u00e0n b\u1ed9 k\u1ebft qu\u1ea3 v\u00f9ng A3:A6, r\u1ed3i d\u00e1n l\u1ea1i ch\u00ednh n\u00f3 v\u1edbi Paste Value nh\u01b0 \u0111\u00e3 l\u00e0m v\u1edbi c\u00e1ch 1, v\u1eady l\u00e0 xong!<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/go-to-special-blanks-ctrl-enter.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31811 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/go-to-special-blanks-ctrl-enter.jpg\" alt=\"merge-cells-14\" width=\"802\" height=\"481\" title=\"go-to-special-blanks-ctrl-enter\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cac_bai_viet_huu_ich_ve_Gop_o_Merge_Cells\"><\/span>C\u00e1c b\u00e0i vi\u1ebft h\u1eefu \u00edch v\u1ec1 G\u1ed9p \u00f4 (Merge Cells)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/justify-gop-o-trong-Excel.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31814 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/justify-gop-o-trong-excel.jpg\" alt=\"merge-cells-15\" width=\"1300\" height=\"661\" title=\"justify-gop-o-trong-excel\"><\/a><\/p>\n<ul>\n<li><strong><a href=\"http:\/\/blog.ezworkapp.com\/tinh-nang-fill-justify-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">C\u00e1ch gh\u00e9p c\u00e1c \u00f4 l\u1ea1i v\u1edbi nhau v\u1edbi c\u00f4ng c\u1ee5 Justify \u2013 T\u00ednh n\u0103ng Fill Justify<\/a><\/strong><\/li>\n<li><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-keo-cong-thuc-trong-cac-o-co-su-dung-chuc-nang-tron-o-merge-cells.html\">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<\/a><\/strong><\/li>\n<li><strong><a href=\"http:\/\/blog.ezworkapp.com\/gop-o-trong-excel-voi-merge-cells.html\">H\u01b0\u1edbng d\u1eabn g\u1ed9p \u00f4 trong Excel v\u1edbi ch\u1ee9c n\u0103ng Merge Cells<\/a><\/strong><\/li>\n<li><strong><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-merge-cells-bai-thi-mos-excel.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Merge Cells trong b\u00e0i thi MOS Excel<\/a><\/strong><\/li>\n<\/ul>\n<p>L\u1eddi k\u1ebft: C\u00e1c b\u1ea1n c\u00f3 ng\u1ea1c nhi\u00ean kh\u00f4ng khi giao di\u1ec7n m\u00ecnh gi\u1edbi thi\u1ec7u n\u00f3 qu\u00e1 xa l\u1ea1? C\u00e1c t\u00ednh n\u0103ng tr\u00ean th\u1ef1c t\u1ebf \u0111\u00e3 c\u00f3 t\u1eeb Office 97. Ng\u1ea1c nhi\u00ean ch\u01b0a?<\/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-629.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6976,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6975","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\/6975","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=6975"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6975\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6976"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6975"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6975"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}