In Excel for Microsoft 365 on Windows, select the cells and press Alt, H, M, C—one key at a time—to merge them and center the contents. To merge without centering, press Alt, H, M, M; these are ribbon key sequences, not keys you hold down together.
The Windows shortcut and what it does
The sequence follows Excel’s ribbon Key Tips. Press and release Alt to display the ribbon letters, then press H for Home, M for the Merge & Center menu, and the final letter for an action. In an English-language desktop version, the main choices are:
- Alt, H, M, C: Merge & Center.
- Alt, H, M, M: Merge Cells.
- Alt, H, M, A: Merge Across.
- Alt, H, M, U: Unmerge Cells.
Use the sequence as separate key presses: press Alt and let go, then H, then M, then the last letter. If you hold Alt while pressing the other letters, Excel may not interpret the command as intended. The letters are Key Tips for the English ribbon; they can differ if the Office display language or ribbon setup differs. If a letter does not work, press Alt and follow the on-screen prompts instead.
The most familiar option, Merge & Center, combines the selected cells into one larger cell and centers the remaining value. It is useful for a heading over several columns, but it is not a way to combine all the selected cells’ contents. That distinction matters because merging can discard data.
What each merge choice means
Excel offers several related commands under Home > Merge & Center. The choice changes both the shape of the merged area and, in the centered option, the alignment of its content.
- Merge & Center creates one cell from the selection and centers the retained content horizontally.
- Merge Cells creates one cell without applying the centering command. The upper-left cell’s content and formatting are the ones that remain; check alignment if the result is not where you expect.
- Merge Across merges cells row by row, rather than making the entire rectangular selection one cell. Selecting A1:C3 and using this command creates three merged cells: A1:C1, A2:C2, and A3:C3.
- Unmerge Cells separates a merged area back into individual cells. It does not bring back values that were removed when the cells were merged.
These commands are not interchangeable. For example, selecting A1:C2 and choosing Merge & Center produces one cell spanning two rows and three columns. Choosing Merge Across produces one merged cell per row. Think about the layout you want before using the shortcut.
How to use the shortcut safely
For a straightforward heading, first make sure the intended text is in the upper-left cell of the range. Then select the whole range, run the shortcut, and inspect the result. For example, to center a heading in A1:D1, enter the heading in A1, select A1:D1, and press Alt, H, M, C. Excel merges the four cells and centers the heading across the resulting cell.
- Click the upper-left cell, or enter the heading there before merging.
- Select all the cells that should become one merged area. You can drag across them or use the Name Box to enter a range such as A1:D1.
- Check whether any other selected cell contains a value you need to keep.
- Press the appropriate key sequence, such as Alt, H, M, C.
- Review the merged area and its alignment. Use Alt, H, M, U to undo the merge later, but remember that unmerging does not restore discarded contents.
For a range with more than one row, decide whether you intend one large merged area or separate row-level merges. If your goal is a heading across columns for each row, Merge Across may fit; if the range is a data table, consider avoiding merges altogether.
Important: merging can remove cell contents
When a selected range contains more than one non-empty cell, Excel retains the content from the upper-left cell and discards the contents in the other cells. Excel may display a warning before completing the merge. Read it rather than dismissing it automatically. For instance, if A1 contains January and B1 contains February, merging A1:B1 does not create a cell reading January February. The retained value is January, and February is lost from the worksheet cells.
If you need to preserve multiple entries, copy or move them elsewhere before merging, or combine them into one cell using an appropriate method before you merge. A merged cell is still one cell; it does not hold a separate value for each of the cells that formed it. Be especially careful with names, dates, labels, or figures in a range that may look like a title area but contains real data.
Formatting deserves a check too. A merge changes the structure of the selected cells, and the resulting cell uses the upper-left cell as the basis for its contents and formatting. If the font, number format, borders, or alignment look wrong afterward, apply the desired formatting to the merged cell. Save a copy first if you are applying a large number of merges to important data.
Where to find the command without a shortcut
If you do not want to memorize the keys, select the cells and open Home > Merge & Center in the Alignment group. The main button applies Merge & Center; use its drop-down arrow to choose Merge Across, Merge Cells, or Unmerge Cells. This is also a useful way to confirm the command name before using a Key Tip sequence.
The ribbon route is often clearer when you are unsure which operation is appropriate, when the Key Tip letters differ in your language, or when you need to inspect the menu. The menu does not change the underlying behavior: merging still leaves only the upper-left cell’s contents. If you click the main button by mistake, use the drop-down to choose a different merge command, or unmerge and correct the layout. Do not rely on unmerging to recover deleted values.
Mac and Excel for the web
The Alt, H, M sequences described above are for Excel desktop on Windows. Excel for Mac does not use the same Windows ribbon Key Tips, so those keystrokes should not be assumed to work there. On a Mac, select the cells and use the Home tab’s Merge & Center control and its drop-down to select the desired option. The exact ribbon appearance can vary with the app layout, but the merge choices and the risk of losing values are substantially the same.
Excel for the web also provides merge commands on the Home ribbon. Select the range and use Home > Merge & Center, then choose the appropriate menu item. Keyboard behavior in a browser can depend on the browser and platform, so use the visible ribbon control rather than assuming the Windows desktop sequence will be available. Regardless of platform, verify which cell’s content will remain before merging.
When merged cells cause problems
Merged cells are convenient for presentation, but they can make a worksheet harder to work with. A merged area spans multiple grid cells while behaving as one cell for many editing tasks. That can complicate selecting a uniform rectangular range, filling values down a column, sorting, or resizing rows and columns. Operations that expect each record to occupy one cell per field may also behave unexpectedly when a table includes merges.
For a report title, a small heading, or a carefully formatted print layout, merging can be reasonable. For a list of records—such as customer names, dates, or sales—keep one value per cell and avoid merging across the data area. A useful design rule is to merge presentation headings only when they are outside the sortable or filterable table.
If you want text to appear centered over several columns without joining the cells, consider the alignment option Center Across Selection instead. In Excel for Windows, open Format Cells with Ctrl+1, choose the Alignment tab, and set Horizontal to Center Across Selection. This keeps the cells separate, which is often friendlier to data operations, though the appearance and behavior differ from a true merge. It is an alignment setting, not another merge shortcut.
Troubleshooting the key sequence
If Alt, H, M, C does not work, check the following before repeating it:
- Confirm the app: The sequence is for desktop Excel on Windows, not a universal shortcut for every spreadsheet app or platform.
- Press the keys in sequence: Tap and release Alt, then press H, M, and C separately. Watch the Key Tip letters that appear.
- Check the selection: Excel needs a selected cell range. The command may be unavailable or behave differently if the selection is part of a table or another restricted area.
- Use the ribbon: If the letters differ or the sequence is interrupted, click Home > Merge & Center and choose the operation from the menu.
- Inspect the contents: If a warning appears, cancel if you are unsure whether other selected cells contain values you need.
Key Tips are commands for navigating the ribbon, not permanent, application-independent shortcuts such as Ctrl+C. Excel displays prompts as you go, which makes the sequence easier to follow than memorizing a letter string alone.
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, one key at a time. This merges the selection and centers the remaining content.
What is the shortcut to merge cells without centering?
Use Alt, H, M, M in desktop Excel for Windows. It applies Merge Cells rather than the Merge & Center command.
Does merging cells combine their text?
No. Excel keeps the content from the upper-left cell and discards content in other selected cells. Combine or preserve values separately before merging if you need them all.
How do I unmerge cells in Excel?
Select the merged cell and press Alt, H, M, U in Excel for Windows, or use Home > Merge & Center > Unmerge Cells. Unmerging separates the cell area but does not restore values discarded during the merge.
Is there a merge-cells shortcut on Mac?
The Windows Alt, H, M sequence is not the Mac equivalent. On Mac, select the cells and use the Merge & Center control on the Home tab; check the menu for the exact merge option you need.
Related
- Excel Slicer: Connect One Slicer to Multiple PivotTables
- Excel Shortcut to Go to a Named Range
- Excel Showing Page Break Lines? How to Hide Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Create a Sheet of Labels in WordTo create a sheet of labels in Microsoft Word, open the Mailings tab, choose Labels, select the label…
- Google Sheets FILTER Function: Practical Examples and SetupIn Google Sheets, use FILTER to show only rows that meet one or more conditions. Enter a formula…
- Google Sheets Conditional Formatting for Entire RowsTo highlight an entire row in Google Sheets, select the rows’ full data range, open Format > Conditional…
- Why Can’t I Merge Cells in Google Sheets?You usually cannot merge cells in Google Sheets because the selection is not a single, adjacent rectangular range,…
- How to Create an Email Distribution List in OutlookTo create a reusable email list in Outlook, open People and create a contact group or contact list,…
- Excel vs CSV: Key Differences and When to Use EachExcel is spreadsheet software and a workbook format; CSV is a plain-text format for rows and columns. Choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.