Excel Merge Cells Shortcut: Keys and Tips

In Excel for Microsoft 365 on Windows, select the cells and press Alt, H, M, C in sequence to use Merge & Center. To merge without centering, press Alt, H, M, M. These are ribbon KeyTips: press and release each key in order, rather than holding them all down together.

What the merge shortcut does

Merging turns a selected rectangular range into one larger cell. The merged cell keeps the value or formula from the range’s upper-left cell; content in the other cells is discarded. The Merge & Center command also centers the retained content horizontally. Merge Cells performs the merge without applying that centering command.

For example, if A1 contains January and B1 is empty, selecting A1:B1 and using Merge & Center creates one cell spanning both columns, with January centered inside it. If both A1 and B1 contain text, January remains and the content of B1 is lost. Merging is therefore a layout operation, not a way to combine the values in several cells.

How to use the Windows key sequence

Select the cells you want to merge. They must form one continuous rectangle, such as A1:C1 or A1:B3.
Press and release Alt. Excel displays KeyTips over the ribbon tabs.
Press H for the Home tab, then M to open the Merge & Center menu.
Press C for Merge & Center, or press M for Merge Cells.

If the letters shown on your ribbon differ, follow the visible KeyTips. The letters are designed to navigate the ribbon, so they can be affected by the Office interface, language, or version. Pressing Alt and then watching the screen is a useful way to confirm the next key instead of guessing.

You can also use the mouse: on the Home tab, in the Alignment group, open the arrow beside Merge & Center and choose the command. The main button applies Merge & Center; the arrow exposes the other merge options. The mouse route is useful when you are learning what each command does or when KeyTips are unavailable.

Merge options and what each one means

The menu offers several commands, and the distinction matters when you have more than one row or want to keep the current alignment.

Merge & Center: Merges the selection into one cell and centers the surviving content horizontally.
Merge Across: Merges cells across each row of the selected range separately. Selecting A1:C3 creates three merged cells, one per row, rather than one large A1:C3 cell.
Merge Cells: Merges the selected range into a single cell without the centering action of Merge & Center.
Unmerge Cells: Splits a merged cell back into its individual cells. It does not restore values that were discarded during the original merge.

Merge Across is handy for repeated row headings. If A1:C3 contains a label in A1, A2, and A3, selecting the full block and choosing Merge Across gives each row its own merged space. Check the contents first: each row’s leftmost cell supplies the content for that row’s merged result.

Check cell contents before merging

Excel does not join multiple cell values when it merges. It retains only the upper-left cell’s content and warns that other values will be removed when the selected range contains more than one populated cell. This is the most important consequence to understand before using the shortcut. A blank-looking cell may also contain a formula, a space, or data that is not obvious at the current zoom level.

For example, suppose A1 contains North and B1 contains Region. Merging A1:B1 does not produce North Region; it keeps North and removes Region. If the goal is to combine text, first place the combined result in another cell with an appropriate formula or use another data-preparation method, then verify the result before considering a layout change.

A safe habit is to inspect the selected range in the formula bar and keep a copy of important source data before merging. If Excel displays a warning about losing data, pause and cancel if the values matter. Undo with Ctrl+Z immediately after an accidental merge if possible, but do not rely on undo as a long-term recovery plan—especially after other workbook changes.

Limitations that can affect worksheets

Merged cells can make a worksheet look tidy, but they change the shape of the grid. A merged region is not a group of ordinary independent cells: only its upper-left cell is the actual cell used for the stored content. That can make formulas, selections, and later editing less straightforward than they appear visually.

Sorting: A sort may be blocked or behave unexpectedly when the sort range includes merged cells of inconsistent sizes. A normal rectangular data table is easier to sort when each record has a value in its own cell.
Filtering: Merged headings or data cells can complicate selecting and filtering a range. Keep the table’s column headers and records unmerged when you need standard filter behavior.
Copying and pasting: Copying a merged area into a differently sized range can produce a mismatch warning or an awkward result. The destination needs to accommodate the merged shape.
Selecting cells: Clicking inside a merged region selects the merged cell as a whole, not one of the original positions. This can make it harder to target a specific row or column.
Accessibility and screen readers: A regular grid with clear labels is generally easier to navigate than a layout that relies on merged cells to communicate structure.

