Merge Cells in Excel: The Easy Way and Safer Options

The easiest way to merge cells in Excel for Microsoft 365 on Windows is to select the cells, open Home > Merge & Center, and choose the merge option you want. For a simple heading across several columns, choose Merge & Center; before merging, check that only the top-left cell contains information you need to keep.

Merge cells in Excel step by step

Use these steps when you want one larger cell made from adjacent cells in a worksheet:

Select the adjoining cells to combine. For example, select B1 through E1 if a heading should span four columns.
On the ribbon, select the Home tab.
In the Alignment group, open the arrow beside Merge & Center.
Choose Merge & Center, Merge Across, or Merge Cells, depending on the result you want.

The main Merge & Center button applies the currently shown merge command. If you only need to merge and center one selection, clicking the button is usually enough. Open its dropdown when you need a different option, such as merging without centering. If the button is unavailable, check whether you are editing a cell, selecting a protected worksheet, or working inside an Excel table; those conditions can prevent merging.

To reverse a merge, select the merged cell and use Home > Merge & Center > Unmerge Cells. Unmerging restores the individual cell grid, but it does not bring back any values discarded during the original merge.

What the Excel merge options do

The dropdown contains options that sound similar but behave differently. Selecting the right one matters, especially when your selection covers more than one row.

Merge & Center combines the selected cells into one cell and centers the remaining content horizontally.
Merge Across merges cells across each row of the selection separately. If you select B2:D4, Excel creates one merged cell in row 2, another in row 3, and another in row 4. It does not turn the whole block into a single cell.
Merge Cells combines the selection into one cell without applying horizontal centering. Existing alignment settings may still affect where the content appears.
Unmerge Cells separates a merged area back into its component cells.

Vertical alignment is separate from horizontal centering. If a merged heading needs to sit in the middle vertically, select it and use the vertical alignment controls in Home > Alignment. Merging changes the cell area; it does not automatically apply every formatting choice you might want.

What happens to data when cells are merged

A merged range can hold only one cell value: the value from its upper-left cell. If you select a range where other cells also contain content, Excel warns that merging keeps only the upper-left value and discards the other values. For example, if B1 contains “Quarterly” and C1 contains “Sales,” merging B1:C1 will keep “Quarterly” and remove “Sales” from the worksheet cell contents.

Do not treat merging as a way to join text from multiple cells. If you need to preserve every label, copy or combine the information into the upper-left cell before merging, or use an appropriate text-joining method. If the original text matters, keep a backup or duplicate the data first. Once the merge has been completed and the action can no longer be undone, unmerging will not recover the discarded content.

For a normal heading, put the complete heading in the leftmost cell of the selected range, clear the other cells, and then merge. This avoids the warning and makes it clear which content will remain. Also check formulas that refer to cells in the range: after a merge, the merged area is represented by its upper-left cell, so references or calculations that depended on other cells may no longer behave as intended.

When merging is useful—and when to avoid it

Merging is most useful for presentation rather than data structure. A title above a small report, a label spanning a group of columns, or a form heading can look tidy when it occupies a wider area. These are usually isolated layout elements, not cells that people need to sort, filter, or analyze as records.

A useful rule is to keep the data grid itself unmerged. In a list of orders, for instance, each row should have a value in each relevant column: date, customer, product, and amount. Merging customer cells across several order rows may make the sheet look grouped, but it interferes with treating each row as a complete record. It can also make it harder to select, copy, paste, sort, or filter the data consistently.

Excel does not allow merged cells inside a formatted Excel table. If the merge command is disabled while a table cell is selected, the table may be the reason. Keep the table unmerged and put a heading above it instead. This preserves table features such as structured data entry and filtering while still letting you format a title area separately.

For a worksheet that will be shared, reviewed with assistive technology, or used as a source for charts and analysis, a regular grid is generally easier to navigate. Merged cells can make keyboard movement and selection less predictable because one displayed cell occupies several worksheet positions. Use them sparingly, and consider a non-merged visual alternative when the sheet is primarily for data work.

Center a heading across columns without merging

