{"id":10226,"date":"2025-01-10T15:47:21","date_gmt":"2025-01-10T15:47:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/10\/huong-dan-su-dung-merge-cells-trong-bai-thi-mos-excel\/"},"modified":"2025-01-10T15:47:21","modified_gmt":"2025-01-10T15:47:21","slug":"huong-dan-su-dung-merge-cells-trong-bai-thi-mos-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/10\/huong-dan-su-dung-merge-cells-trong-bai-thi-mos-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Merge Cells trong b\u00e0i thi MOS Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Nh\u1eefng trang t\u00ednh bao g\u1ed3m d\u1eef li\u1ec7u, \u1edf c\u00e1c m\u1ee9c \u0111\u1ed9 li\u00ean k\u1ebft kh\u00e1c nhau. V\u1edbi Merge Cells, ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u00f3 th\u1ec3 gh\u00e9p n\u1ed1i ho\u1eb7c chia t\u00e1ch \u0111\u1ec3 \u0111\u1ecbnh v\u1ecb r\u00f5 c\u00e1c m\u1ed1i quan h\u1ec7. H\u00e3y tham kh\u1ea3o b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y:<\/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-67814108718c4\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/su-dung-merge-cells-bai-thi-mos-excel.html#Ket_hop_cac_o_su_dung_merge_cells\" title=\"K\u1ebft h\u1ee3p c\u00e1c \u00f4 s\u1eed d\u1ee5ng merge cells\">K\u1ebft h\u1ee3p c\u00e1c \u00f4 s\u1eed d\u1ee5ng merge cells<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/su-dung-merge-cells-bai-thi-mos-excel.html#Chia_tach_cac_o_da_hop_nhat_su_dung_merge_cells\" title=\"Chia t\u00e1ch c\u00e1c \u00f4 \u0111\u00e3 h\u1ee3p nh\u1ea5t s\u1eed d\u1ee5ng merge cells\">Chia t\u00e1ch c\u00e1c \u00f4 \u0111\u00e3 h\u1ee3p nh\u1ea5t s\u1eed d\u1ee5ng merge cells<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ket_hop_cac_o_su_dung_merge_cells\"><\/span><strong>K\u1ebft h\u1ee3p c\u00e1c \u00f4 s\u1eed d\u1ee5ng merge cells<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng ba ch\u1ee9c n\u0103ng h\u1ee3p nh\u1ea5t \u00f4 bao g\u1ed3m:<\/p>\n<ol>\n<li>Merge &amp; Center<\/li>\n<\/ol>\n<p>V\u1edbi ch\u1ee9c n\u0103ng n\u00e0y, ng\u01b0\u1eddi s\u1eed d\u1ee5ng s\u1ebd ti\u1ebfn h\u00e0nh k\u1ebft h\u1ee3p c\u00e1c \u00f4 t\u1eeb c\u00e1c h\u00e0ng v\u00e0 c\u00e1c c\u1ed9t \u0111\u00e3 ch\u1ecdn l\u1ea1i th\u00e0nh m\u1ed9t \u00f4, \u0111\u1ed3ng th\u1eddi c\u0103n gi\u1eefa d\u1eef li\u1ec7u t\u1eeb \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a danh s\u00e1ch h\u1ee3p nh\u1ea5t.<\/p>\n<ol start=\"2\">\n<li>Merge Across<\/li>\n<\/ol>\n<p>S\u1eed d\u1ee5ng Merge Across cho ph\u00e9p k\u1ebft h\u1ee3p c\u00e1c \u00f4 trong c\u00f9ng m\u1ed9t d\u00f2ng c\u1ee7a v\u00f9ng \u0111\u00e3 ch\u1ecdn l\u1ea1i v\u1edbi nhau v\u00e0 gi\u1eef l\u1ea1i \u00f4 d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean c\u1ee7a t\u1eebng d\u00f2ng.<\/p>\n<ol start=\"3\">\n<li>Merge Cells<\/li>\n<\/ol>\n<p>Merge Cells k\u1ebft h\u1ee3p c\u00e1c \u00f4 t\u1eeb c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t thu\u1ed9c v\u00f9ng \u0111\u00e3 ch\u1ecdn l\u1ea1i v\u1edbi nhau, sau \u0111\u00f3 gi\u1eef l\u1ea1i d\u1eef li\u1ec7u c\u1ee7a \u00f4 \u0111\u1ea7u ti\u00ean trong v\u00f9ng m\u00e0 kh\u00f4ng \u0111\u1ecbnh d\u1ea1ng d\u1eef\u00a0 li\u1ec7u nh\u01b0 Merge &amp; Center.<\/p>\n<figure id=\"attachment_20419\" aria-describedby=\"caption-attachment-20419\" style=\"width: 396px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20419\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-merge-cell.png\" alt=\"merge cell\" width=\"396\" height=\"397\" title=\"mos-excel-2010-merge-cell\"><figcaption id=\"caption-attachment-20419\" class=\"wp-caption-text\">S\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa 3 ch\u1ee9c n\u0103ng merge<\/figcaption><\/figure>\n<p>\u0110\u1ec3 ti\u1ebfn h\u00e0nh n\u1ed1i \u00f4, t\u1ea1i th\u1ebb <strong>Home,<\/strong> trong nh\u00f3m <strong>Alignment<\/strong>, ch\u1ecdn m\u0169i t\u00ean drop-down v\u00e0 ch\u1ecdn ki\u1ec3u n\u1ed1i \u00f4 ph\u00f9 h\u1ee3p. <span style=\"text-decoration: underline\">L\u01b0u \u00fd ki\u1ec3m tra d\u1eef li\u1ec7u tr\u01b0\u1edbc khi n\u1ed1i \u00f4 nh\u1eb1m tr\u00e1nh tr\u01b0\u1eddng h\u1ee3p c\u00e1c d\u1eef li\u1ec7u b\u1ecb m\u1ea5t ho\u1eb7c thi\u1ebfu s\u00f3t.<\/span><\/p>\n<p><strong>Xem th\u00eam:\u00a0<\/strong><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 c\u1ed9t trong Excel kh\u00f4ng m\u1ea5t d\u1eef li\u1ec7u<\/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\/2025\/01\/ex101_92019-nho-144.gif\" title=\"ex101_92019-nho-144\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Chia_tach_cac_o_da_hop_nhat_su_dung_merge_cells\"><\/span><strong>Chia t\u00e1ch c\u00e1c \u00f4 \u0111\u00e3 h\u1ee3p nh\u1ea5t s\u1eed d\u1ee5ng merge cells<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 chia t\u00e1ch nh\u1eefng \u00f4 \u0111\u00e3 h\u1ee3p nh\u1ea5t ta v\u00e0o th\u1ebb <strong>Home. <\/strong>Trong nh\u00f3m <strong>Alignment, <\/strong>ch\u1ecdn m\u0169i t\u00ean drop-down c\u1ee7a Merge &amp; Center v\u00e0 ch\u1ecdn <strong>Unmerge Cells.<\/strong><\/p>\n<figure id=\"attachment_20420\" aria-describedby=\"caption-attachment-20420\" style=\"width: 297px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-20420\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-unmerge-cell.png\" alt=\"unmerge cell\" width=\"297\" height=\"200\" title=\"mos-excel-2010-unmerge-cell\"><figcaption id=\"caption-attachment-20420\" class=\"wp-caption-text\">Unmerge Cells t\u1ea1i \u0111\u00e2y<\/figcaption><\/figure>\n<p>Thao t\u00e1c th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng? Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\">Hocexcel.online<\/a>. V\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo trong series b\u00e0i h\u1ecdc ch\u1ee7 \u0111\u1ec1 MOS Excel nh\u00e9!<\/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-144.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10227,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10226","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\/10226","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=10226"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10226\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10227"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}