{"id":15422,"date":"2020-04-24T22:27:51","date_gmt":"2020-04-24T20:27:51","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=15422"},"modified":"2024-04-24T13:28:31","modified_gmt":"2024-04-24T11:28:31","slug":"how-to-merge-cells-in-excel-definitive-guide","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-merge-cells-in-excel-definitive-guide\/","title":{"rendered":"6 Simple Ways to Merge Cells in Excel"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone size-full wp-image-15617\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Merge-Cells.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"1280\" height=\"720\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Merge-Cells.png 1280w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Merge-Cells-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Merge-Cells-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Merge-Cells-768x432.png 768w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/p>\n<p>While working in an Excel Worksheet, you will come across scenarios when you will have to merge cells or combine cells in Excel. Knowing how to merge cells in Excel can be useful when you want to create titles for your reports or combine various cells into one.<\/p>\n<p>Excel has a number of approaches on how to merge cells in Excel that spans across rows and\/or columns.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-merge-cells-in-excel-definitive-guide\/#Lets_take_a_look_at_how_to_merge_cells_in_Excel\" title=\"Let\u2019s take a look at how to merge cells in Excel.\">Let\u2019s take a look at how to merge cells in Excel.<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-merge-cells-in-excel-definitive-guide\/#How_to_Use_the_Merge_Center_button\" title=\"How to Use the Merge &amp; Center button\">How to Use the Merge &amp; Center button<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-merge-cells-in-excel-definitive-guide\/#Other_Merge_Center_Options\" title=\"Other Merge &amp; Center Options\">Other Merge &amp; Center Options<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-merge-cells-in-excel-definitive-guide\/#Using_Center_Across_Selection\" title=\"Using Center Across Selection\">Using Center Across Selection<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-merge-cells-in-excel-definitive-guide\/#Using_the_CONCATENATE_Function\" title=\"Using the CONCATENATE Function\">Using the CONCATENATE Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-merge-cells-in-excel-definitive-guide\/#Adding_a_Space_Line_Breaks_while_Merging_Cells\" title=\"Adding a Space &amp; Line Breaks while Merging Cells\">Adding a Space &amp; Line Breaks while Merging Cells<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-merge-cells-in-excel-definitive-guide\/#Bonus_Approach_%E2%80%93_Flash_Fill\" title=\"Bonus Approach \u2013 Flash Fill\">Bonus Approach \u2013 Flash Fill<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-merge-cells-in-excel-definitive-guide\/#In_Conclusion\" title=\"In Conclusion\">In Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Lets_take_a_look_at_how_to_merge_cells_in_Excel\"><\/span>Let\u2019s take a look at how to merge cells in Excel.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In this post, I will go into detail about several approaches on how to merge cells in Excel. Each one will produce a different result and layout:<\/p>\n<ol>\n<li><a href=\"#how-to-use-the-merge-&amp;-center-button\">How to Use the Merge &amp; Center button<\/a><\/li>\n<li><a href=\"#other-merge-&amp;-center-options\">Other Merge &amp; Center Options<\/a><\/li>\n<li><a href=\"#using-center-across-selection\">Using Center Across Selection<\/a><\/li>\n<li><a href=\"#using-concatenate-formula\">Using CONCATENATE Formula<\/a><\/li>\n<li><a href=\"#adding-line-breaks-while-merging-cells\">Adding a Space &amp; Line Breaks while Merging Cells<\/a><\/li>\n<li><a href=\"#bonus-approach-flash-fill\">Bonus Approach \u2013 Flash Fill<\/a><\/li>\n<\/ol>\n<p>Make sure to download the exercise workbook to follow along:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/How-to-Merge-Cells-in-Excel.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/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><iframe src=\"https:\/\/www.youtube.com\/embed\/sIejxpsbI3A?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\">?<\/span><\/iframe><\/p>\n<div>\n<div style=\"float: left\"><span style=\"text-decoration: underline\"><strong><a href=\"https:\/\/youtu.be\/sIejxpsbI3A\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Watch on YouTube<\/a> <\/strong><\/span>and give it a thumbs up &#x1f44d;<\/div>\n<div>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright 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<h2><span class=\"ez-toc-section\" id=\"How_to_Use_the_Merge_Center_button\"><\/span><a id=\"how-to-use-the-merge-&amp;-center-button\"><\/a>How to Use the Merge &amp; Center button<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>A great way to customize the layout of your Excel worksheet is to\u00a0use the <strong>Merge &amp; Center feature<\/strong> in Excel<strong>.<\/strong><\/p>\n<p>It is a great way to create a label that spans several columns. This feature will retain the value in the upper-left cell but keep in mind that all data in the other merged cells will be deleted.<\/p>\n<p>In the example below, you can see that the text &#8220;SALES REPORT&#8221; is located in a single cell in A1. Let us fix that!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-1-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15607 \" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-1-1.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"692\" height=\"212\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-1-1.png 725w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-1-1-300x92.png 300w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><\/a><\/p>\n<p><strong>Step 1:<\/strong> Select the cells A1:F1 that you want to merge.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15612 \" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-2.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"706\" height=\"221\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-2.png 967w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-2-300x94.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-2-768x241.png 768w\" sizes=\"(max-width: 706px) 100vw, 706px\" \/><\/a><\/p>\n<p><strong>Step 2:<\/strong> Go to <strong>Home &gt; &#8216;Alignment&#8217; group &gt; Merge &amp; Center<\/strong> button<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15438 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"610\" height=\"129\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2.png 610w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-300x63.png 300w\" sizes=\"(max-width: 610px) 100vw, 610px\" \/><\/a><\/p>\n<p><strong>Step 3:<\/strong> The currently selected cells will be merged, and their contents will be center aligned.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-3-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15613 \" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-3-1.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"657\" height=\"208\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-3-1.png 967w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-3-1-300x95.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-3-1-768x243.png 768w\" sizes=\"(max-width: 657px) 100vw, 657px\" \/><\/a><\/p>\n<p>Notice that the reference for the 6 merged cells cell points at A1.<\/p>\n<p>By following this step-by-step guide on How <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/merge-multiple-excel-files\/\" target=\"_blank\" rel=\"noopener\">to Merge Cells in Excel<\/a> you can create headers\/titles for you report that will make it much easier to understand.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Other_Merge_Center_Options\"><\/span><a id=\"other-merge-&amp;-center-options\"><\/a>Other Merge &amp; Center Options<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you click on the drop-down arrow beside the Merge &amp; Center button in the Alignment group, you will see it contains a drop-down list with additional options and each one produces a different result:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Screenshot-44-e1587982292909.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone size-medium wp-image-15556\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Screenshot-44-e1587982292909-300x259.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"300\" height=\"259\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Screenshot-44-e1587982292909-300x259.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Screenshot-44-e1587982292909.png 344w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<ul>\n<li><strong>Merge Across<\/strong>\u00a0\u2212 When a multi-row range is selected, this command creates multiple merge cells in Excel \u2014 one for each row.<\/li>\n<li><strong>Merge Cells<\/strong>\u00a0\u2212 Merges the selected cells without applying the Center attribute.<\/li>\n<li><strong>Unmerge Cells<\/strong> \u2212This unmerges the merged cells in Excel and we explain in detail below.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>Once you have learned how <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-cells-in-excel\/\" target=\"_blank\" rel=\"noopener\">to merge cells in<\/a> Excel, you should also know how to unmerge them. In order to <strong>Unmerge Cells in Excel<\/strong><\/p>\n<p><strong>Step 1:<\/strong> Select the cells that you want to unmerge.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-3-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15613 \" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-3-1.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"657\" height=\"208\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-3-1.png 967w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-3-1-300x95.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-3-1-768x243.png 768w\" sizes=\"(max-width: 657px) 100vw, 657px\" \/><\/a><\/p>\n<p><strong>Step 2:<\/strong> Click the <strong>Merge &amp; Center<\/strong> button or select the <strong>Unmerge Cells<\/strong> option from the drop-down menu.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Screenshot-44-e1587982292909.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone size-medium wp-image-15556\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Screenshot-44-e1587982292909-300x259.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"300\" height=\"259\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Screenshot-44-e1587982292909-300x259.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Screenshot-44-e1587982292909.png 344w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Your data is now unmerged.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15612 \" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-2.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"706\" height=\"221\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-2.png 967w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-2-300x94.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-2-768x241.png 768w\" sizes=\"(max-width: 706px) 100vw, 706px\" \/><\/a><\/p>\n<p><strong>NB:<\/strong> Even though this is a fairly simple process to know how to merge cells in Excel, it is not highly recommended, and further below we explain the alternatives to merge cells in Excel.<\/p>\n<p>If any data was lost when the original cells were merged, they will not be restored (unless your select CTRL + Z to undo the last action).<\/p>\n<p>Here are a couple of shortfalls once cells have been merged:<\/p>\n<ul>\n<li>Excel Functions won\u2019t work on merged cells<\/li>\n<li>Excel &#8216;Sort&#8217; command will not work on ranges that contain the Excel merge cells.<\/li>\n<li>Single column can\u2019t be selected if it contains any merged cells<\/li>\n<li>Excel Filters cannot be applied<\/li>\n<li>Dates cannot easily be copy-pasted elsewhere<\/li>\n<\/ul>\n<p>Here is a video from Microsoft showing <a href=\"https:\/\/support.office.com\/en-us\/article\/merge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf\" rel=\"nofollow noopener\" target=\"_blank\">merging and unmerging cells<\/a> in action.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Using_Center_Across_Selection\"><\/span><a id=\"using-center-across-selection\"><\/a>Using Center Across Selection<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To achieve the same result as Merge &amp; Center without having the above restrictions, use the <strong>Center Across Selection<\/strong> feature. This would merge the cells across columns and still let you select each cell individually. Below we explain how to apply the Center Across Selection:<\/p>\n<p><strong>Step 1:<\/strong> Select the cells A1:F1 that you want to merge.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15612 \" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-2.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"706\" height=\"221\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-2.png 967w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-2-300x94.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-2-2-768x241.png 768w\" sizes=\"(max-width: 706px) 100vw, 706px\" \/><\/a><\/p>\n<p><strong>Step 2:<\/strong> Press<strong> Ctrl + 1<\/strong> to bring up the <em>Format Cells<\/em> dialog box.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/90e65356e63517bab05dcf25e3083b32.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15476 size-medium\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/90e65356e63517bab05dcf25e3083b32-300x272.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"300\" height=\"272\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/90e65356e63517bab05dcf25e3083b32-300x272.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/90e65356e63517bab05dcf25e3083b32.png 534w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><strong>Step 3:<\/strong> Under the <strong>Alignment Tab<\/strong>, in the <strong>Horizontal<\/strong> drop-down box, select \u201c<strong>Center Across Selection<\/strong>\u201d<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/05b95bff9a35105d53f91ded60e145e6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15477 size-medium\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/05b95bff9a35105d53f91ded60e145e6-300x274.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"300\" height=\"274\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/05b95bff9a35105d53f91ded60e145e6-300x274.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/05b95bff9a35105d53f91ded60e145e6.png 531w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><strong>Step 4:<\/strong> Click OK.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15447\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-5.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"585\" height=\"199\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-5.png 814w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-5-300x102.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-5-768x261.png 768w\" sizes=\"(max-width: 585px) 100vw, 585px\" \/><\/a><\/p>\n<p>The selected cells are now merged. You can see that even though the data is merged across cell <strong>A1: F1<\/strong>, you can still select and refer to each cell individually!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Using_the_CONCATENATE_Function\"><\/span><a id=\"using-concatenate-formula\"><\/a>Using the CONCATENATE Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you use the above options to merge cells in Excel, it will keep the text at the leftmost cell (A1 in this case) and remove the text from all other cells. If you don\u2019t want to lose the text from the merged cells in Excel, use the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-with-a-line-break-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>CONCATENATE Function<\/strong><\/a> (pre Excel 2019), the <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concat-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">CONCAT Function<\/a><\/strong> (Excel 2019 &amp; Office 365) or the <strong>ampersand &#8220;&amp;&#8221; operator<\/strong>. The CONCATENATE function combines cells in Excel quickly.<\/p>\n<p>There may be times when you are dumped with data in Excel and it is not formatted quite the way you want. Say, you have the <strong>First Name<\/strong> and<strong> Last Name<\/strong> in different columns and you want to merge them in a single column containing First &amp; Last Name.<\/p>\n<p>Now, if you use <strong>Merge &amp; Center<\/strong> or <strong>Merge Across Selection<\/strong>, it will delete the text in the second column and only display the First Name as a merged cell. But this is not what you were looking for. Right?<\/p>\n<p>Let me introduce you to the <strong>Concatenate Function <\/strong>and the <strong>ampersand <\/strong><strong>&#8220;&amp;&#8221; operator<\/strong> that will merge cells in Excel! This feature should definitely be bookmarked as it will come in handy when cleaning, transforming and analyzing data in Excel.<\/p>\n<p>The <strong>Concatenate Function<\/strong> will merge multiple cells into a single cell and keep both values. You can merge or join more than two cells together whether it contains text, numbers, or both.<\/p>\n<p>In the SALES REPORT below, you have the First Name in <strong>Column A<\/strong> and Last Name in <strong>Column B<\/strong>. For reporting and further analysis, you need them to be combined into one column, so it&#8217;s best to use the Concatenate function or the &#8220;&amp;&#8221; Operator for this. It is perfect for when you want to merge cells or combine &#8216;FIRST NAMES&#8217; with &#8216;LAST NAMES&#8217; that are in separate columns and merging them into one cell.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15448 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-6.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"531\" height=\"208\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-6.png 531w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-6-300x118.png 300w\" sizes=\"(max-width: 531px) 100vw, 531px\" \/><\/a><\/p>\n<p>Before I \u00a0get into how to merge cells in Excel, let\u2019s talk about exactly what happens when you try to use Merge &amp; Center here. If you select cells A3 and B3 and then press the \u201cMerge &amp; Center\u201d button, you will see that you end up with an Excel merged cell with only the upper-left cell\u2019s value i.e. the First Name.<\/p>\n<p>To merge cells in Excel without losing any data, you should use the <strong>Concatenate Function in Excel.<\/strong> Follow the steps to know how to combine cells in Excel:<\/p>\n<p><strong>Step 1:<\/strong> Select Column C and press <strong>Ctrl +<\/strong> to add a new column. Name this column as \u201c<strong>Full Name<\/strong>\u201d.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/d0910801e4cbebad9a7e19677e5e412b.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15479\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/d0910801e4cbebad9a7e19677e5e412b.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"546\" height=\"202\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/d0910801e4cbebad9a7e19677e5e412b.png 744w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/d0910801e4cbebad9a7e19677e5e412b-300x111.png 300w\" sizes=\"(max-width: 546px) 100vw, 546px\" \/><\/a><\/p>\n<p><strong>Step 2:<\/strong> Select Cell C3 and type the <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a>: <strong>=CONCATENATE(A3, B3)<\/strong>. Press Enter<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/8e2e42949253985fe82955fc9c44c23b.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15478\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/8e2e42949253985fe82955fc9c44c23b.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"550\" height=\"236\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/8e2e42949253985fe82955fc9c44c23b.png 751w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/8e2e42949253985fe82955fc9c44c23b-300x129.png 300w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/a><\/p>\n<p><strong>Step 3:<\/strong> Copy cell C3 and paste it in remaining cells or drag the fill handle to copy the formula to the other cells below.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/5ed44b6f6b87c8082183fda270a6c844.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15480\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/5ed44b6f6b87c8082183fda270a6c844.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"539\" height=\"230\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/5ed44b6f6b87c8082183fda270a6c844.png 745w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/5ed44b6f6b87c8082183fda270a6c844-300x128.png 300w\" sizes=\"(max-width: 539px) 100vw, 539px\" \/><\/a><\/p>\n<p>This will merge cells in Excel without losing the data!\u00a0 Below we show you how to make this merged cell look prettier by adding a space between the First &amp; Last Names as well as a line break.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Adding_a_Space_Line_Breaks_while_Merging_Cells\"><\/span><a id=\"adding-line-breaks-while-merging-cells\"><\/a>Adding a Space &amp; Line Breaks while Merging Cells<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In the FULL NAME column above, you can see that there is no space or any character between the FIRST NAME and the LAST NAME. This mashed-together value of the FULL NAME isn\u2019t a typographical mistake. It is important to understand how to combine cells in Excel including spaces.<\/p>\n<p>To <strong>concatenate this information and include spaces<\/strong>, in the 2nd CONCATENATE function argument, you need to type in double quotation marks and put a <strong>space<\/strong> between these quotations i.e. <strong>&#8221; &#8220;<\/strong><\/p>\n<p>The edited formula will be =CONCATENATE(A3,&#8221; &#8220;, B3).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15451 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-9.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"566\" height=\"222\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-9.png 566w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-9-300x118.png 300w\" sizes=\"(max-width: 566px) 100vw, 566px\" \/><\/a><\/p>\n<p>You can replace the space with a dot, comma, or any other character. Simply, replace the space in this function with a character and make sure to enclose the character or text in double quotation marks. With the Concatenate function you also have the option to amend the combination later, whereas you don\u2019t have any such option if you use Merge &amp; Center.<\/p>\n<p>You can also <strong>use the ampersand sign, &amp;, to combine cells<\/strong> in Excel. The <strong>&amp;<\/strong>\u00a0operator works just like the CONCATENATE function where you can combine text, numbers, individual cells, etc. Both <strong>CONCATENATE<\/strong> and <strong>&amp;<\/strong> produce the same results.<\/p>\n<p>Let\u2019s see how to merge cells in Excel using the <strong>&amp;<\/strong> operator.<\/p>\n<p>The following examples show the same SALES REPORT but this time I will use <strong>&amp;<\/strong> operator to merge cells in Excel.<\/p>\n<p>The formula to be used is <strong>= A3&amp;&#8221; &#8220;&amp;B3<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/fd8b344dfb959d2a1b72f260e5615c13.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15483\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/fd8b344dfb959d2a1b72f260e5615c13.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"559\" height=\"240\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/fd8b344dfb959d2a1b72f260e5615c13.png 746w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/fd8b344dfb959d2a1b72f260e5615c13-300x129.png 300w\" sizes=\"(max-width: 559px) 100vw, 559px\" \/><\/a><\/p>\n<p>You can see that the result is the same and you can use either the ampersand sign <strong>&amp;<\/strong> or the <strong>CONCATENATE<\/strong> function, it just depends on what you are more comfortable with.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-with-a-line-break-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>You can also add line breaks while merging cells<\/strong><\/a> by using the <strong>CHAR(10)<\/strong> function in Excel.<\/p>\n<p>In the following example, the <strong>CHAR(10)<\/strong> function is used to add a line break between FULL NAME &amp; SALES. You can use the formula: =CONCATENATE(B3, <strong>CHAR(10)<\/strong>, C3).<\/p>\n<p>Also, make sure you select the \u201c<strong>Wrap Text<\/strong>\u201d option under the Home Tab, otherwise the result will be displayed in the same line only.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15452\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-10.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"317\" height=\"285\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-10.png 414w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-10-300x270.png 300w\" sizes=\"(max-width: 317px) 100vw, 317px\" \/><\/a><\/p>\n<p>You can see that the FULL NAME is displayed on the first line and the second line contains SALES, which is another cool way you can create Excel merged cells.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Bonus_Approach_%E2%80%93_Flash_Fill\"><\/span><a id=\"bonus-approach-flash-fill\"><\/a>Bonus Approach \u2013 Flash Fill<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Lastly, <strong>there is a BONUS approach<\/strong> to merge cells in Excel with \u2013<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-flash-fill-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\"> Flash Fill<\/a>.<\/strong> It is probably the simplest way to combine cells in Excel and is available in Excel 2013 or later.<\/p>\n<p>Flash Fill is a special tool that analyses the pattern from the existing cells and then automatically extracts the data to the pattern that you set. We can combine the FIRST NAME and LAST NAME from the previous example using Flash Fill.<\/p>\n<p><strong>Step 1:<\/strong> You should establish a pattern by typing the FULL NAME in cell C2.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/febc34b3bb8a44e76555a72f13461b0b.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15484\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/febc34b3bb8a44e76555a72f13461b0b.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"543\" height=\"229\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/febc34b3bb8a44e76555a72f13461b0b.png 745w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/febc34b3bb8a44e76555a72f13461b0b-300x126.png 300w\" sizes=\"(max-width: 543px) 100vw, 543px\" \/><\/a><\/p>\n<p><strong>Step 2:<\/strong> Highlight the remaining cell and press the keyboard <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\" title=\"shortcut\" data-wpil-keyword-link=\"linked\">shortcut<\/a> <strong>Ctrl + E<\/strong> or go to the ribbon menu and select: <strong>Data &gt; Flash Fill<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/378e093c1ed858a01722706c257a75f3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15485\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/378e093c1ed858a01722706c257a75f3.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"540\" height=\"281\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/378e093c1ed858a01722706c257a75f3.png 879w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/378e093c1ed858a01722706c257a75f3-300x156.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/378e093c1ed858a01722706c257a75f3-768x399.png 768w\" sizes=\"(max-width: 540px) 100vw, 540px\" \/><\/a><\/p>\n<p><strong>Step 3:<\/strong> Excel will sense the pattern you provided in C2, and will fill in the empty cells below, merging the FIRST NAME with the LAST NAME.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"6 Simple Ways to Merge Cells in Excel\" class=\"alignnone wp-image-15454 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-11.png\" alt=\"6 Simple Ways to Merge Cells in Excel\" width=\"577\" height=\"187\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-11.png 577w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/04\/Picture-11-300x97.png 300w\" sizes=\"(max-width: 577px) 100vw, 577px\" \/><\/a><\/p>\n<p>If the Flash Fill does not seem to be working for your data, make sure it is turned on.<\/p>\n<p>To turn Flash Fill on, go to <strong>Tools &gt; Options &gt; Advanced &gt; Editing Options &gt; check the &#8220;Automatically Flash Fill&#8221; box<\/strong>.<\/p>\n<p><strong>Excel&#8217;s Flash Fill feature is a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/fix-incorrect-formatting-using-flash-fill-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">versatile tool<\/a> that can be used to merge, split, or clean data.<\/strong> You need to type the first entry for Excel to sense the patterns and then Excel fills in the rest of the data based on the pattern you provided.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"In_Conclusion\"><\/span><strong>In Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>So, the <strong>Merge &amp; Center<\/strong> or <strong>Center Across Selection<\/strong> features in Excel makes data more visually presentable and highly organized. But it only keeps the contents of the top-left cell and deletes the rest.<\/p>\n<p>This loss of data is a big disadvantage when you merge cells in Excel. To preserve your data in Excel, use the <strong>&amp;<\/strong>\u00a0operator, the <strong>CONCATENATE<\/strong> function, or <strong>Flash Fill<\/strong> to merges cells&#8217; contents into one cell.<\/p>\n<p><strong>Make sure to download our FREE PDF on the<a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer\"> 333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14329 size-medium\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg\" alt=\"\" width=\"300\" height=\"200\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-1024x682.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-768x512.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups.jpg 1340w\" sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\"><\/a><\/p>\n<p>You can learn more on how to use Excel by viewing our FREE Excel webinar training on <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Formulas<\/a>, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Tables<\/a> and <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" target=\"_blank\" rel=\"noopener noreferrer\">Macros &amp; VBA<\/a>!<\/p>\n<p><em><strong>You can follow our\u00a0<a href=\"https:\/\/www.youtube.com\/user\/LearnExcelPivotTable\" target=\"_blank\" rel=\"noopener noreferrer\">YouTube channel<\/a> to learn more about How To Merge Cells in Excel!<\/strong><\/em><br \/>\n<strong><style>.special-box a { color: #fff; } <\/style><div class=\"drop-shadow lifted special-box\" style=\"text-align: center; color: #fff; padding: 15px; background: var(--V4-primary-orange); border-radius: 6px;\"> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-51.html\" target=\"_blank\" rel=\"noopener noreferrer\">&#x1f449; Click Here To Join Our Excel Academy Online Course &amp; Access 1,000+ Excel Tutorials On Formulas, Macros, VBA, Pivot Tables, Dashboards, Power BI, Power Query, Power Pivot, Charts, Microsoft Office Suite + MORE!\u00a0<\/a> <\/div><\/strong><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>While working in an Excel Worksheet, you will come across scenarios when you will have to merge cells or combine cells in Excel. Knowing how to merge cells in Excel can be useful when you want to create titles for your reports or combine various cells into one. Excel has a number of approaches on [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":15617,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"6 Simple Ways to Merge Cells in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,41],"tags":[69,162,619,618],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/15422"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=15422"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/15422\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/15617"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=15422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=15422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=15422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}