In Excel for Microsoft 365 on Windows, select the cells you want to combine, then press Alt, H, M, and C one key at a time to use Merge & Center. Excel keeps the contents of the upper-left cell and discards other cell contents, so check the selection before merging. These steps cover the keyboard shortcuts, the other merge choices, and what to do if the result is not what you expected.
What You’ll Need
- A workbook open in the desktop version of Excel for Microsoft 365 on Windows. The ribbon shortcut sequence below is for Windows; Excel for Mac and Excel for the web may use different keyboard navigation.
- A clear idea of which cells should become one merged area. Merged cells are best suited to headings or labels, rather than the main body of a sortable or filterable data table.
- If more than one selected cell contains text or a value, decide which content to keep before you merge. Excel retains only the value in the upper-left cell of the selection.
Step-by-Step
- Save or review the data first. Look across the cells you plan to merge and note any content outside the upper-left cell. Merging does not join text together. For example, if A1 contains North and B1 contains Region, merging A1:B1 leaves North in the merged cell; Region is removed. Copy or move any important content elsewhere before continuing.
- Select the range using the keyboard. Click the first cell with the mouse if needed, then hold
Shiftand use the arrow keys to extend the selection. For instance, from A1 pressShift+Right Arrowthree times to select A1:D1. You can also pressCtrl+G, type a range such asA1:D1in the Go To box, and pressEnter. Check the highlighted outline before applying a merge; a selection that is one row too tall or wide can alter the layout. - Open the Home ribbon shortcut sequence. Press and release
Alt, then press and releaseHto activate the Home tab key tips. PressMto open the Merge & Center menu. These are sequential key presses, not a combination you hold down together. If Excel displays different key-tip letters on your screen, follow the letters shown there, as key tips can vary with the interface or version. - Choose Merge & Center when the heading should be centered. With the merge menu open, press
C. Excel merges the selected cells into one area and centers the surviving upper-left value. Use this for a title spanning several columns, such as a report heading above a table. This command changes both the cell structure and the horizontal alignment. - Choose a different merge command when appropriate. From the same menu, press
Mfor Merge Cells if you want one merged area without the command specifically centering the text. PressAfor Merge Across to merge selected cells row by row, rather than combining every selected row into one large cell. PressUto unmerge a selected merged area. Read the menu labels if you are unsure which key tip is active before pressing it. - Check the result and alignment. Confirm that the merged area covers the intended cells and that the remaining content is correct. If you used Merge & Center, the value should appear centered across the merged area. If the text is not positioned as you want, use the alignment controls on the Home tab after merging, or choose a different merge command if you have not yet merged.
- Undo immediately if the wrong cells were merged. Press
Ctrl+Zon Windows to reverse the merge and restore the prior cell layout and contents when Excel still has the action in its undo history. Then select the correct range and repeat the steps. Undo is the safest fix for a just-completed mistake; do not assume unmerging later will bring back content discarded during the merge.
Shortcut recap for Windows: Alt, H, M, C means Merge & Center; Alt, H, M, M means Merge Cells; Alt, H, M, A means Merge Across; and Alt, H, M, U means Unmerge Cells. Press each key in sequence. If a shortcut does not match the displayed key tips, use the on-screen key-tip letters rather than repeatedly guessing.
Common Mistakes
Assuming Excel combines all the text. Merge commands do not concatenate values from multiple cells. Only the upper-left cell’s content remains in the merged cell; the other selected contents are removed. If you need to preserve several entries as one label, combine them in a separate cell first, or copy them somewhere safe before merging.
Selecting too large a range. A range that includes two rows when you meant to select one can create a large merged block and make the worksheet difficult to navigate. Use the Name Box or Go To to select an exact address, then verify the highlighted cells before pressing the merge shortcut.
Choosing Merge Across by accident. Merge Across processes each row separately. Selecting A1:D3 and choosing this option creates three merged cells, one per row, rather than one merged cell spanning all twelve cells. That can be useful for repeated row headings, but it is not the same as merging the full selection at once.
Merging cells in a data list. Merged cells can interfere with sorting, filtering, filling, and selecting a consistent rectangular range. Keep the raw data in regular, unmerged cells where possible. For a heading above a table, merge only the heading row, not the records below it.
Expecting unmerge to restore discarded values. Unmerge Cells separates the area into individual cells, but it does not reconstruct the values that were removed when the cells were first merged. Use Undo soon after a merge if you need to restore the original contents.
Tips
Use Merge & Center only when centering is wanted. It is a fast keyboard option for a heading, but the centering is part of the command. If you want a merged cell with a different alignment, choose Merge Cells and set alignment separately from the Home tab.
Use Merge Across for repeated row labels. If each row needs its own combined heading area, select the matching cells across those rows and choose Merge Across. Check that every row has the intended leftmost value, because Excel retains the first cell’s content in each row and removes other contents in that row.
Consider Center Across Selection for a title over columns. If your goal is only to make a heading look centered across several columns, you may be able to avoid merging. Select the cells, open Format Cells with Ctrl+1, go to the Alignment tab, and set Horizontal to Center Across Selection. This keeps the cells separate, which is often more convenient for sorting and editing. The setting is an alignment option, not a merge command.
Check workbook structure before making a group of merges. Merges can affect how nearby cells are selected and how the sheet behaves. Try the format on one heading first, then repeat it only where the layout needs it. If the workbook is shared or used as a data source, check with the people or process that rely on its table structure before merging cells in that area.
On a Mac, use the ribbon rather than Windows key tips. The Windows sequence Alt, H, M, followed by a choice is not the Mac equivalent. In Excel for Mac, go to Home and use the Merge & Center dropdown. Keyboard navigation through ribbon controls depends on macOS and Excel settings; enable keyboard navigation in macOS if you need to move between controls without a mouse, then use the visible control labels and arrow or Return keys. Excel for the web also has a different shortcut environment, so use its Home ribbon merge menu if the Windows sequence is intercepted by the browser.
Troubleshooting
The shortcut types letters into a cell instead of opening the ribbon. Make sure you are not editing the cell. Press Esc or Enter to leave edit mode, then press and release Alt and watch for key tips. Continue with the letters Excel displays. If the workbook is open in a browser, the browser may intercept some keyboard actions; use the Excel web ribbon or open the workbook in desktop Excel.
The menu opens, but the command does not run. The merge menu may be showing key-tip letters that differ from the expected sequence. Read the on-screen letters next to the commands and press the one displayed for the option you want. You can also navigate the Home ribbon with the keyboard and activate the Merge & Center dropdown, then choose the item by its label.
Excel warns that merging keeps only the upper-left value. Stop and review the selection. If you need every value, cancel the merge and preserve or combine the contents before trying again. If you accept the warning, Excel will remove the other selected values; those values may not be recoverable by unmerging.
You cannot merge the selected cells. Check whether the worksheet is protected, whether the cells are part of an Excel table, or whether the selected range includes an existing merged area. A protected sheet may prevent formatting changes; an Excel table generally does not support merged cells within its table structure. Remove protection only if you have permission, and convert or redesign a table only if that suits the workbook’s purpose. If a selection contains an existing merge, unmerge or adjust it before trying a new selection.
Sorting or filtering stops behaving as expected afterward. Unmerge the affected area with the Unmerge Cells command, then keep the data region in a regular grid with one value per cell. Use a separate title row or Center Across Selection for presentation headings. If a merge was just made, Ctrl+Z can reverse it; otherwise, unmerging may require you to repair the layout manually.
Frequently Asked Questions
What is the keyboard shortcut to merge cells in Excel?
On Windows desktop Excel, press and release Alt, H, M, then M for Merge Cells. Use C as the final key for Merge & Center. Key tips are sequential.
Does merging cells combine their contents?
No. Excel keeps the upper-left cell’s content and removes content in the other cells in the selection. Copy or combine anything you need to keep before merging.
What is the difference between Merge Cells and Merge Across?
Merge Cells makes the entire selection one merged area. Merge Across makes a separate merged area for each row in a multirow selection. Both retain the leftmost cell’s content for the relevant area.
How do I unmerge cells with the keyboard?
Select the merged area and press Alt, H, M, U in sequence on Windows. Unmerging restores separate cells, but it does not restore values discarded during the original merge.
Can I merge cells in Excel for Mac with the same shortcut?
The Windows Alt key-tip sequence is not the Mac equivalent. Use Home > Merge & Center and select the required option. Keyboard access to ribbon controls depends on your macOS and Excel settings.
Can I merge cells in an Excel table?
Excel tables are designed as consistent grids and do not support merged cells within the table. Keep table data unmerged; place a merged heading above the table or use Center Across Selection for a visual heading.
Related
- Google Sheets: Highlight Duplicate Values with Color
- Hide in Excel: Keyboard Shortcuts for Rows, Columns & Sheets
- How to Hide Long Text in Excel Cells Without Deleting It
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 Join Two Columns in Google Sheets With a FormulaTo join two columns in Google Sheets, enter a formula such as =A2&" "&B2 in an empty column,…
- Google Sheets Expense Tracker: Setup and FormulasCreate an expense tracker in Google Sheets by entering each purchase on its own row, adding consistent columns…
- Google Sheets Checkbox in a Cell: How to Add and UseTo put a checkbox in a Google Sheets cell, select the cell or range, then choose Insert >…
- How to Create a Rule Template in OutlookIn classic Outlook for Microsoft 365 on Windows, create a rule from a built-in template or from scratch,…
- Print an Excel Column on Every Page: Step-by-StepTo print the same Excel column on every printed page, open the worksheet and choose Page Layout >…
- Share a Google Calendar in Outlook: Step-by-StepTo see a Google Calendar in Outlook, copy its iCal address from Google Calendar and add it to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.