Excel Merge Cell Shortcut: Keys and Safe Alternatives

In Excel for Microsoft 365 on Windows, press Alt, H, M, C in sequence to merge the selected cells and center their contents. These are ribbon Key Tips, not keys to hold down together; if you want a different merge option, press Alt, H, M and then choose the command’s letter.

The Windows shortcut and what it does

Start by selecting a rectangular range of cells. Press and release Alt, then H, then M, then C. Excel merges the selected range into one cell and centers the retained contents horizontally. For example, selecting A1:D1 and using the shortcut creates one merged cell spanning those four columns.

The sequence follows the ribbon’s Key Tips: H opens the Home tab’s commands, and M opens the Merge & Center menu. The final letter selects a command in that menu. If the letters shown on your screen differ, follow the visible Key Tips; they can vary with language, ribbon configuration, or Excel version.

To use a different command, press Alt, H, M, then choose:

C for Merge & Center.
A for Merge Across.
M for Merge Cells.
U for Unmerge Cells.

These commands are useful for different layouts, but they share an important behavior: merging does not combine the contents of all selected cells. Excel keeps the value or formula from the upper-left cell and discards contents in the other cells in the range.

Where to find the merge commands

The ribbon route is Home > Merge & Center, in the Alignment group. Select the drop-down arrow beside the button to see the available commands. If the ribbon is narrow, Excel may show the command as a compact icon or place it in a condensed group, but the Home tab remains the place to look.

The four options have distinct results:

Merge & Center merges the selection and centers its retained content horizontally.
Merge Across merges cells separately across each row of the selected range. It does not make the whole selection one large cell.
Merge Cells makes one cell from the selected range without applying horizontal centering as part of the command.
Unmerge Cells separates a merged cell back into its individual cells.

For instance, select A1:C3 and choose Merge Across. Excel makes three merged cells: A1:C1, A2:C2, and A3:C3. By contrast, Merge Cells makes one merged area covering A1:C3. Knowing which operation is selected prevents an unexpected layout, especially when working with several rows.

How to merge cells safely

Before merging, check that the range is the size you intend and that only its upper-left cell contains content you need to keep. Then follow these steps:

Select the cells to combine. A typical heading might use A1:D1, with the heading text in A1.
Check the selected cells for other values, formulas, or notes that should not be lost. Copy anything important elsewhere first.
Press Alt, H, M, C for a centered heading, or open Home > Merge & Center and choose the appropriate option.
Review the result and adjust column widths, row height, wrapping, or alignment if needed.

If Excel warns that merging keeps only the upper-left value, pause and review the range rather than dismissing the warning automatically. If the cells contain separate pieces of information, put them in a single cell using a suitable method before merging, or leave the cells unmerged. Merging is a layout operation, not a way to join text from multiple cells.

What happens to data and formatting

For a selected range such as B2:D2, Excel retains the content in B2, the upper-left cell, and removes the contents of C2 and D2 when the cells are merged. The discarded contents may include numbers, text, or formulas. If B2 is empty but C2 contains a label, the merge does not move that label into the new merged cell; the upper-left cell is still the one Excel preserves.

That can matter even when the cells look blank. A cell may contain a formula returning an empty string, a space, or a value hidden by formatting. Check the formula bar or select cells individually if you are unsure. If you have just merged by mistake, Ctrl+Z usually reverses the action immediately. Unmerge is not the same as Undo: it separates the area but does not restore content that was removed from other cells.

After a merge, the visible area behaves as one cell for many editing and selection tasks. It may inherit the appearance of the upper-left cell, so inspect borders, fill, number format, and alignment after the operation. If the result is not right, use Undo, correct the selection or formatting, and merge again rather than assuming unmerging will reconstruct the original range.

Merge Across versus Merge Cells

Choose Merge Across when each row needs its own merged heading or label. For example, selecting A1:C4 and choosing Merge Across creates four separate merged cells, one per row. This can be useful for a repeated report layout, although it still removes content from the non-leftmost cells within each row.