If the goal is simply to make a heading look centered over several columns, Excel has a safer alternative called Center Across Selection. It centers the text visually across the selected cells without combining them into one cell. The individual cells remain available, which can avoid some of the selection and data-layout problems associated with merged areas.

To apply it in Excel for Microsoft 365 on Windows:

Enter the heading in the leftmost cell of the range and select the range it should appear across.
Open the Format Cells dialog with Ctrl+1.
Select the Alignment tab.
Under Horizontal, choose Center Across Selection, then select OK.

This option changes alignment rather than combining cells, so it does not discard values in neighboring cells. However, the heading still needs room to display; existing content in adjacent cells can affect what is visible. Keep the other cells in the selected heading range empty for a clean result. On Mac, open Format Cells with Command+1; the Center Across Selection setting is also found on the Alignment tab. The exact dialog appearance can vary slightly by Excel version.

Use actual merging when you specifically need a single larger cell, such as for a form layout. Prefer Center Across Selection when you want a centered heading but want to keep the worksheet cells separate. Neither option should replace a well-structured data table.

Common problems and how to fix them

If merging does not work as expected, the cause is often the selection or worksheet context rather than a complicated setting. Check these common cases:

The button is grayed out: You may be editing a cell, working in a protected sheet, or selecting cells inside a formatted table. Finish editing, review the sheet’s protection settings if you have permission, or place the heading outside the table.
Excel says some content will be lost: More than one selected cell contains a value. Cancel if you need all the content, move or combine it first, and then merge.
The result is not one large cell: You may have selected Merge Across. That option creates separate merged cells for each row. Select the range again and choose Merge Cells or Merge & Center for a single merged area.
The text appears off-center: Merge Cells does not add horizontal centering. Use Merge & Center or set the horizontal alignment separately. Adjust vertical alignment if needed.
Sorting becomes awkward or fails: Merged cells can conflict with the consistent rectangular ranges sorting expects. Unmerge the data area and ensure each record has a value in its own row and column.
Unmerge leaves blank cells: That is expected. Excel returns the grid but retains the value only in the upper-left cell; it does not fill the other cells automatically.

If a sheet has many merges, it may be faster to inspect the layout before making broad changes. Unmerging a large range can change how headings appear, so save a separate copy when preserving the original presentation is important.

Excel for Mac and Excel for the web

In Excel for Mac, the basic ribbon route is also Home > Merge & Center, with the merge choices available from its dropdown. The names and general behavior of the options are the same. The main shortcut difference relevant to the alternative alignment method is that Command+1 opens Format Cells on Mac, while Ctrl+1 does so on Windows.

Excel for the web also offers merge controls on the Home tab, though the ribbon may look different from the desktop app and some options can be arranged differently depending on the window size. Select the cells, open the merge control, and confirm which option is being applied. If a workbook has complex formatting or a merge command is unavailable in the browser, opening it in the desktop version may provide more complete controls. Avoid assuming that a visual merge solves data-layout issues; the same practical limits about keeping only the upper-left value still matter.

Frequently Asked Questions

What is the shortcut to merge cells in Excel?
On Windows, press Alt, then H, then M, then C to activate Merge & Center through the ribbon KeyTips. KeyTips can vary with ribbon configuration and Excel version, so the reliable route is Home > Merge & Center. Mac does not use that Windows Alt sequence; use the Home tab’s merge control.

Can I merge cells without losing data?
Only one value can remain in the merged cell: the value in the upper-left cell. Move or combine other values into that cell before merging, or choose Center Across Selection if you only need a centered appearance and want to keep the cells separate.

How do I merge cells without centering the text?
Select the range, then use Home > Merge & Center > Merge Cells. This merges the range without applying horizontal centering. You can also adjust alignment afterward using the controls in the Home tab.

Can I merge cells in an Excel table?
No. Excel does not support merging cells within a formatted table. Put a merged heading above the table, or use Center Across Selection in a range outside it if you only want the heading to span visually.

How do I undo a merge?
Select the merged cell and choose Home > Merge & Center > Unmerge Cells. This restores the individual cells, but any values removed when the cells were first merged are not restored. Use Undo immediately if you need to reverse a recent merge and its data loss.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.