In Excel for Microsoft 365 on Windows, select the cells you want to merge, then press Alt, H, M, C in sequence to use Merge & Center. The shortcut merges the selection and centers its remaining contents; it does not combine the text from multiple cells, and Excel keeps only the value in the upper-left cell.
How to use the Excel merge shortcut
The Windows shortcut uses Excel’s ribbon Key Tips. Press and release each key in order rather than holding the whole sequence down at once:
- Select the adjoining cells you want to turn into one larger cell. For example, select B2:E2 for a heading spanning four columns.
- Press Alt, then H, then M, then C.
- Check the result. Excel merges the selected cells into one and centers the value from the upper-left cell.
The letters stand for the Home tab, the Merge & Center menu, and its Merge & Center command. If the sequence does not work, click the Home tab and look for the Merge & Center dropdown in the Alignment group. The dropdown is also useful when you want a different kind of merge.
Excel may display Key Tips after you press Alt. Those on-screen letters are a helpful guide if the ribbon layout or localization differs. The shortcut is for Windows desktop Excel; it is not the same as a general Ctrl-based shortcut such as Ctrl+C or Ctrl+V.
What the merge commands do
Merge & Center is only one choice in the dropdown. The commands make different layout changes, so choose based on how the cells are arranged and where you want the text to appear:
- Merge & Center: Combines the selected cells into one and centers the upper-left cell’s content. This is the command used by Alt, H, M, C.
- Merge Across: Merges cells across each row of the selected range separately. If you select B2:D4, Excel creates one merged cell for B2:D2, another for B3:D3, and another for B4:D4. The upper-left value in each row is retained.
- Merge Cells: Merges the selection into one cell without applying the centering behavior of Merge & Center. The content still comes from the upper-left cell.
- Unmerge Cells: Splits a merged area back into its individual cells. It does not restore values that were discarded when the cells were first merged.
To use one of the other commands, select the range and choose Home > Merge & Center dropdown, then select the desired option. The exact command label appears in the menu.
What happens to the data in selected cells
Merging cells is a formatting and layout operation, not a data-combination operation. If B2 contains Sales and C2 contains North, merging B2:C2 keeps Sales and removes North from the merged result. Excel typically displays a warning when more than one selected cell contains data. Read it before continuing: accepting the merge can discard the other contents.
Only the value in the upper-left cell of the selection is kept. With Merge Across, this rule applies to the upper-left cell of each row being merged. A blank upper-left cell does not cause Excel to move a value from a cell to its right. If you need any of the other values, copy or move them somewhere safe before merging.
Unmerging later restores the original cell grid, but it cannot reconstruct discarded content. If the merge was just made, Ctrl+Z can undo it while the action remains in the undo history. Once you have made further changes or saved and reopened the workbook, undo may no longer be available.
Merge cells or combine their contents?
These are two different tasks that are easy to confuse. Merging makes several adjacent cells behave as one larger cell on the worksheet. Combining text puts the values from separate cells together in a result, while leaving the original cells intact. To combine names, addresses, or labels, use a formula or another data-combination method instead of merging.
For example, with North in A2 and Region in B2, enter =A2&" "&B2 in C2. The result is North Region; the space between the two sets of quotation marks adds a space between the values. This formula does not change A2 or B2, and you can fill it down for other rows.
For several values, Excel’s TEXTJOIN function can join a range with a chosen separator. With the words North, Central, and South in A2:A4, enter =TEXTJOIN(", ",TRUE,A2:A4) in B2; the result is North, Central, South. The TRUE argument tells the function to ignore empty cells. If the goal is to combine information for analysis, keeping each piece in its own cell and creating a combined result is generally more useful than merging.
When merging is useful—and when it is not
Merging can make sense for a worksheet title that spans several columns, or for a visual label above a small report section. For example, if a report has figures in B:E, merging B1:E1 can create a centered heading above those columns. It can also be useful for a designed form where a label or instruction needs a wider space.
It is usually a poor choice inside a data table. Excel expects each record to occupy a consistent row and each field to occupy its own column. Merged cells break that regular structure and can make sorting, filtering, copying, selecting, and formula references less straightforward. Excel tables do not allow merged cells within the table body.
For a title, merge only the title area rather than entire rows of records. For labels in a report, consider whether the same visual effect can be achieved without merging. A worksheet can look polished while still keeping its underlying data in a simple rectangular grid.
Common problems with merged cells
- Excel warns that data will be lost: More than one cell in the selection has content. Cancel, review the values, and move or combine anything you need before trying again.
- The merge command is unavailable: Check that you selected a valid range of adjacent cells, and whether the selection is inside an Excel table. Merging is not supported within a table.
- A sort or filter behaves unexpectedly: Merged cells can interfere with the consistent rows and columns that sorting and filtering rely on. Unmerge the affected area and keep one value per cell where practical.
- The text looks cut off: A merge does not guarantee that all text will be visible. Adjust the column widths, row height, alignment, or wrapping as appropriate. A merged area can also behave differently from a single ordinary cell when its text wraps.
- A formula or reference is confusing: A merged area is not several independent cells after merging. Excel treats its value as belonging to the upper-left cell of the merged range, which can surprise formulas that expect values in the other positions.
If a workbook will be shared with others or used for calculations, test the layout with the intended sort, filter, and formulas before applying merges throughout the sheet.
Alternatives to merging for a cleaner layout
If the goal is simply to center a heading over several columns, Excel has a formatting alternative that leaves the cells separate: Center Across Selection. Select the cells, open the Format Cells dialog with Ctrl+1, choose the Alignment tab, and set the Horizontal option to Center Across Selection. This centers the entry across the selected columns without combining them into one cell. It is a cell-formatting option, not a merge command.
Other alternatives depend on the problem you are solving:
- Use a wider column or adjust column widths if a label needs more room.
- Use Wrap Text when the text should occupy multiple lines within its cell.
- Use indentation or alignment settings to make labels easier to scan.
- Use a formula to combine values while retaining the original data in separate cells.
These approaches often make a workbook easier to maintain. In particular, Center Across Selection can provide a merged-looking heading without introducing a merged cell that complicates later edits.
Using the merge command on Mac or Excel for the web
The Alt, H, M, C sequence described above is the Windows shortcut. On a Mac, the ribbon access-key sequence is different, so do not assume that the Windows keys will work. Select the cells, open the Home tab, and use the Merge & Center dropdown to choose the command. Keyboard behavior can depend on the Mac keyboard and Excel settings; the ribbon is the dependable route if you do not have a configured shortcut.
In Excel for the web, select the cells and use the Home tab’s Merge & Center control. Browser and web-app keyboard handling can differ from desktop Excel, so the Windows desktop sequence may not be available in the same way. The data-retention rule still matters: merging a selection with multiple populated cells can discard content other than the upper-left value.
Frequently Asked Questions
What is the shortcut for Merge & Center in Excel?
In Excel for Microsoft 365 on Windows, select the cells and press Alt, H, M, C in sequence. It merges the selection and centers the upper-left cell’s content.
Does merging cells combine the text in them?
No. Merging changes the worksheet layout; it does not join all selected values. Excel keeps the upper-left value and can discard other contents. Use a formula such as concatenation or TEXTJOIN when you need to combine text.
Can I merge cells without centering the text?
Yes. Open the Home > Merge & Center dropdown and choose Merge Cells. If you want the text centered across columns while keeping the cells separate, use Center Across Selection in Format Cells instead.
How do I undo a merge?
Select the merged cell and choose Home > Merge & Center dropdown > Unmerge Cells. This restores the separate cells but does not recover values that were removed during the merge. Use Ctrl+Z soon after merging if you need to reverse the action and the undo command is still available.
Why is Merge & Center greyed out?
Check whether the selected cells are inside an Excel table, where merging is not allowed, or whether the selection is otherwise unavailable for the command. Select a suitable range of adjacent worksheet cells, or convert the table to a normal range if merging is essential and you understand the impact on table features.
Related
- Excel Indian Number Format: Lakhs, Crores, and Commas
- Excel Indent Shortcut: Increase or Decrease Cell Indent
- Excel Number to Words: How to Spell Out Cell Values
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 Make a Monthly Budget Planner in Google SheetsTo make a monthly budget planner in Google Sheets, create one tab for your budget and another for…
- Excel Data Validation: Can a Dropdown Hold Multiple Values?Yes, but it depends on your Excel version: standard Data Validation dropdowns select one item per cell, while…
- Google Sheets Filter Shortcut: Keys and Quick TipsIn Google Sheets in a web browser, press Ctrl+Shift+L on Windows or ChromeOS, or ⌘+Shift+L on a Mac,…
- Google Translate for Google Sheets: Add-on or Formula?You usually do not need a Google Translate add-on for Google Sheets: the built-in GOOGLETRANSLATE function can translate…
- Cannot Remove a Section Break in Word? Try These FixesYes, you can remove a section break in Word: turn on formatting marks, locate the break, click immediately…
- Excel Ran Out of Resources: Causes and FixesWhen Excel says it ran out of resources, it could not get enough memory or another system resource…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.