{"id":2767,"date":"2026-09-28T09:53:12","date_gmt":"2026-09-27T23:53:12","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=2767"},"modified":"2026-09-28T09:53:14","modified_gmt":"2026-09-27T23:53:14","slug":"how-to-merge-cells-in-excel","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel","title":{"rendered":"How to Merge Cells in Excel (and When Not To)"},"content":{"rendered":"\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>To merge cells in Excel, select the cells you want to combine, go to the Home tab, and click Merge &amp; Center in the Alignment group. Use the dropdown arrow for other options: Merge Across (merges each row separately), Merge Cells (merges without centring) and Unmerge Cells. Merging keeps only the value in the top-left cell and discards the rest, so it is best used for titles and labels, not for data you will sort, filter or analyse.<\/strong><\/p>\n\n\n\n<!--more-->\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Merging is one of the first formatting tricks people learn in Excel, and one of the most overused. This guide shows you how to merge cells properly, how to combine text without losing data, how to unmerge, why the button is sometimes greyed out, and, importantly, when you should use a tidier alternative instead.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-dominant-color=\"368557\" data-has-transparency=\"false\" style=\"--dominant-color: #368557;\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"538\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/09\/DWT-Excel-Merge-hero-1024x538.png\" alt=\"How to merge cells in Excel, step-by-step guide from Dynamic Web Training\" class=\"wp-image-2768 not-transparent\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/09\/DWT-Excel-Merge-hero-1024x538.png 1024w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/09\/DWT-Excel-Merge-hero-300x158.png 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/09\/DWT-Excel-Merge-hero.png 1200w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 id=\"h-what-does-merging-cells-in-excel-do\" class=\"wp-block-heading has-h-4-font-size\">What does merging cells in Excel do?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Merging combines two or more selected cells into one larger cell. The catch is that Excel keeps only the <strong>top-left<\/strong> value and deletes everything else. If you select two cells containing \u201cJan\u201d and \u201cFeb\u201d and merge them, you are left with a single cell containing just \u201cJan\u201d. That is fine for a heading that spans several columns, but it is a problem if both values were data you needed.<\/p>\n\n\n\n<h2 id=\"h-how-do-you-merge-cells-in-excel\" class=\"wp-block-heading has-h-4-font-size\">How do you merge cells in Excel?<\/h2>\n\n\n\n<ol class=\"wp-block-list has-normal-font-size\">\n<li>Select the cells you want to merge (they must be <strong>next to each other<\/strong>).<\/li>\n\n\n\n<li>Go to the <strong>Home<\/strong> tab.<\/li>\n\n\n\n<li>In the <strong>Alignment<\/strong> group, click <strong>Merge &amp; Center<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">The cells become one and the content is centred. For more control, click the <strong>dropdown arrow<\/strong> next to the button:<\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li><strong>Merge &amp; Center<\/strong> \u2014 merges the selection into one cell and centres the content.<\/li>\n\n\n\n<li><strong>Merge Across<\/strong> \u2014 merges each <strong>row<\/strong> in the selection separately (handy for merging across columns on several rows at once).<\/li>\n\n\n\n<li><strong>Merge Cells<\/strong> \u2014 merges without centring the content.<\/li>\n\n\n\n<li><strong>Unmerge Cells<\/strong> \u2014 splits a merged cell back into individual cells.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"h-how-do-you-merge-cells-without-losing-data\" class=\"wp-block-heading has-h-4-font-size\">How do you merge cells without losing data?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Because Merge &amp; Center throws away everything except the top-left value, it is the wrong tool when you actually want to combine text from several cells. Instead:<\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li><strong>Use the ampersand (&amp;):<\/strong> in a new cell type <code>=A2&amp;\" \"&amp;B2<\/code> to join the contents of A2 and B2 with a space between them.<\/li>\n\n\n\n<li><strong>Use CONCAT or TEXTJOIN:<\/strong> <code>=TEXTJOIN(\" \",TRUE,A2:C2)<\/code> joins a whole range with a chosen separator and skips blanks. These are cleaner for longer lists.<\/li>\n<\/ul>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Then, if you want, copy the result and Paste Special > Values over the original.<\/p>\n\n\n\n<h2 id=\"h-how-do-you-unmerge-cells-in-excel\" class=\"wp-block-heading has-h-4-font-size\">How do you unmerge cells in Excel?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Select the merged cell (or a range that includes it), go to the <strong>Home<\/strong> tab, click the <strong>Merge &amp; Center dropdown<\/strong>, and choose <strong>Unmerge Cells<\/strong>. The cell splits back into its original cells; the value stays in the top-left one and the others are left blank.<\/p>\n\n\n\n<h2 id=\"h-why-can-t-i-merge-cells-in-excel-button-greyed-out\" class=\"wp-block-heading has-h-4-font-size\">Why can\u2019t I merge cells in Excel? (button greyed out)<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">If Merge &amp; Center is greyed out, the usual reasons are:<\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li><strong>Your data is in an Excel Table<\/strong>. Tables do not allow merged cells. Convert the Table to a range first (<strong>Table Design > Convert to Range<\/strong>), merge, or better, avoid merging inside data.<\/li>\n\n\n\n<li><strong>The sheet is protected<\/strong>. Remove protection (<strong>Review > Unprotect Sheet<\/strong>) if you have the right to, then merge.<\/li>\n\n\n\n<li><strong>You are editing a cell.<\/strong> Press Enter or Esc to finish editing first.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"h-when-should-you-not-merge-cells\" class=\"wp-block-heading has-h-4-font-size\">When should you NOT merge cells?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">This is the part most tutorials skip. Merged cells quietly break common tasks:<\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li><strong>Sorting and filtering<\/strong> throw errors or behave unpredictably when a range contains merged cells.<\/li>\n\n\n\n<li><strong>Selecting a whole column or row<\/strong> and copying\/pasting often fails with \u201cThis won\u2019t work on merged cells\u201d.<\/li>\n\n\n\n<li><strong>Formulas and features like VLOOKUP, tables and PivotTables<\/strong> expect one value per cell and get confused by merges.<\/li>\n<\/ul>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">As a rule: <strong>never merge cells inside a data range<\/strong>. Merging is fine for a report title across the top, but not within the rows and columns you will actually work with.<\/p>\n\n\n\n<h2 id=\"h-how-do-you-center-text-across-cells-without-merging\" class=\"wp-block-heading has-h-4-font-size\">How do you center text across cells without merging?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">There is a tidy alternative that looks like a merge but keeps every cell intact: <strong>Center Across Selection<\/strong>.<\/p>\n\n\n\n<ol class=\"wp-block-list has-normal-font-size\">\n<li>Select the cells you want the text to span.<\/li>\n\n\n\n<li>Press <strong>Ctrl + 1<\/strong> to open Format Cells.<\/li>\n\n\n\n<li>On the <strong>Alignment<\/strong> tab, open <strong>Horizontal<\/strong> and choose <strong>Center Across Selection<\/strong>.<\/li>\n\n\n\n<li>Click <strong>OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">The text centres across the range, but each cell still exists, so sorting, filtering and copying keep working. It is the professional\u2019s choice for centred headings.<\/p>\n\n\n\n<h2 id=\"h-practice-on-your-own-spreadsheet\" class=\"wp-block-heading has-h-4-font-size\">Practice on your own spreadsheet<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Merging has its place, but knowing when to reach for Center Across Selection or a formula instead is what separates a tidy, sortable spreadsheet from one that fights you later.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\"><strong>Cell formatting, data layout and functions like TEXTJOIN are covered in our <a href=\"https:\/\/www.dynamicwebtraining.com.au\/microsoft-excel-training-courses\">instructor-led Excel training courses<\/a>, in-class in Sydney and Melbourne or Online Live across Australia. For the bigger picture, see our <a href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/complete-guide-to-microsoft-excel\">Complete Guide to Microsoft Excel<\/a>.<\/strong><\/p>\n\n\n\n<h2 id=\"h-frequently-asked-questions\" class=\"wp-block-heading has-h-4-font-size\">Frequently asked questions<\/h2>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block has-normal-font-size\"><div class=\"schema-faq-section\" id=\"faq-question-1790553001213\"><strong class=\"schema-faq-question\">How do you merge cells in Excel?<\/strong> <p class=\"schema-faq-answer\">Select the adjacent cells, go to the Home tab, and click Merge &amp; Center in the Alignment group. Use the dropdown for Merge Across, Merge Cells (no centring) or Unmerge Cells.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1790553015522\"><strong class=\"schema-faq-question\">How do you merge cells in Excel without losing data?<\/strong> <p class=\"schema-faq-answer\">Merge &amp; Center keeps only the top-left value, so to combine text use a formula instead: =A2&amp;&#8221; \u201c&amp;B2, or =TEXTJOIN(\u201d &#8220;,TRUE,A2:C2) for a range. Then Paste Special > Values if you want to replace the originals.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1790553027733\"><strong class=\"schema-faq-question\">Why can\u2019t I merge cells in Excel?<\/strong> <p class=\"schema-faq-answer\">The Merge &amp; Center button is usually greyed out because your data is inside an Excel Table (convert it to a range first), the sheet is protected (unprotect it), or you are still editing a cell (press Enter or Esc).<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1790553045538\"><strong class=\"schema-faq-question\">How do you unmerge cells in Excel?<\/strong> <p class=\"schema-faq-answer\">Select the merged cell, go to the Home tab, click the Merge &amp; Center dropdown and choose Unmerge Cells. The value stays in the top-left cell and the others become blank.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1790553057983\"><strong class=\"schema-faq-question\">What is the shortcut to merge cells in Excel?<\/strong> <p class=\"schema-faq-answer\">There is no single default key, but you can press the ribbon sequence Alt, H, M, C for Merge &amp; Center. You can also add Merge &amp; Center to the Quick Access Toolbar for a one-key shortcut.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1790553068152\"><strong class=\"schema-faq-question\">Should you merge cells in Excel?<\/strong> <p class=\"schema-faq-answer\">Only for display elements like a title across the top of a report. Never merge inside a data range, because it breaks sorting, filtering and copying. For centred headings, use Center Across Selection (Format Cells > Alignment) instead.<\/p> <\/div> <\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>To merge cells in Excel, select the cells you want to combine, go to the Home tab, and click Merge &amp; Center in the Alignment group. Use the dropdown arrow for other options: Merge Across (merges each row separately), Merge Cells (merges without centring) and Unmerge Cells. Merging keeps only the value in the top-left&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2767","post","type-post","status-publish","format-standard","hentry","category-microsoft-excel"],"yoast_head":"<title>How to Merge Cells in Excel (and When Not To)<\/title>\n<meta name=\"description\" content=\"How to merge cells in Excel with Merge &amp; Center, combine cells without losing data, unmerge, fix greyed-out merge, and when to avoid merging.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Merge Cells in Excel (and When Not To)\" \/>\n<meta property=\"og:description\" content=\"How to merge cells in Excel with Merge &amp; Center, combine cells without losing data, unmerge, fix greyed-out merge, and when to avoid merging.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel\" \/>\n<meta property=\"og:site_name\" content=\"Dynamic Web Training Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-27T23:53:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-27T23:53:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/09\/DWT-Excel-Merge-hero.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dynamic Web Training\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dynamic Web Training\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel\"},\"author\":{\"name\":\"Dynamic Web Training\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/person\\\/c94653aed4a6decc8e357af0a1082233\"},\"headline\":\"How to Merge Cells in Excel (and When Not To)\",\"datePublished\":\"2026-09-27T23:53:12+00:00\",\"dateModified\":\"2026-09-27T23:53:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel\"},\"wordCount\":1071,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/DWT-Excel-Merge-hero-1024x538.png\",\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"en-AU\"},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel\",\"name\":\"How to Merge Cells in Excel (and When Not To)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/DWT-Excel-Merge-hero-1024x538.png\",\"datePublished\":\"2026-09-27T23:53:12+00:00\",\"dateModified\":\"2026-09-27T23:53:14+00:00\",\"description\":\"How to merge cells in Excel with Merge & Center, combine cells without losing data, unmerge, fix greyed-out merge, and when to avoid merging.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553001213\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553015522\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553027733\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553045538\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553057983\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553068152\"}],\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#primaryimage\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/DWT-Excel-Merge-hero.png\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/DWT-Excel-Merge-hero.png\",\"width\":1200,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Training Blog\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Training\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Excel\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\\\/microsoft-excel\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"How to Merge Cells in Excel (and When Not To)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\",\"name\":\"Dynamic Web Training Blog\",\"description\":\"The Ultimate Training Experience.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-AU\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"width\":361,\"height\":109,\"caption\":\"Dynamic Web Training\",\"name\":\"Dynamic Web Training Logo\",\"description\":\"Dynamic Web Training official site logo asset\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/person\\\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"caption\":\"Dynamic Web Training\"},\"description\":\"This article is written by a senior writer at Dynamic Web Training. Our specialist writers are either Microsoft Certified Trainers, Adobe Certified Professionals or Certified Xero Advisors.\",\"sameAs\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\",\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/www.instagram.com\\\/dynamicwebtraining\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dynamic-web-training\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\",\"www.youtube.com\\\/@dynamicwebtraining8740\"],\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553001213\",\"position\":1,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553001213\",\"name\":\"How do you merge cells in Excel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Select the adjacent cells, go to the Home tab, and click Merge &amp; Center in the Alignment group. Use the dropdown for Merge Across, Merge Cells (no centring) or Unmerge Cells.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553015522\",\"position\":2,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553015522\",\"name\":\"How do you merge cells in Excel without losing data?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Merge &amp; Center keeps only the top-left value, so to combine text use a formula instead: =A2&amp;\\\" \u201c&amp;B2, or =TEXTJOIN(\u201d \\\",TRUE,A2:C2) for a range. Then Paste Special > Values if you want to replace the originals.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553027733\",\"position\":3,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553027733\",\"name\":\"Why can\u2019t I merge cells in Excel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"The Merge &amp; Center button is usually greyed out because your data is inside an Excel Table (convert it to a range first), the sheet is protected (unprotect it), or you are still editing a cell (press Enter or Esc).\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553045538\",\"position\":4,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553045538\",\"name\":\"How do you unmerge cells in Excel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Select the merged cell, go to the Home tab, click the Merge &amp; Center dropdown and choose Unmerge Cells. The value stays in the top-left cell and the others become blank.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553057983\",\"position\":5,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553057983\",\"name\":\"What is the shortcut to merge cells in Excel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"There is no single default key, but you can press the ribbon sequence Alt, H, M, C for Merge &amp; Center. You can also add Merge &amp; Center to the Quick Access Toolbar for a one-key shortcut.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553068152\",\"position\":6,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-merge-cells-in-excel#faq-question-1790553068152\",\"name\":\"Should you merge cells in Excel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Only for display elements like a title across the top of a report. Never merge inside a data range, because it breaks sorting, filtering and copying. For centred headings, use Center Across Selection (Format Cells > Alignment) instead.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"}]}<\/script>","yoast_head_json":{"title":"How to Merge Cells in Excel (and When Not To)","description":"How to merge cells in Excel with Merge & Center, combine cells without losing data, unmerge, fix greyed-out merge, and when to avoid merging.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel","og_locale":"en_US","og_type":"article","og_title":"How to Merge Cells in Excel (and When Not To)","og_description":"How to merge cells in Excel with Merge & Center, combine cells without losing data, unmerge, fix greyed-out merge, and when to avoid merging.","og_url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel","og_site_name":"Dynamic Web Training Blog","article_publisher":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_author":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_published_time":"2026-09-27T23:53:12+00:00","article_modified_time":"2026-09-27T23:53:14+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/09\/DWT-Excel-Merge-hero.png","type":"image\/png"}],"author":"Dynamic Web Training","twitter_card":"summary_large_image","twitter_creator":"@dynamicwebtrain","twitter_site":"@dynamicwebtrain","twitter_misc":{"Written by":"Dynamic Web Training","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#article","isPartOf":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel"},"author":{"name":"Dynamic Web Training","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233"},"headline":"How to Merge Cells in Excel (and When Not To)","datePublished":"2026-09-27T23:53:12+00:00","dateModified":"2026-09-27T23:53:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel"},"wordCount":1071,"publisher":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/09\/DWT-Excel-Merge-hero-1024x538.png","articleSection":["Microsoft Excel"],"inLanguage":"en-AU"},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel","name":"How to Merge Cells in Excel (and When Not To)","isPartOf":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#primaryimage"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/09\/DWT-Excel-Merge-hero-1024x538.png","datePublished":"2026-09-27T23:53:12+00:00","dateModified":"2026-09-27T23:53:14+00:00","description":"How to merge cells in Excel with Merge & Center, combine cells without losing data, unmerge, fix greyed-out merge, and when to avoid merging.","breadcrumb":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#breadcrumb"},"mainEntity":[{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553001213"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553015522"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553027733"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553045538"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553057983"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553068152"}],"inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel"]}]},{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#primaryimage","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/09\/DWT-Excel-Merge-hero.png","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/09\/DWT-Excel-Merge-hero.png","width":1200,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Training Blog","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/"},{"@type":"ListItem","position":2,"name":"Training","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training"},{"@type":"ListItem","position":3,"name":"Microsoft Excel","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel"},{"@type":"ListItem","position":4,"name":"How to Merge Cells in Excel (and When Not To)"}]},{"@type":"WebSite","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/","name":"Dynamic Web Training Blog","description":"The Ultimate Training Experience.","publisher":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-AU"},{"@type":"Organization","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization","name":"Dynamic Web Training","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","width":361,"height":109,"caption":"Dynamic Web Training","name":"Dynamic Web Training Logo","description":"Dynamic Web Training official site logo asset"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/x.com\/dynamicwebtrain"]},{"@type":"Person","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233","name":"Dynamic Web Training","image":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","caption":"Dynamic Web Training"},"description":"This article is written by a senior writer at Dynamic Web Training. Our specialist writers are either Microsoft Certified Trainers, Adobe Certified Professionals or Certified Xero Advisors.","sameAs":["https:\/\/www.dynamicwebtraining.com.au","https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/www.instagram.com\/dynamicwebtraining\/","https:\/\/www.linkedin.com\/company\/dynamic-web-training","https:\/\/x.com\/dynamicwebtrain","www.youtube.com\/@dynamicwebtraining8740"],"url":"https:\/\/www.dynamicwebtraining.com.au"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553001213","position":1,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553001213","name":"How do you merge cells in Excel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Select the adjacent cells, go to the Home tab, and click Merge &amp; Center in the Alignment group. Use the dropdown for Merge Across, Merge Cells (no centring) or Unmerge Cells.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553015522","position":2,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553015522","name":"How do you merge cells in Excel without losing data?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Merge &amp; Center keeps only the top-left value, so to combine text use a formula instead: =A2&amp;\" \u201c&amp;B2, or =TEXTJOIN(\u201d \",TRUE,A2:C2) for a range. Then Paste Special > Values if you want to replace the originals.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553027733","position":3,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553027733","name":"Why can\u2019t I merge cells in Excel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"The Merge &amp; Center button is usually greyed out because your data is inside an Excel Table (convert it to a range first), the sheet is protected (unprotect it), or you are still editing a cell (press Enter or Esc).","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553045538","position":4,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553045538","name":"How do you unmerge cells in Excel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Select the merged cell, go to the Home tab, click the Merge &amp; Center dropdown and choose Unmerge Cells. The value stays in the top-left cell and the others become blank.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553057983","position":5,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553057983","name":"What is the shortcut to merge cells in Excel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"There is no single default key, but you can press the ribbon sequence Alt, H, M, C for Merge &amp; Center. You can also add Merge &amp; Center to the Quick Access Toolbar for a one-key shortcut.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553068152","position":6,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-merge-cells-in-excel#faq-question-1790553068152","name":"Should you merge cells in Excel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Only for display elements like a title across the top of a report. Never merge inside a data range, because it breaks sorting, filtering and copying. For centred headings, use Center Across Selection (Format Cells > Alignment) instead.","inLanguage":"en-AU"},"inLanguage":"en-AU"}]}},"_links":{"self":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/2767","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/comments?post=2767"}],"version-history":[{"count":1,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/2767\/revisions"}],"predecessor-version":[{"id":2769,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/2767\/revisions\/2769"}],"wp:attachment":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=2767"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=2767"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=2767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}