# How to Merge Cells in Excel (and When to Use Center Across Selection Instead) To merge cells in Excel, select the range you want, then go to Home > Merge & Center, or open the drop-down arrow beside that button for Merge Across, Merge Cells, and Unmerge Cells. Merging keeps only the value in the upper-left cell of the selection and permanently deletes everything else in the range, so when you need a centered heading over several columns without destroying the underlying data, use Format Cells > Alignment > Center Across Selection instead. That single distinction explains most of the frustration people run into with this feature. Merging is a layout tool that changes the structure of the grid. Center Across Selection is a formatting tool that changes only how text is displayed. Choosing the wrong one is the difference between a clean dashboard and a broken dataset. ## What Merging Cells Actually Does A worksheet is a grid. In current versions of Excel the grid holds 1,048,576 rows and 16,384 columns, and every position has a unique address such as A1, B1, or C1. Each address holds exactly one value. That is the fundamental rule that merging bends. When you merge A1 through C1, Excel does not create a wider cell that can hold three times the content. It removes the internal borders between those three positions and treats the whole area as a single address, A1, that happens to span three columns. Only the value and formatting of the upper-left cell survive. Anything sitting in B1 or C1 is discarded at the moment you confirm the merge. Behind the scenes, the workbook file records the change as a merged range in the worksheet's internal structure. That record is why merged cells behave differently from ordinary cells in sorting, pasting, and data import. The grid still exists underneath, it is simply hidden from the interface for that range. Three consequences follow directly from this design. The first is data loss. Excel warns you before merging a selection that contains values in more than one cell, but the warning is a confirmation prompt, not a recovery tool. Once you accept it, the extra values are gone. Undo (Ctrl+Z) can bring them back immediately. After a save and close, they are gone for good unless the file is stored in OneDrive or SharePoint with version history enabled, or you have a separate backup. The second is that a merged cell has no memory of the cells it absorbed. Unmerging restores the borders and the individual addresses, but it does not restore the deleted values. The text reappears only in the upper-left position and the other cells come back empty. The third is that merged ranges break assumptions built into Excel's data tools. Sorting, filtering, Excel Tables, PivotTables, and many import routines expect a clean grid with one value per address. A merge violates that expectation. ## How to Merge Cells in Excel, Step by Step The merge controls live in the Alignment group on the Home tab. The main button performs Merge & Center. A small drop-down arrow beside it exposes the other three commands. ### Merge & Center Select the cells you want to combine, then click Merge & Center. Excel joins the selection into one cell and horizontally centers whatever text is in the upper-left position. This is the version people mean when they say "merge and center," and it is the right choice for a title banner at the top of a report. If more than one cell in the selection contains a value, Excel displays a warning that merging will keep only the upper-left value. Click OK to proceed or Cancel to stop. ### Merge Across Merge Across joins cells row by row rather than into one large block. If you select A1:F3 and choose Merge Across, you get three separate merged cells, one spanning A1:F1, one spanning A2:F2, and one spanning A3:F3. Each keeps its own row's upper-left value. This is useful for a two-row or three-row header band where each row needs its own centered label. ### Merge Cells Merge Cells joins the selection into a single cell exactly like Merge & Center, but leaves the alignment unchanged. Use it when you want the combined area without forcing the text to the center. ### Unmerge Cells To unmerge cells in Excel, select the merged area and choose Home > Merge & Center drop-down > Unmerge Cells. The address grid returns, the content stays in the upper-left position, and the remaining cells become empty. If you select several merged areas at once, Excel unmerges all of them in one action. A common error appears when you try to unmerge a range that contains a partial overlap of merged areas, and Excel responds that the operation cannot be completed because the selection includes cells of different sizes. Selecting whole rows or clearing all merges first resolves it. ### The merge cells shortcut Excel has no default Ctrl-based shortcut for merging. The fastest keyboard route on Windows is the ribbon KeyTip sequence. - Alt, H, M, C merges and centers the selection. - Alt, H, M, A merges across, row by row. - Alt, H, M, M merges the selection without changing alignment. - Alt, H, M, U unmerges the selection. Press the keys one after another, not simultaneously. Small on-screen labels appear after Alt and after H to guide you. For a true one-key shortcut, add the command to the Quick Access Toolbar. Right-click Merge & Center on the ribbon and choose Add to Quick Access Toolbar. The button then sits in the top-left strip and responds to Alt plus its position number, so the first item in the toolbar becomes Alt+1. If you merge the same ranges repeatedly, a short macro is more reliable than any keystroke sequence. This example merges A1:F1 and centers the result: ```vba Sub MergeTitleRow() With Range("A1:F1") .Merge .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With End Sub ``` The VBA methods behind the ribbon are Range.Merge, Range.Merge with the Across argument set to True for row-by-row merging, and Range.UnMerge. Everything the interface does can be scripted this way, which matters when you need to apply the same header layout to dozens of sheets. ## How to Merge Cells Without Losing Data The reliable way to merge cells without losing data is to move the content out of the cells before you merge them. There are two practical strategies. ### Strategy 1: Combine the values first If the goal is a single cell that holds all the text, build the combined string in a helper column, then paste it back as a value, then merge. 1. In an empty column, write a formula that joins the cells. For a name split across A2 and B2, use =A2&" "&B2. 2. For three or more cells, TEXTJOIN is cleaner because it accepts a delimiter and can skip blanks: =TEXTJOIN(" ",TRUE,A2:C2). 3. Fill the formula down the helper column. 4. Copy the helper column, then use Paste Special > Values to replace the original cells with plain text. 5. Delete the helper column and the now-redundant original columns. 6. Merge the remaining cell with its empty neighbors, which triggers no warning because only one cell holds a value. CONCAT and the older CONCATENATE function do the same job as the ampersand operator. TEXTJOIN is the only one that handles delimiters and empty cells gracefully, and it requires Excel 2019 or Microsoft 365. ### Strategy 2: Do not merge at all If the goal is a heading that appears centered over several columns of data, you do not need to touch the data cells. Put the heading in the leftmost cell, select the heading cell plus the empty cells beside it, open Format Cells with Ctrl+1, go to the Alignment tab, and choose Center Across Selection from the Horizontal drop-down. The text displays across the full width, and every underlying cell keeps its own value, format, and address. This is the only method that satisfies both requirements at once: a centered visual result and an intact data structure. ### What to do if the data is already gone Press Ctrl+Z immediately. Excel keeps a deep undo stack within the current session, and the merge is a single reversible action. If the file was closed and reopened, check version history in OneDrive or SharePoint, or recover a previous copy from Excel's AutoRecover folder. Once the workbook has been saved, closed, and reopened without version history, the deleted values cannot be recovered from the file itself. ## Merge and Center Versus Center Across Selection: Key Differences | Feature | Merge & Center | Center Across Selection | |--|--|--| | Cell boundaries | Removed, one combined cell | Unchanged, cells stay separate | | Values in other cells | Deleted, only upper-left survives | Untouched, each cell keeps its own value | | Sorting and filtering | Breaks or behaves unpredictably | Works normally | | Excel Tables | Not permitted, Excel refuses the conversion | Fully supported | | Use as PivotTable source | Causes errors and layout failures | No effect | | Spanning multiple rows | Yes, a single block across rows | Applies row by row, no vertical merge | | AutoFit row height with wrapped text | Not supported | Works normally | | [Data validation](/blog/data-analysis/data-validation-excel-dropdown-rules) and conditional formatting | Applies only to the merged area | Applies per cell as expected | | Accessibility for screen readers | Header structure broken | Header structure preserved | | Best use | Report titles, form labels, callout boxes | Column headings above live data | The row-height point is one of the most common practical complaints. Excel does not auto-fit the height of a merged cell to accommodate wrapped text. You get clipped text and have to set the row height by hand. Unmerged cells with Center Across Selection auto-fit normally. ## How Center Across Selection Works Center Across Selection is a horizontal alignment option, not a merge command. It is buried in the Format Cells dialog (Ctrl+1) on the Alignment tab, which is exactly why so many people never find it. It does not appear on the Home tab ribbon in any version of Excel. The mechanic is simple. Excel takes the content of the leftmost cell in the selection and renders it centered across the selected width. The value never leaves its home cell. Click the heading and the formula bar still shows it stored in the first column. That means the heading can still be sorted with, filtered with, and referenced by formulas. There are limits worth knowing. Center Across Selection only works when the cells to the right are empty. If a neighboring cell holds a value, the centered text stops at that boundary and the effect collapses. The option is also horizontal only. There is no vertical equivalent, so a merged block that spans several rows to create a tall banner cannot be reproduced with alignment settings, you would need a merged cell, a text box, or a repeat of the label in each row. For a heading block that spans both rows and columns, a common pattern is a merged two-row banner above the sheet title and Center Across Selection headings beneath it, with the actual data starting below both. ## When to Use Which Merge and Center earns its place in three situations. Design surfaces. A dashboard title, a report banner, or a section divider that sits above the data and is not part of it can be merged freely. Nothing below depends on those cells. Printed forms. Labels on expense reports, inspection sheets, and intake forms often need to sit across several columns to match a paper layout. Merging is acceptable there because the sheet is a document, not a data model. Callout boxes. A cell holding a note, a caveat, or a legend can be merged to create the box shape. Center Across Selection is the better choice in these situations. Column headings over a live table. A heading that spans two columns, such as a "Customer Name" header covering First Name and Last Name, belongs in Center Across Selection. The data underneath stays sortable. Any range that will be used in a PivotTable, a chart source, or a Power Query import. Merged cells inject blanks into the data and cause fields to be misread or dropped. Sheets that will be filtered or sorted by other people. Merged cells create the familiar error about the operation requiring merged cells of identical size, and they hide filter arrows on the header row. Shared workbooks. Anyone who copies a row out of a sheet with merged cells gets unpredictable results on paste, because the copied block does not map cleanly onto the destination grid. The cleanest architecture separates the two jobs. Keep raw data on one sheet as a strict grid with one value per cell. Build a presentation sheet that references the data and uses merges freely for the layout. The data stays analyzable, and the report stays attractive. ## Common Mistakes and Limitations Merging the header row of a data table is the mistake that causes the most damage. The moment a header contains a merge, sorting fails, filtering disappears, and converting the range to an Excel Table is blocked with an error saying the feature cannot be applied to a range containing merged cells. The fix is to unmerge, use Center Across Selection, and reapply the filter. Pasting into a merged range fails often. If you copy a block of values and try to paste it over an area where the first cell is merged, Excel returns an error about not being able to change part of a merged cell. The paste has no way to distribute values across a region that reports as a single address. Merged cells break PivotTables in two ways. Merged cells inside the source data produce fields that read as blank, and merged cells in the area where the PivotTable will be placed cause a placement error. Always clear the target area of merges before inserting a PivotTable. Wrapped text in a merged cell will not auto-fit. The row height stays fixed and the final line gets clipped. You can size the row manually, but the height will not adjust again if the text changes length. Data validation applied to a merged cell covers the whole merged area as one unit. When you copy that cell to other rows, the validation rule migrates with the merge and can behave differently than a rule applied per cell. Conditional formatting has the same limitation, since only the upper-left cell of a merged range carries the formatting anchor. Keyboard navigation changes subtly. Pressing an arrow key from a merged cell jumps past the entire merged area rather than moving one column at a time. In a large sheet with many merges, this makes navigation feel inconsistent. Accessibility suffers. Screen readers rely on a consistent row and column header structure, and a merged cell flattens that structure so the reader cannot announce which column a value belongs to. Microsoft's own accessibility guidance recommends avoiding merged cells in data tables for this reason. Other software reads merged cells poorly. When a merged workbook is opened in R, pandas, or openpyxl, the non-anchor cells typically appear as missing values rather than as the repeated label. A file that looks fine in Excel can look corrupted in an analysis pipeline. The confirmation prompt can be turned off in Excel Options, under the Advanced category. Doing so removes the only guardrail against silent data loss, so leave it on unless you have a specific reason. Finally, merged cells do not survive every export. Converting a workbook to CSV flattens the grid and leaves only the upper-left value, with the absorbed cells appearing as empty fields on re-import. Keep an unmerged copy of any data you intend to export. ## Frequently Asked Questions ### How do I merge cells in Excel without a mouse? Press Alt, then H, then M, then C to merge and center the selected range. Use M, A for Merge Across, M, M for Merge Cells, and M, U for Unmerge Cells. ### Is there a keyboard shortcut for Merge & Center? There is no default Ctrl shortcut. The nearest equivalent is the KeyTip sequence Alt, H, M, C. For a single keystroke, add Merge & Center to the Quick Access Toolbar and press Alt plus its position number. ### Why did Excel delete my data when I merged cells? Merging keeps only the value in the upper-left cell of the selection and discards the rest. Press Ctrl+Z immediately to undo, or rebuild the content with TEXTJOIN before merging again. ### How do I unmerge cells in Excel? Select the merged area and choose Home > Merge & Center drop-down > Unmerge Cells. The cells return as separate addresses, with the content left in the upper-left position and the rest empty. ### What is the difference between merging cells and Center Across Selection? Merging removes the boundaries between cells and deletes all but the upper-left value. Center Across Selection leaves every cell intact and only changes how the text is displayed, so sorting, filtering, and Excel Tables continue to work. ### Can I merge cells inside an Excel table? No. Excel blocks conversion of a range containing merged cells into a Table, and merging inside an existing Table is not permitted. Use Center Across Selection for spanning headings above a Table instead. ### How do I combine the contents of two cells into one cell? Use the ampersand operator, as in =A2&" "&B2, or TEXTJOIN(" ",TRUE,A2:C2) for three or more cells. Copy the result, use Paste Special > Values, then delete the originals before merging. ### Does merging cells break sorting and filtering? Yes. Merged cells prevent reliable sorting, hide or disable filter controls, and trigger errors about merged cells of different sizes. Replace merges in data ranges with Center Across Selection to restore normal behavior. ## References 1. [Microsoft Support: Merge and unmerge cells](https://support.microsoft.com/office/merge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf) 2. [Microsoft Support: Find merged cells](https://support.microsoft.com/en-US/Excel/find-merged-cells) 3. [Microsoft Support: Wrap text in a cell in Excel](https://support.microsoft.com/en-us/excel/wrap-text-in-a-cell-in-excel) 4. [University of Wisconsin KnowledgeBase: Excel, how to merge cells](https://kb.wisc.edu/939) 5. [University of Illinois Answers: Excel, how to merge cells](https://answers.uillinois.edu/939) ## Related Articles - [How to Wrap Text in Excel: Ribbon, Shortcut and Line Breaks](/blog/data-analysis/how-to-wrap-text-in-excel) - [How to Freeze Rows and Columns in Excel (Step by Step)](/blog/data-analysis/how-to-freeze-panes-in-excel) - [How to Unhide Columns in Excel (Step by Step)](/blog/data-analysis/how-to-unhide-columns-in-excel) - [Excel Fill Handle: How to Autofill and Copy Data](/blog/data-analysis/excel-fill-handle) - [How to Remove Duplicates in Excel (Step by Step)](/blog/data-analysis/how-to-remove-duplicates-in-excel)