In Excel for Microsoft 365 on Windows, press Alt, then H, M, and C to use Merge & Center on the selected cells. Press the keys in sequence rather than holding them all down; the command merges the selection into one cell and centers its remaining content.
The Windows shortcut and what the keys do
Excel’s ribbon KeyTips provide the keyboard sequence: Alt opens the KeyTips, H selects the Home tab, M opens the Merge & Center menu, and C chooses Merge & Center. The exact sequence is often written as Alt+H, M, C, but the commas matter: press Alt, release it, then press H, M, and C in turn. If a KeyTip shown on screen differs in a particular build or language, follow the letters displayed by Excel.
The command applies to the selected range. For example, if A1:D1 is selected, Merge & Center makes those four cells one wider cell and centers the content that Excel retains. If you have only one cell selected, there is no multi-cell range to merge, so select the intended cells first.
Other options in the same menu have their own KeyTip sequences on the standard English Windows ribbon:
- Alt, H, M, C: Merge & Center.
- Alt, H, M, A: Merge Across, which merges cells across each row of a selection separately.
- Alt, H, M, M: Merge Cells, which merges the selected range without applying the centering command.
- Alt, H, M, U: Unmerge Cells, which separates previously merged cells.
These are ribbon access sequences, not universal shortcuts that work in every language or on every keyboard layout. The on-screen KeyTips are the best confirmation if you use a localized version of Excel.
What each Merge & Center option does
Click the arrow beside Home > Merge & Center to see the available commands. Merge & Center combines the selected cells and centers the retained entry horizontally. Merge Cells combines them without the centering action. Merge Across makes a separate merged cell for each row in a multi-row selection; it does not turn the entire selection into one large rectangle. Unmerge Cells reverses the merged layout.
Consider a heading intended to span columns A through D. Selecting A1:D1 and choosing Merge & Center creates a single heading area across those columns. By contrast, selecting A1:D3 and choosing Merge Across makes one merged cell across A1:D1, another across A2:D2, and another across A3:D3. That can be useful for row-by-row labels, but it is not the same as merging all 12 cells into one.
The distinction between merging and centering is useful. A merged cell changes the worksheet’s cell structure; centering is an alignment choice. If the goal is only to make a title appear centered over several columns, there is a safer alternative discussed below that leaves the individual cells intact.
How to merge cells with the ribbon
If you prefer to confirm the command visually, or the keyboard sequence is unfamiliar, use the ribbon. This also makes it easier to notice which merge option you are choosing.
- Select the adjacent cells to be combined. Drag across them, or select the first cell, hold Shift, and select the last cell in the range.
- On the ribbon, open Home.
- In the Alignment group, select the arrow beside Merge & Center.
- Choose Merge & Center, Merge Across, or Merge Cells, as appropriate.
- Check the result and confirm that the displayed content is the content you intended to keep.
For a one-row column heading, select only that row’s cells. Avoid selecting extra rows or columns just because you want a larger visual area: the size and shape of the selection determine the merged result. If Excel warns that merging keeps only the upper-left value, stop if you need to preserve entries from other cells.
What happens to the data when cells are merged
Merging cells does not concatenate their contents. Excel keeps the value or text in the upper-left cell of the selected range and discards the contents of the other cells in that selection. For example, if A1 contains North and B1 contains South, merging A1:B1 leaves North as the cell’s content; South is not appended, joined with a space, or stored invisibly in the merged cell.
That makes it important to distinguish a decorative heading from a data table. A merged title above a table may be harmless when the other cells in the title row are empty. Merging cells that contain names, dates, amounts, or other records can remove data. Before merging, inspect the whole selection and copy any values you need to retain into another location or combine them deliberately using a suitable method.
Unmerging restores the individual cells, but it does not restore values discarded during the original merge. The former merged cell’s content remains in its upper-left cell; the other cells are blank. Undo may reverse a recent merge if it is still the latest action, but it is not a dependable recovery strategy after many later edits, closing the workbook, or making changes that cannot be undone.
When Center Across Selection is safer
For a heading centered over several columns, consider Center Across Selection instead of merging. It centers the text across the selected cells while preserving them as separate cells. This is often a better fit for worksheets that need to be sorted, filtered, copied, or used as structured data.
To use it in Excel for Microsoft 365 on Windows, select the cells, open the Format Cells dialog with Ctrl+1, choose the Alignment tab, open the Horizontal list, choose Center Across Selection, and select OK. The option changes alignment rather than merging the range. The heading text must be in the leftmost cell of the selected range for this layout to work as intended.
For example, suppose a report has columns A through D and a title in A1. Selecting A1:D1 and applying Center Across Selection makes the title appear centered over that span while B1, C1, and D1 remain separate cells. This is less disruptive than merging A1:D1, particularly if the row later becomes part of a range that needs ordinary cell-by-cell operations.
Center Across Selection is not a general substitute for every merge. It does not create one larger cell, and it does not make text from several cells into one value. Use it when the visual result is the priority and retaining the underlying cell grid is beneficial.
Common problems and how to avoid them
- The wrong text remains: Excel retains the upper-left entry. Check that cell before merging, and move or preserve any other values first.
- The selection merges in an unexpected shape: Review the selected range. Merge Across treats each row separately, while Merge & Center treats the whole selected range as one merged cell.
- Sorting or filtering becomes awkward: Merged cells can interfere with operations on tabular data, especially when merged areas do not have consistent sizes. Keep data records in unmerged cells and reserve merges for presentation areas outside the data grid.
- Copying, filling, or selecting ranges behaves unexpectedly: A merged area is not a normal rectangular set of independent cells. Unmerge it before carrying out an operation that assumes each position is a separate cell.
- The shortcut does not work: Make sure Excel has focus, select multiple cells, and press the KeyTips in sequence. If your ribbon language or version shows different letters, use the on-screen hints or click the ribbon command.
- The title looks off-center: Merge & Center centers horizontally, but it does not necessarily set vertical alignment or wrapping the way you want. Adjust those separately in the Alignment controls, or use Center Across Selection for a non-merged heading.
For tables meant to be analyzed, a reliable rule is to keep one record per row and one field per column, without merged cells inside the data area. Merging can be convenient for a report label, but it is usually a poor way to organize the underlying data.
Excel on Mac and Excel for the web
The Alt, H, M, C sequence is for Excel on Windows. Excel for Mac uses different keyboard conventions, and there is not a direct, dependable Mac equivalent to that Windows KeyTip sequence for every setup. On a Mac, select the cells, use the Home tab and its Merge & Center control, and choose the needed option from its menu. The exact keyboard behavior can depend on macOS settings, the Excel release, and the keyboard layout.
Excel for the web also provides the merge commands on the Home ribbon. The Windows KeyTip sequence may work in supported browser and keyboard configurations, but browser shortcuts can conflict with Excel or the browser, so the ribbon is the reliable fallback. In either environment, check the selected range and the data-loss warning before confirming a merge. The same key principle applies across versions: merging changes the cell layout and retains only the upper-left cell’s content.
Frequently Asked Questions
What is the shortcut for Merge & Center in Excel?
In Excel for Microsoft 365 on Windows, press Alt, H, M, C in sequence. Select the cells first; the command merges the selected range and centers the retained content.
Does Excel have a keyboard shortcut to merge cells without centering?
On the standard English Windows ribbon, press Alt, H, M, M for Merge Cells. It merges the selection without choosing the Merge & Center command. KeyTips can vary by language or ribbon version, so check the letters Excel displays if needed.
Will merging cells combine all their text?
No. Excel keeps the content from the upper-left cell of the selected range and discards the other entries. Copy or combine information separately before merging if you need to preserve it.
How do I undo a merge in Excel?
Use the Merge & Center menu and choose Unmerge Cells, or use the Windows sequence Alt, H, M, U where those KeyTips are available. Unmerging restores separate cells but does not recover values discarded when the cells were merged.
What can I use instead of merging a heading?
Use Center Across Selection when you want a heading to look centered over several columns while keeping the cells separate. In Windows Excel, find it in the Format Cells dialog under Alignment > Horizontal.
Related
- Excel Ungroup Columns Shortcut: Keys, Steps, and Fixes
- Excel Keyboard Shortcut to Zoom Out: Keys and Options
- Excel Row Height Shortcut: Set or AutoFit Rows
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel and Access: Key Differences and When to Use EachExcel is a spreadsheet for calculations, analysis, and flexible work with data; Access is a database program for…
- Google Sheets Growth Percentage Formula: How It Works and ExamplesTo calculate growth percentage in Google Sheets, subtract the earlier value from the later value, divide by the…
- Removing Formatting in Word: Clear Text and StylesTo remove formatting in Microsoft Word for Microsoft 365 on Windows, select the text and choose Home >…
- Data Validation Reference Table in ExcelA data validation reference table is a maintained list of approved values that Excel uses to control what…
- Excel Slicer Best Practices for Clear, Reliable ReportsFor reliable Excel slicers, start with a clean Excel Table or PivotTable, insert slicers only for fields people…
- Excel Data Model on Mac: What Works and What Doesn’tExcel for Mac does not include Power Pivot, so you cannot create, manage, or refresh a full Excel…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.