To merge cells in Excel for Microsoft 365 on Windows, select the adjacent cells, then choose Home > Merge & Center. Excel keeps the content in the upper-left cell and removes content from the other selected cells, so check the range before confirming. Merging is useful for headings and labels, but it can make data harder to sort, filter, or work with in formulas.
The steps below explain the merge choices, how to undo a merge, and what to do if your worksheet behaves unexpectedly. The ribbon layout is for Excel on Windows; notes call out relevant differences for Mac and the web version.
What You’ll Need
- An Excel workbook you can edit, with the cells you want to combine visible on the worksheet.
- A rectangular selection of adjacent cells. You can merge cells across columns, rows, or both, but you cannot merge separate, non-adjacent selections in one action.
- A quick check of the selected cells for content. Excel retains only the value in the upper-left cell of the range when you merge.
Step-by-Step
- Open the worksheet and identify the purpose of the merge. Merging works best for a heading spanning several columns, or for a label that should cover a group of rows. It is usually not a good choice for the cells that hold the actual records in a data table. If you need to combine text from several cells rather than create one larger cell, use a formula or edit the text instead; merging does not join the contents.
- Select the cells you want to merge. Click the first cell, then drag across the range, or click the first cell and Shift-click the last one. For example, selecting B2 through E2 creates a single horizontal area for a heading. Selecting B2 through B4 creates one vertical area. The cells must form one continuous rectangle, and they must not already be part of an Excel table.
- Check the selection for content before merging. Look across the highlighted cells, not just at the text currently visible. A cell may contain a number, formula, date, or text even if its display looks blank because of formatting or a narrow column. If you need to keep several values, cancel the merge and move or combine those values elsewhere first. Excel may display a warning that only the upper-left value will be kept; read it and choose the option to proceed only if that is what you intend.
- Open the merge menu. On the Windows ribbon, select Home, find the Alignment group, and open the arrow beside Merge & Center. If the full button is visible, its small arrow opens the menu. You can also use the ribbon Key Tips: press Alt, then H, then M to open the merge choices. Press the letters one after another, not as a simultaneous shortcut.
- Choose the option that matches the layout. Select Merge & Center to make one cell and center its remaining content. Select Merge Cells to make one cell without centering the content. Select Merge Across to merge each row of the selected range separately; for example, selecting B2:D4 produces three merged cells, one per row. Avoid assuming that Merge Across makes one large block: it processes the selection row by row.
- Review the result and adjust the formatting. Click the merged area and check that the intended value is present and positioned as expected. If the text is cut off, widen the columns or increase the row height. To change alignment, use the horizontal and vertical alignment buttons in Home > Alignment. You can also use Wrap Text if a heading needs to display on multiple lines.
- Undo or unmerge if the result is wrong. Immediately after merging, press Ctrl+Z on Windows to undo the action. To keep the worksheet but separate the cells again, select the merged cell and choose Home > Merge & Center > Unmerge Cells. Unmerging restores the individual cell grid, but it does not restore values discarded from the other cells when the merge was made.
In Excel for Mac, select the range and use the Home tab’s merge control in the Alignment group; the available merge choices are similar, though the ribbon arrangement can vary with the window size and Excel version. There is not a direct Mac equivalent to the Windows Alt, H, M Key Tips sequence, so use the ribbon. In Excel for the web, select the range and use Home > Merge & Center or its dropdown when shown. The web ribbon may show fewer controls at narrow window widths. The same data-loss rule applies in all versions.
Common Mistakes
- Merging cells that contain separate data. Excel does not concatenate the contents. It keeps only the upper-left cell’s value and discards values in the rest of the selected range. If all entries matter, copy them to a safe location or combine them before merging.
- Using a merged cell inside a list or table. Merged cells can interfere with sorting, filtering, selecting consistent ranges, and adding rows. Excel does not allow cells within a formatted Excel table to be merged. Keep headings and record fields in separate, unmerged cells whenever you expect to analyze the data.
- Choosing Merge Across when you want one big cell. This option makes a separate merged cell for every row in the selection. For one large block, select the full rectangle and choose Merge Cells or Merge & Center instead.
- Thinking unmerge will recover erased entries. Unmerge Cells separates the cell area, but the values that were removed during the merge are not brought back. Use Undo right away if you need to reverse the merge and recover the prior state.
- Expecting the text to be combined automatically. Merging changes the cell structure, not the text. To preserve multiple labels, concatenate or relocate the text first, then merge only if a larger display area is still useful.
Tips
- Consider Center Across Selection for headings. It centers a heading across selected columns without actually merging the cells. In Windows, select the range, open the Home tab’s Alignment dialog launcher, choose the Alignment tab, set Horizontal to Center Across Selection, and select OK. This option usually keeps the worksheet easier to sort and edit than a merged range.
- Keep merges limited to presentation areas. A title row above a report is a sensible place to merge. The rows below it, where each row represents a person, date, sale, or other record, should generally remain a regular grid with one field per column.
- Plan the range before selecting it. Check the row and column headings so you do not accidentally include neighboring cells or the next row. A merged range can affect how nearby borders, alignment, and selection behave, so a deliberate selection saves reformatting later.
- Use clear formatting after a merge. A merged heading may need a border, fill color, or vertical alignment to make its relationship to the table clear. Apply formatting after merging and verify how it looks when printed or viewed at normal zoom.
- Save a copy before a large layout change. This is especially useful when merging many ranges in a report you may need to revise. Undo is convenient for a recent action, but a saved copy gives you a fallback if you continue editing after discovering a problem.
Troubleshooting
- The merge command is unavailable or disabled. Check whether the selected cells are inside an Excel table. If they are, use Table Design > Convert to Range only if you are willing to stop using the table’s structured features, then try merging again. Also check whether the worksheet is protected; depending on the protection settings, Excel may prevent formatting changes. You may need permission to unprotect it.
- Excel warns that only the upper-left value will remain. This is expected when other selected cells contain data. Choose Cancel, copy or move the values you need, and then merge. If you already proceeded, press Ctrl+Z immediately on Windows, or use the equivalent Undo command on Mac or in the web version, before making more changes.
- The heading is not centered or appears clipped. Confirm that you chose Merge & Center rather than Merge Cells, then check horizontal and vertical alignment. Increase the row height or column width, or turn on Wrap Text. A merged cell’s displayed width is determined by the combined columns, but its row height may still need adjustment.
- You cannot select, sort, or filter the range normally. Merged cells can create uneven cell shapes that selection and data tools do not handle like a regular grid. For a list, unmerge the cells and place headings in individual cells. For a heading that only needs centered appearance, use Center Across Selection instead.
- Unmerge leaves some cells blank. That is normal: after merging, the retained value belongs to the upper-left cell, and the other cells are empty. Unmerge does not distribute the retained value across the restored cells. Copy or fill the value into those cells only if that is appropriate for your worksheet.
Frequently Asked Questions
Can I merge cells without losing data?
Not if multiple selected cells contain values and you use Excel’s merge command: only the upper-left value is retained. Move or combine the other values first, or use Center Across Selection if you only want a centered heading without merging.
What is the difference between Merge Cells and Merge & Center?
Both create one cell from the selected range and keep the upper-left content. Merge & Center also centers that content horizontally. Merge Cells leaves its alignment as it was, so it may remain left-aligned.
Can I merge cells in an Excel table?
No. Excel does not allow merged cells within a formatted table. If merging is essential, convert the table to a normal range using Table Design > Convert to Range, understanding that table features such as structured references and automatic expansion will no longer apply in the same way.
Can I merge cells vertically or across several rows?
Yes. Select a vertical range and choose Merge Cells or Merge & Center to make one tall cell. To merge cells across several rows but keep each row separate, select the full range and choose Merge Across.
How do I unmerge cells in Excel?
Select the merged cell, then choose Home > Merge & Center > Unmerge Cells. This restores the separate cell boundaries but does not recover content that was discarded during the original merge.
Why should I avoid merged cells in a data list?
Merges can make rows uneven and disrupt sorting, filtering, copying, and range selection. Keep each record in its own row and each field in its own column; reserve merged cells for titles or decorative layout areas.
Related
- Hide Column C in Excel: Steps to Hide and Unhide It
- Excel ZIP Code Heat Maps: How to Build and Read Them
- Heat Map in Excel: How to Create One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Application Not Responding: Causes and FixesIf Excel says “Not Responding,” first give it a few minutes if you just opened a large file,…
- Excel Often Not Responding? Causes, Fixes, and PreventionIf Excel often shows Not Responding, it may be busy recalculating a workbook, waiting on an add-in, or…
- Out of Office in Outlook PWA: Set Automatic RepliesTo set an out-of-office message in Outlook PWA, open Settings, find Automatic replies, switch them on, write your…
- Excel Shortcut to Remove Filters: Clear vs Turn OffIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter off and remove the filter arrows.…
- Excel Insert Row Shortcut: The Fastest Way to Add RowsIn Excel for Microsoft 365 on Windows, select the row where you want a new row, then press…
- Identify Duplicate Rows in Excel: A Practical GuideTo identify entire duplicate rows in Excel, add a helper column and use COUNTIFS to compare each record…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.