re data integrity.
Merging cells in Excel means taking two or more selected cells and combining them into a single, larger cell. This unified cell then occupies the space of all the original cells, appearing as one continuous block. It’s primarily a visual formatting tool, often used for creating headings or labels that span across multiple columns.
Last updated: July 9, 2026
As of 2026, the core functionality remains consistent across Excel versions for Microsoft 365, Excel 2021, and earlier. When you merge cells, Excel prioritizes the content from the top-leftmost cell and discards any data in the other selected cells. This is a critical point that trips up many users, leading to unexpected data loss if not handled carefully.
The primary command for merging is found in the ‘Alignment’ group on the ‘Home’ tab of the Excel Ribbon. This simple button, often labeled ‘Merge & Center’, offers quick access to the most common merging operations.
One of the biggest areas of confusion for Excel users is the difference between merging cells and combining the text from multiple cells. While both result in text appearing in a single, larger area, their underlying mechanics and implications for your data are vastly different.
Merge & Center physically joins selected cells into one. If cells B2 and C2 contain separate text, merging them with ‘Merge & Center’ will keep only the content of B2 and delete C2’s content, then center B2’s content across the new merged cell. This is a formatting action.
In contrast, combining text uses formulas (like CONCAT or TEXTJOIN) to concatenate the strings from different cells into a new single cell, preserving all original data. For example, if B2 contains “First” and C2 contains “Last”, a formula like =CONCAT(B2," ",C2) in cell D2 would result in “First Last” in D2, while B2 and C2 remain untouched. According to Microsoft Support (2026), these functions are the recommended approach for true data combination rather than cell merging.
Understanding this distinction is crucial for maintaining data integrity. Merging is for presentation; combining is for data manipulation.
The most straightforward method to merge cells in Excel is via the Home tab on the Ribbon. This approach is intuitive and ideal for quick formatting tasks.
This method is quick and effective for simple headers. In my years working with Excel for client reports, I’ve found this is the go-to for visual titles, especially when the other cells are intentionally empty or contain redundant data.
Beyond ‘Merge & Center’, Excel offers other merging options that provide more control, particularly when dealing with multiple rows or columns. These can be accessed by clicking the small arrow next to the ‘Merge & Center’ button.
Merge Across: This option merges selected cells in each selected row separately. If you select cells A1:C3 and choose ‘Merge Across’, you’ll end up with three merged cells: A1:C1, A2:C2, and A3:C3. This is useful for creating multiple, identical-width merged headers across several rows without merging the rows themselves.
Merge Cells: This option merges the selected cells into a single large cell, similar to ‘Merge & Center’, but it doesn’t automatically center the content. The text remains aligned to the left (or whatever its original alignment was). This is preferred if you want to manually control the text alignment after merging.
These options are invaluable for structured data presentation. For instance, a financial report might use ‘Merge Across’ to create quarterly headers, each spanning three months, while maintaining distinct rows for different departments.
Just as easily as you can merge cells, you can unmerge them. This is crucial for fixing formatting mistakes or preparing your data for analysis that merged cells might otherwise disrupt.
Sometimes, the ‘Merge & Center’ button might appear disabled or grayed out. This usually happens when you’re trying to merge cells while in ‘Edit Mode’ (e.g., you’ve double-clicked a cell and the cursor is blinking inside it) or if the worksheet is protected. Exit edit mode or unprotect the sheet to resolve this.
The most significant drawback of using ‘Merge & Center’ is the inherent data loss. Excel explicitly warns you that only the top-left value will be retained. This can be devastating if you accidentally merge cells containing important information.
To merge cells visually without losing data, you must combine the content before merging the cells. Here are common strategies:
Using CONCAT or TEXTJOIN: These functions allow you to combine text from multiple cells into one. TEXTJOIN (available in Excel 2019 and Microsoft 365) is particularly powerful as it lets you specify a delimiter and ignore empty cells. For example, =TEXTJOIN(" ", TRUE, A1:C1) would combine the content of A1, B1, and C1 with spaces in between, ignoring any empty cells.
Ampersand (&) Operator: A simpler way to combine text is using the ampersand operator. For example, =A1 & " " & B1 & " " & C1 combines the content of A1, B1, and C1 with spaces in between. This is a quick solution for a few cells.
Copy-Paste Values: After combining text using a formula, copy the cell containing the formula, then use ‘Paste Special’ > ‘Values’ to paste the combined text into a single cell. You can then delete the original cells and merge the target cell if desired, or simply use the ‘Center Across Selection’ alternative (discussed below).
Always perform data combination in a separate column first. This ensures your original data remains intact, providing a safety net if something goes wrong during the merging process.
While visually appealing, merged cells introduce structural complexities that can hinder various Excel operations. This is a major reason why many Excel power users avoid them.
=SUM(A1:A5) will struggle if A2:A3 is merged.When we set up dashboards for clients, we explicitly advise against merged cells in any data tables to prevent these common issues. The long-term maintenance burden outweighs the short-term aesthetic gain. According to a 2026 analysis by Avantix Learning, issues with merged cells are among the most frequent formatting complaints from advanced Excel users.
Given the challenges, it’s often better to achieve the visual effect of merged cells using alternative formatting options that don’t compromise your spreadsheet’s functionality.
This is arguably the most powerful alternative to ‘Merge & Center’. ‘Center Across Selection’ makes text appear centered across multiple columns without actually merging the cells. This means each cell retains its individual identity, allowing for smooth sorting, filtering, and formula referencing.
Ctrl+1).This method provides the visual benefit without any of the functional drawbacks of merging. It’s an indispensable tool for maintaining clean, strong spreadsheets.
Indent and Alignment: For minor visual adjustments, simply increasing the indent or changing the horizontal alignment within a single cell can sometimes achieve a desired look without any merging.
Using Tables and Sections: For more complex layouts, consider structuring your data using Excel Tables (Ctrl+T) and clear, unmerged headers. Use borders and shading for visual separation rather than merging cells.
Managing cells effectively goes beyond just knowing how to merge or unmerge; it’s about making informed decisions that support your data analysis and presentation goals.
Keyboard Shortcuts: For speed, learn the keyboard shortcuts. While there isn’t one direct shortcut for ‘Merge & Center’, you can access it quickly via the Ribbon’s Alt key sequence: Alt + H + M + C for ‘Merge & Center’ or Alt + H + M + A for ‘Merge Across’.
Conditional Formatting for Visual Cues: Instead of merging for visual emphasis, use conditional formatting to highlight headers or specific data ranges. This keeps cells unmerged while still drawing attention. For example, applying a light grey fill to a header row for visual grouping.
Document Your Merged Cells: If you absolutely must use merged cells in a specific area (e.g., a final report presentation that won’t be analyzed further), clearly document their location. This helps collaborators understand potential limitations. A simple comment on the sheet can save hours of troubleshooting.
VBA Automation for Repetitive Merging: For advanced users dealing with large, structured datasets that require specific merging patterns (e.g., merging every two rows in a specific column), a simple VBA macro can automate this. A macro like Sub MergeRows() For i = 1 To 100 Step 2 Range(Cells(i, 1), Cells(i + 1, 1)).Merge Next i End Sub could merge cells in column A every two rows, saving immense manual effort.
Review Before Sharing: Before sharing any complex Excel workbook, especially one used for data entry or analysis, use Excel’s ‘Find & Select’ tool (on the Home tab) to locate all merged cells. Go to ‘Home’ > ‘Find & Select’ > ‘Go To Special…’ > ‘Merged Cells’. How to merge cells in excel allows you to quickly identify and address any potentially problematic areas.
Directly using ‘Merge & Center’ will always discard data from all but the top-left cell. To avoid data loss, combine the text content from multiple cells into a single cell using functions like CONCAT or TEXTJOIN before considering any visual merging or using the ‘Center Across Selection’ feature.
There isn’t a single direct keyboard shortcut like Ctrl+M for merging. However, you can use the Ribbon’s Alt key sequence: press Alt, then H (for Home tab), then M (for Merge & Center dropdown), then C (for Merge & Center) or A (for Merge Across).
The ‘Merge & Center’ button might be greyed out if you are currently in cell ‘Edit Mode’ (e.g., typing within a cell) or if the worksheet or workbook is protected. Exit edit mode by pressing Enter or Esc, or unprotect the sheet to enable the merge options.
To combine text, use the CONCAT or TEXTJOIN functions. For example, =CONCAT(A1, " ", B1) will combine the content of A1 and B1 with a space in between. TEXTJOIN is more versatile for multiple cells and custom delimiters. The ampersand (&) operator also works for simpler combinations.
‘Center Across Selection’ is a formatting option that horizontally centers text across a selected range of unmerged cells. It provides the visual appearance of a merged header without physically combining the cells, thus avoiding issues with sorting, filtering, and formula references that merged cells often cause.
Yes, merged cells, particularly in the header row of your source data, can severely disrupt PivotTable functionality. PivotTables require distinct, unmerged column headers to correctly categorize and aggregate data. Always unmerge headers before creating or refreshing PivotTables.
Merging cells in Excel, while a powerful visual formatting tool, comes with significant trade-offs for data integrity and functionality. As of July 2026, the core principles remain: use ‘Merge & Center’ cautiously and primarily for static, final presentation layers where data analysis won’t be performed. For most daily spreadsheet tasks, especially those involving data manipulation, sorting, or filtering, prioritize alternatives like ‘Center Across Selection’ or strong text-combining functions like CONCAT and TEXTJOIN.
By understanding these distinctions and employing best practices, you can create aesthetically pleasing spreadsheets that are also strong and easy to work with.
Last reviewed: July 2026. Information current as of publication; pricing and product details may change.
Editorial Note: This article was researched and written by the Be Open Source editorial team. We fact-check our content and update it regularly. For questions or corrections, contact us. For readers asking “How to merge cells in excel”, the answer comes down to the specific factors covered above.
Related read: Video Call Screen Shot: Essential Tips for 2026
Related read: Avoiding LCD Image Retention in 2026: Common Pitfalls &
Related read: RCA Tablet Serial Number in 2026: Your Definitive Guide to
Related read: How to Block Ads Effectively in 2026: A Multi-Layered Approach.
