{"id":1131,"date":"2023-11-04T00:00:00","date_gmt":"2023-11-04T04:00:00","guid":{"rendered":"https:\/\/molecularsciences.org\/content\/?p=1131"},"modified":"2023-10-30T01:34:07","modified_gmt":"2023-10-30T05:34:07","slug":"how-to-merge-and-unmerge-cells-in-excel","status":"publish","type":"post","link":"https:\/\/molecularsciences.org\/content\/how-to-merge-and-unmerge-cells-in-excel\/","title":{"rendered":"How to merge and unmerge cells in Excel"},"content":{"rendered":"\n<p>In this post, you will learn how to merge and unmerge cells in Excel.<\/p>\n\n\n\n<p><strong>Select cells and then click on Home tab in the menu followed by Merge and Center in the Alignment section of the ribbon. Click on Unmerge to unmerge the cells.<\/strong><\/p>\n\n\n\n<p><strong>Following are detailed step-by-step instructions:<\/strong><\/p>\n\n\n\n<p>Step 1: Select cells you want to merge<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/canacoder.com\/wp-content\/uploads\/2020\/05\/image-11.png\" alt=\"\" class=\"wp-image-82\"\/><\/figure>\n\n\n\n<p>Step 2: Choose merge and center. Go to&nbsp;<strong>Home<\/strong>&nbsp;menu. Then click on&nbsp;<strong>Merge &amp; Center<\/strong>&nbsp;as shown below. To unmerge, simply choose&nbsp;<strong>Unmerge cells<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/canacoder.com\/wp-content\/uploads\/2020\/05\/image-13.png\" alt=\"\" class=\"wp-image-84\"\/><\/figure>\n\n\n\n<p><strong>Merge &amp; Center<\/strong><\/p>\n\n\n\n<p>Merge &amp; Center will remove values of all cells and only keep the value of the active cell. It will center the text. Following image demonstrates this. The values AA, BB, CC, DD, EE, and FF were replaced with AA.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/canacoder.com\/wp-content\/uploads\/2020\/05\/image-14.png\" alt=\"\" class=\"wp-image-85\"\/><\/figure>\n\n\n\n<p><strong>Merge Across<\/strong><\/p>\n\n\n\n<p><strong>Merge Across<\/strong>&nbsp;will only keep the values of the left most column. See image below<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/canacoder.com\/wp-content\/uploads\/2020\/05\/image-15.png\" alt=\"\" class=\"wp-image-86\"\/><\/figure>\n\n\n\n<p><strong>Merge Cells<\/strong><\/p>\n\n\n\n<p><strong>Merge Cells<\/strong>&nbsp;will only keep the active cell. See the image below.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/canacoder.com\/wp-content\/uploads\/2020\/05\/image-16.png\" alt=\"\" class=\"wp-image-87\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In this post, you will learn how to merge and unmerge cells in Excel. Select cells and then click on Home tab in the menu followed by Merge and Center in the Alignment section of the ribbon. Click on Unmerge to unmerge the cells. Following are detailed step-by-step instructions: Step 1: Select cells you want [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[207],"tags":[56],"class_list":["post-1131","post","type-post","status-publish","format-standard","hentry","category-excel","tag-microsoft-excel"],"_links":{"self":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/1131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/comments?post=1131"}],"version-history":[{"count":1,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/1131\/revisions"}],"predecessor-version":[{"id":1132,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/1131\/revisions\/1132"}],"wp:attachment":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/media?parent=1131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/categories?post=1131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/tags?post=1131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}