These constraints do not mean merging is always wrong. A merged title above a small report can be perfectly practical. The concern is using merged cells inside a working data table that needs regular sorting, filtering, copying, or analysis.

Alternatives when you only want a centered heading

If your purpose is to center a heading across several columns, but you want the underlying cells to remain separate, use Center Across Selection instead of merging. Select the cells, open the Format Cells dialog, choose the Alignment tab, and set the Horizontal option to Center Across Selection. On Windows, Ctrl+1 opens Format Cells. This alignment option displays the text centered across the selected span while preserving separate cells.

Another simple option is to put the heading in one cell and adjust the column widths or alignment. For structured data, keep headings and values in individual cells and use cell formatting—such as alignment, fill color, borders, and bold text—to create visual hierarchy without changing the grid.

Choose the approach based on what the worksheet must do:

Use Merge & Center for a decorative title or label where a single merged cell is acceptable.
Use Center Across Selection when you want the same broad centered appearance but need the cells to remain independent.
Keep cells unmerged in tables that people will sort, filter, copy, or use for analysis.

Excel for Mac and Excel for the web

The Alt, H, M, C and Alt, H, M, M KeyTip sequences described above are for Excel desktop on Windows. Excel for Mac does not use that same Windows ribbon sequence. On a Mac, select the range and use the Home tab’s Merge & Center menu. Keyboard behavior can depend on the Mac version and keyboard settings, so use the visible menu or KeyTips where available rather than assuming the Windows keys will work.

In Excel for the web, select the range and use Home > Merge & Center and its menu. Browser and web-app keyboard handling can differ from the Windows desktop application. If a shortcut is intercepted by the browser or does not reveal Excel KeyTips, use the ribbon command. In all versions, check for content in cells other than the upper-left one before merging.

Common shortcut problems

If the sequence appears to do nothing, check that Excel has focus and that you are pressing the keys in order: Alt, H, M, then C or M. The sequence is not a single simultaneous key combination. Pressing Alt should show the ribbon KeyTips; if it does not, another window or interface element may have focus.

If the merge command is unavailable, confirm that you selected a suitable range and that Excel is not in a state that prevents editing, such as editing the contents of a cell. Press Esc to leave cell-editing mode, select the range again, and open the Home tab. Also check whether the worksheet is protected; protection settings can restrict formatting changes.

If you merge and later decide the layout is inconvenient, select the merged cell and choose Home > Merge & Center > Unmerge Cells. Unmerging restores the cell grid, but the original content of the non-upper-left cells does not return. Undo may restore those values if the merge is still the most recent action.

Frequently Asked Questions

What is the shortcut to merge cells in Excel without centering?
On Excel for Microsoft 365 for Windows, select the range and press Alt, H, M, M in sequence. This opens Merge Cells, which merges without applying the centering action of Merge & Center.

Does merging cells combine their text?
No. Excel keeps the content in the upper-left cell of the selected range and removes content from the other cells. To combine text, create the combined result separately before changing the layout.

Can I merge cells and keep all their data?
Not with the merge command itself. It does not concatenate values. Keep the original data in separate cells or create and verify a combined value elsewhere before merging a display area.

How do I unmerge cells in Excel?
Select the merged cell, then choose Home > Merge & Center > Unmerge Cells. The cells become separate again, but values removed during the merge are not restored by unmerging.

Why can’t I sort a range that contains merged cells?
Merged regions can make the rows or columns in a sort range uneven, so Excel may reject the operation or produce a layout that is difficult to manage. Unmerge cells in the data table and keep one value per cell when sorting is important.

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.