{"id":6506,"date":"2017-09-14T14:51:20","date_gmt":"2017-09-14T12:51:20","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=6506"},"modified":"2024-03-31T22:19:38","modified_gmt":"2024-03-31T20:19:38","slug":"how-to-merge-cells-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-merge-cells-in-excel\/","title":{"rendered":"How to Merge Cells in Excel"},"content":{"rendered":"<p>A great way to customize the layout of your worksheet is to<strong> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-cells-in-excel\/\" target=\"_blank\" rel=\"noopener\">Excel Online Merge Cells<\/a><\/strong>. You can <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-merge-cells\/\" target=\"_blank\" rel=\"noopener\">merge cells<\/a><strong>\u00a0<\/strong>together and play around with the layout to fit your purpose or reporting style.<\/p>\n<p>I will also show you how easy it is to\u00a0<strong>unmerge cells\u00a0<\/strong>too!<\/p>\n<p>Here is our table, you can see that the first row\u00a0<strong>Sales Report<\/strong> is only on a single cell. Let us fix that!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-1.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Merge Cells in Excel\" class=\"alignnone size-full wp-image-6510\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-1.jpg\" alt=\"How to Merge Cells in Excel\" width=\"573\" height=\"215\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-1.jpg 573w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-1-300x113.jpg 300w\" sizes=\"(max-width: 573px) 100vw, 573px\" \/><\/a><\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/1Ql8LQbmt-A?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">How-to-Merge-Cells-in-Excel.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong> <\/span>Make sure to select all of the cells you want to merge together:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-2.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Merge Cells in Excel\" class=\"alignnone size-full wp-image-6511\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-2.jpg\" alt=\"How to Merge Cells in Excel\" width=\"574\" height=\"212\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-2.jpg 574w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-2-300x111.jpg 300w\" sizes=\"(max-width: 574px) 100vw, 574px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span>\u00a0Go to\u00a0<em><strong>Home &gt; Alignment &gt; Merge &amp; Center<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-3.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Merge Cells in Excel\" class=\"alignnone size-full wp-image-6512\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-3.jpg\" alt=\"How to Merge Cells in Excel\" width=\"630\" height=\"135\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-3.jpg 630w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-3-300x64.jpg 300w\" sizes=\"(max-width: 630px) 100vw, 630px\" \/><\/a><\/p>\n<p>The top row is now <strong>merged<\/strong> together!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-4.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Merge Cells in Excel\" class=\"alignnone size-full wp-image-6513\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-4.jpg\" alt=\"How to Merge Cells in Excel\" width=\"574\" height=\"209\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-4.jpg 574w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-4-300x109.jpg 300w\" sizes=\"(max-width: 574px) 100vw, 574px\" \/><\/a><\/p>\n<p>Next is let us see how easy it is <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/merge-multiple-excel-files\/\" target=\"_blank\" rel=\"noopener\">to<\/a> undo the merging.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong> <\/span>Make sure to select\u00a0the single merged cell that you want to unmerge:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-4.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Merge Cells in Excel\" class=\"alignnone size-full wp-image-6513\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-4.jpg\" alt=\"How to Merge Cells in Excel\" width=\"574\" height=\"209\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-4.jpg 574w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-4-300x109.jpg 300w\" sizes=\"(max-width: 574px) 100vw, 574px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong><\/span>\u00a0Go to\u00a0<em><strong>Home &gt; Alignment &gt; Merge &amp; Center &gt; Unmerge Cells<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-5.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Merge Cells in Excel\" class=\"alignnone size-full wp-image-6514\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-5.jpg\" alt=\"How to Merge Cells in Excel\" width=\"634\" height=\"198\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-5.jpg 634w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-5-300x94.jpg 300w\" sizes=\"(max-width: 634px) 100vw, 634px\" \/><\/a><\/p>\n<p>Now\u00a0your cells are now unmerged!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-6.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Merge Cells in Excel\" class=\"alignnone size-full wp-image-6515\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-6.jpg\" alt=\"How to Merge Cells in Excel\" width=\"573\" height=\"214\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-6.jpg 573w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/How-to-Merge-Cells-in-Excel-6-300x112.jpg 300w\" sizes=\"(max-width: 573px) 100vw, 573px\" \/><\/a><\/p>\n<p><span style=\"color: #0000ff\"><strong>How to Merge Cells in Excel<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5924 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg\" width=\"530\" height=\"300\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot-300x170.jpg 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" alt=\"\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A great way to customize the layout of your worksheet is to Excel Online Merge Cells. You can merge cells\u00a0together and play around with the layout to fit your purpose or reporting style. I will also show you how easy it is to\u00a0unmerge cells\u00a0too! Here is our table, you can see that the first row\u00a0Sales [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17594,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to Merge Cells in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[7,6,10,41],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6506"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=6506"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6506\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17594"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=6506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=6506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=6506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}