Choose Merge Cells when the entire selection should become one cell and you do not want the command to center the content. Choose Merge & Center when the entire selection should become one cell and its retained content should be centered horizontally. You can change alignment afterward, so centering does not determine whether merging is appropriate.

A common misconception is that Merge Across joins a block into one large region. It does not: it processes each row separately. Another is that Merge Cells combines words or numbers. It does not; it retains only the upper-left cell’s contents. If you need to concatenate text, use a text-joining approach in a separate cell instead of relying on merging.

When merged cells cause problems

Merged cells can make worksheets harder to sort, filter, copy, fill, and edit consistently. Excel expects many table operations to work with a regular grid of individual cells. A merged heading inside the data area can disrupt that grid, and a merged cell may not behave like an ordinary single cell when you select a range or paste data. The exact obstacle depends on the operation and the shape of the merged range.

For a clean worksheet structure, keep data in one value per cell and avoid merged cells inside a table that will be sorted or filtered. Use a merged heading above the table, if needed, rather than merging cells in the table’s records. For forms or presentation-style reports, merging can be acceptable, but test the sorting, filtering, and copy-and-paste actions the workbook needs before distributing it.

References to cells in a merged area can also be confusing: Excel treats the top-left cell as the cell containing the merged area’s content. If a formula, chart, or other worksheet feature needs a value from that area, refer to its upper-left cell. When a workbook is shared with others, explain the layout or keep the underlying data on a separate, unmerged sheet.

A safer alternative: Center Across Selection

If your goal is simply to center a heading over several columns while preserving separate cells, use Center Across Selection. It visually centers the text across the selected columns without merging them, so each cell remains available for sorting, filtering, copying, or data entry. This is often a better choice for headings above structured data.

To apply it in Excel for Windows:

Enter the heading in the leftmost cell of the range, such as A1, and select A1:D1.
Press Ctrl+1 to open Format Cells.
Open the Alignment tab.
In the Horizontal list, choose Center Across Selection, then select OK.

The heading remains in A1, while the cells B1:D1 remain separate and can still contain data if appropriate. The display may depend on the selection and the alignment settings, so make sure the heading is in the leftmost cell and the intended range is selected. Unlike Merge & Center, this setting does not turn the cells into a single cell.

Excel on Mac and in a browser

The Alt-based sequence in this answer is for Excel on Windows. Excel for Mac does not use that same Windows Key Tip sequence as a dependable merge shortcut. On a Mac, select the cells, open the Home tab, and use the Merge & Center drop-down. The available choices are similar, though the ribbon’s appearance and keyboard navigation differ from Windows.

In Excel for the web, select the range and use the merge command on the Home tab. The web app runs in a browser, where keyboard shortcuts can also be intercepted or affected by browser settings, so use the ribbon when a shortcut is unavailable. In all versions, verify the selection and the upper-left-cell rule before merging; those are more important than the particular method used to open the command.

Frequently Asked Questions

What is the shortcut to merge and center cells in Excel?
In Excel for Microsoft 365 on Windows, select the range and press Alt, H, M, C in sequence. It merges the range and centers the retained content horizontally.

How do I merge cells without centering the text?
Use Alt, H, M, M on Windows, or choose Merge Cells from the Home tab’s Merge & Center menu. You can also change the alignment after merging.

How do I unmerge cells in Excel?
Select the merged cell and press Alt, H, M, U on Windows, or choose Unmerge Cells from the Home tab’s merge menu. Unmerging does not recover values that were discarded during the original merge.

Does Excel keep all data when I merge cells?
No. Excel keeps the content from the upper-left cell of the selected range and discards content in the other cells. Copy or combine any information you need before merging.

Can I center a heading across columns without merging?
Yes. Use Center Across Selection in Format Cells > Alignment. It centers the display across the selected columns while leaving the cells separate.

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.