Excel Cell Merge Shortcut Keys and How to Use Them

In Excel for Microsoft 365 on Windows, select the cells and press Alt+H, M, then C to use Merge & Center. The related sequences are Alt+H, M, M for Merge Cells, Alt+H, M, A for Merge Across, and Alt+H, M, U to Unmerge Cells.

What the Excel merge shortcuts do

These are ribbon KeyTips: press and release each key in order rather than holding the whole sequence down at once. The first two keys, Alt+H, open the Home tab’s keyboard controls; M opens the Merge & Center menu; the final letter chooses an action. The sequences apply to the standard English-language ribbon in Excel for Microsoft 365 on Windows. KeyTip letters can differ in other interface languages or versions, so check the letters shown on your screen if the sequence does not work.

Alt+H, M, C — Merge & Center: combine the selected cells into one and center the remaining content.
Alt+H, M, M — Merge Cells: combine the selection without applying the centering behavior.
Alt+H, M, A — Merge Across: merge cells separately across each row in the selection.
Alt+H, M, U — Unmerge Cells: split a merged area back into its original grid of cells.

These are not four different shortcuts that start with a special merge key. They are keyboard routes through the ribbon, and the selected range determines what will be merged. If a KeyTip appears on screen, follow the letters displayed there; that is the most reliable guide for your current ribbon layout.

How to merge cells with the keyboard

First select a rectangular range of adjacent cells. You can drag across the cells, use Shift with the arrow keys to extend a selection, or type a range such as B1:D1 into the Name Box to the left of the formula bar and press Enter. Then press the sequence for the action you want. For example, to make a centered heading across B1:D1, select B1:D1 and press Alt+H, M, C.

You can also reach the commands with the mouse: go to Home > Merge & Center, or open the arrow beside that button to choose a different merge command. The dropdown is useful when you want to confirm the exact action before applying it, or when you forget a KeyTip. The keyboard route is quicker once familiar, but both methods use the same selection and have the same effect on cell contents.

Make sure the range contains only the cells you intend to combine. A selection that includes several rows and columns may become one large merged area with Merge Cells, while Merge Across treats each row separately. If the result is not what you wanted, press Ctrl+Z immediately to undo it before doing other work.

Choosing the right merge option

The four commands are not interchangeable. Merge & Center combines the selected range and centers its remaining value horizontally. Merge Cells also combines the range, but does not apply the centering behavior. Merge Across creates a separate merged cell for each row, which is handy for grouping several row labels. Unmerge reverses the merged-cell structure, but it cannot bring back content that was discarded when the cells were combined.

Use Merge & Center for a short heading that should sit visually over a set of columns, such as a report title above monthly figures.
Use Merge Cells when you need a merged area but want to keep the existing horizontal alignment rather than center the text.
Use Merge Across when each row needs its own combined label area. Selecting A2:C4 and choosing this command creates one merged cell across columns A:C in row 2, another in row 3, and another in row 4.
Use Unmerge Cells to restore the underlying cell grid when you need to edit, sort, or restructure the data.

For instance, a heading in A1 with “Quarterly sales” can be displayed across A1:D1 by merging that range. But if A1:D1 contains separate values that matter, merging is usually the wrong operation: only the upper-left cell’s content remains. Center Across Selection, discussed below, can often provide the same visual heading without combining cells.

What happens to data in the selected cells

When a selection contains more than one nonempty cell, Excel warns that merging keeps only the upper-left cell’s content and discards the other values. For a range B2:D2, the value in B2 is the one retained; content in C2 and D2 is removed. This applies whether the other cells contain text, numbers, or formulas. Do not assume that Excel will concatenate, stack, or preserve the values somewhere else.

If you need the information later, cancel the warning and copy or combine the contents before merging. You could put the original values in another area, save a backup copy of the workbook, or use a suitable formula to create a single text label in a separate cell. The right approach depends on whether the values are merely decorative or form part of your actual data.

A merged range also behaves differently from an ordinary range: the merged area is treated as one cell, whose address is its upper-left cell. That can complicate formulas, selection, copy and paste, and operations that expect a regular grid. Merged cells are especially awkward in data tables intended for sorting, filtering, or analysis. Keep raw records in unmerged cells, and reserve merging for presentation areas where the layout matters more than row-by-row manipulation.

Merge Across, Merge Cells, and unmerging

Merge Across is easy to confuse with Merge Cells. Suppose you select A1:C3. Merge Cells creates one merged area covering all three rows and all three columns, retaining only A1’s content. Merge Across instead makes three separate merged areas: A1:C1, A2:C2, and A3:C3. It retains the leftmost cell’s value in each row, so A2 and A3 can remain as the respective row labels. Any other nonempty cells in those row ranges are still at risk of being discarded.

Unmerge restores the individual cells in the range, but it does not restore values that were removed during the original merge. The retained content stays in the upper-left cell; the other cells become blank unless they already had separate contents for some reason, which is not a safe outcome to rely on. If you merged by mistake, Ctrl+Z is the best immediate fix because it can reverse the operation along with its data loss. Unmerging later only restores the grid, not the deleted information.

Common problems and practical fixes

The shortcut seems not to work: press and release the keys sequentially, and check that Excel has focus. In an English Windows interface, try Alt+H, then M, then the command letter. If KeyTips show different letters, use those instead.
The wrong shape was merged: undo with Ctrl+Z, select the intended range carefully, and choose Merge Cells or Merge Across as appropriate.
Excel warns about multiple values: stop and check the selection. Cancel if any value outside the upper-left cell must be retained.
Sorting or filtering is troublesome: unmerge cells in the data area and use a consistent value in each row. Merged cells interrupt the regular row-and-column structure many data tools expect.
The merge command is unavailable: check whether the worksheet is protected, whether you are editing a cell, and whether your selection is suitable. Excel tables also do not support merged cells within the table itself; convert or restructure the table only if that fits the workbook’s purpose.

A frequent misunderstanding is that Merge & Center combines the values in selected cells. It does not. It keeps the upper-left value and centers it in the merged area. Likewise, Unmerge is not a recovery command for values that were removed. Treat merging as a layout operation with a data consequence, not as a way to join text.

Alternatives that keep cells separate

If your goal is simply to center a heading over several columns, try Center Across Selection before merging. Select the cells, open the Format Cells dialog with Ctrl+1, choose the Alignment tab, and select Center Across Selection in the Horizontal list. This displays the value centered across the selected columns while leaving the cells separate. It is often a better choice for worksheets that may need sorting, copying, or further editing.

Other options may fit better depending on the task:

Wrap Text: keep a long label in one cell and let it display on multiple lines, rather than widening a merged region.
Adjust column widths: make room for a heading without changing the worksheet’s cell structure.
Repeat a label across cells: if every row needs a category or identifier for filtering and analysis, fill the value into each relevant row instead of merging.
Use borders and alignment: apply formatting to a range to create a visual group while keeping its cells independent.

Center Across Selection is a formatting choice, not a merge: the text remains in the leftmost selected cell, and the neighboring cells remain available. That distinction makes it useful for presentation without the sorting and data-loss issues associated with merged cells.

Mac and Excel for the web

The Alt+H, M sequences described above are for Excel on Windows. Excel for Mac does not use that same Windows KeyTip sequence as a universal merge shortcut. On a Mac, select the range and use the Home tab’s Merge & Center dropdown to choose Merge & Center, Merge Across, Merge Cells, or Unmerge Cells. Keyboard behavior can also depend on the Mac’s system settings and Excel version, so avoid assuming a Windows sequence will transfer directly.

In Excel for the web, use the Home tab and the Merge & Center dropdown after selecting the cells. The browser and web-app keyboard handling can differ from desktop Excel, so the ribbon menu is the dependable route if a desktop shortcut does not work. In either version, the data consequence is the same: merging retains the upper-left cell’s contents and can remove other selected values.

Frequently Asked Questions

What is the shortcut for Merge & Center in Excel?
In English-language Excel for Microsoft 365 on Windows, select the range and press Alt+H, M, C in sequence. These are ribbon KeyTips, not keys to hold down simultaneously.

What is the shortcut to merge cells without centering?
Use Alt+H, M, M on Windows to choose Merge Cells. It combines the selection without the centering behavior of Merge & Center.

Does merging cells combine their text?
No. Excel keeps the content in the upper-left cell and removes the contents of the other selected cells. Cancel the warning if you need to preserve those values.

How do I unmerge cells in Excel?
Select the merged area and press Alt+H, M, U on Windows, or use Home > Merge & Center > Unmerge Cells. Unmerging restores separate cells but does not recover discarded content.

Can I merge cells across each row separately?
Yes. Select the range and choose Merge Across, or press Alt+H, M, A on Windows. Excel merges each row’s selected cells separately and retains the leftmost value in each row.

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.