Excel Merge Cells Command: Shortcuts, Options, and Limits

How-to basics · Updated November 18, 2026

In Excel for Microsoft 365 on Windows, select the cells you want to combine, then choose Home > Merge & Center. The keyboard sequence is Alt, H, M, C, pressed one key at a time; it merges the selection and centers its contents. If you want a different merge behavior, open the button’s dropdown and choose the appropriate option.

Where to find the merge command

The merge controls are on the Home tab, in the Alignment group. The main button is usually labeled Merge & Center. Its dropdown provides additional choices, including Merge Across, Merge Cells, and Unmerge Cells. The exact button layout can vary with the window size: if the ribbon is compressed, look for the Alignment group or expand its controls.

To use the command, first select a rectangular range of neighboring cells. For example, select A1:D1 to make one wider cell across the first row. You can also select a larger rectangle, but consider what is in every cell before merging. Excel treats the selected area as a single merged cell, not as several cells that happen to look joined.

What the merge options do

The dropdown choices have different effects on the selected cells. Choosing the right one matters, because some options merge across multiple rows while others create one merged area for the entire selection.

  • Merge & Center combines the selected cells into one and centers the remaining content horizontally.
  • Merge Across merges cells in each selected row separately. Selecting A1:D3, for example, creates three merged cells: A1:D1, A2:D2, and A3:D3.
  • Merge Cells combines the full selection into one merged cell without applying the center alignment command. Existing alignment settings may affect how its content appears.
  • Unmerge Cells removes the merged-cell arrangement and restores the individual cells in the selected area.

These commands do not combine text from every cell into a single result. They change the cell layout and keep the content from only one cell, as explained below.

What happens to data when cells are merged

This is the most important limitation: when you merge cells that contain more than one entry, Excel keeps the content from the upper-left cell and discards the contents of the other cells in the selection. For A1:C1, A1 is the upper-left cell. If A1 contains a heading and B1 or C1 contains data, the other entries will be lost when the merge is confirmed. Excel may display a warning before proceeding, but the warning does not preserve those values.

Formulas in the other cells are also at risk of being removed. Unmerging afterward does not bring discarded contents back; it only restores separate cells. If you accidentally merge and have not made other changes, Undo may reverse the operation. After continuing to edit, do not rely on Undo as a recovery plan. Save a copy or move the information elsewhere first.

If the goal is to put several text entries together, combine or copy them into one cell before merging. For instance, a heading in A1 and a date in B1 should be joined deliberately if both need to remain visible. You can use a formula or copy and paste the text into one cell, verify the result, and only then decide whether a merged layout is necessary. A merge itself is not a data-concatenation tool.

Steps to merge cells safely

  1. Check the selected range and identify the upper-left cell. Confirm that any other cell contents are expendable or have been preserved.
  2. Select the adjacent cells you want to merge. Use a single row for a typical heading, such as B2:E2.
  3. On the ribbon, choose Home > Merge & Center to merge and center, or open its dropdown and choose another merge option.
  4. If Excel warns that only the upper-left value will be retained, cancel if you need any of the other contents. Otherwise, confirm the merge.
  5. Check the displayed heading and alignment. Adjust the column widths, row height, wrapping, or alignment if the text does not fit as intended.

For a title spanning several columns, it is usually simplest to enter the title in the leftmost cell of the intended range and leave the other cells empty before merging. That makes the data-retention behavior predictable. If the sheet is likely to be sorted, filtered, or reused as a dataset, consider the non-merge alternative described below.

Keyboard shortcuts on Windows, Mac, and the web

On Excel for Microsoft 365 for Windows, press Alt, then H, then M, then C to activate Merge & Center. These are ribbon Key Tips: press and release each key in sequence rather than holding all four together. The dropdown choices also have Key Tip sequences, such as Alt, H, M, A for Merge Across, Alt, H, M, M for Merge Cells, and Alt, H, M, U for Unmerge Cells. Key Tips can vary if the ribbon or application language differs, so the letters shown onscreen are the reliable guide in that setup.

Excel for Mac does not use the same Windows Alt-based Key Tip sequence. Select the cells and use the merge control on the Home tab, opening its dropdown if needed. Excel for the web also provides the merge control on the Home tab; use the ribbon rather than assuming the Windows desktop shortcut will behave identically in a browser. If you cannot find the control, expand the ribbon or search the available commands in the app.

When to use Center Across Selection instead

A merged heading can look tidy, but merging changes the worksheet structure. A useful alternative for a heading across several columns is Center Across Selection. It centers the text across the selected cells visually without merging them, so each cell remains separate. This is often preferable in a sheet that will later be sorted, filtered, copied, or used for analysis.

To apply it in Windows desktop Excel, select the range, open the Format Cells dialog with Ctrl+1, choose the Alignment tab, and set the Horizontal option to Center Across Selection. The text should be in the leftmost cell of the selected range. On a Mac, open Format Cells from the formatting controls or use the available dialog shortcut for that installation; the alignment option is still the relevant setting. This approach changes presentation rather than combining the cells, so it avoids the data-loss behavior of merging.

Use a merge when a visual heading genuinely needs to occupy one combined cell and the range will not need to behave like ordinary tabular data. Prefer Center Across Selection when you want a similar centered appearance while keeping the underlying columns independent. For datasets, avoid both if a simple left-aligned label or a separate title row will work.

Common problems and practical fixes

If Merge & Center is unavailable or appears disabled, check that the selection is a suitable range and that the worksheet is not in a state that restricts editing. A common cause is selecting cells inside an Excel table: merged cells are not supported within a structured table. If the data should remain a table, do not convert or restructure it just to merge a heading. Put the heading outside the table instead.

Other problems are usually about layout or later worksheet operations:

  • The text seems missing: check the upper-left cell and the formula bar. The other selected cells may have been cleared by the merge. Undo immediately if appropriate, or recover from a saved copy.
  • The text is not centered: confirm that you chose Merge & Center rather than Merge Cells. You can also adjust the alignment after merging from the Home tab.
  • Sorting or filtering becomes awkward: merged regions can interfere with operations that expect a regular grid of separate cells. Unmerge the range or redesign the heading area before sorting or filtering.
  • The selection is not the size you expected: inspect the highlighted range before clicking. A merge applies to the current selection, which may include cells beyond the visible heading.

If sorting reports a problem or the worksheet behaves unexpectedly, inspect the affected rows for merged regions of different sizes. A uniform, unmerged data range is generally easier to sort and filter than one containing merged cells.

Using merged cells in worksheets and reports

Merging is most appropriate for presentation areas, such as a report title above a small, fixed summary. It is less suitable for the body of a dataset, where each row should represent a record and each column a field. Merging cells in that body can make it harder to select a consistent range, fill formulas down, paste data, or use features that expect one value per cell.

For example, a report title across A1:D1 may be reasonable if the rows below contain a stable, unmerged table. Merging A2:A5 to show a category beside four records is more likely to complicate sorting and filtering. Instead, repeat the category on each record row, or use formatting and borders to visually group the records without merging their cells.

Consider how the workbook will be used, not just how it looks at the moment. If other people will enter data, sort rows, or copy the range into another system, clear labels in separate cells are usually more robust. If the sheet is a static printable report, a small number of merges in its title area may be a reasonable design choice.

Frequently Asked Questions

What is the shortcut to merge cells in Excel?
On Windows desktop Excel, select the cells and press Alt, H, M, C in sequence to use Merge & Center. The ribbon Key Tips may differ in other languages or configurations; Excel for Mac does not use that same Windows sequence.

How do I merge cells without centering the text?
Open the dropdown beside Merge & Center on the Home tab and choose Merge Cells. If you want the text centered across cells but do not want to merge them, use Center Across Selection in Format Cells instead.

Does merging cells combine their text?
No. Excel retains the content in the upper-left cell and removes the contents of the other cells in the selected range. Combine or preserve the information separately before merging if you need all of it.

How do I unmerge cells in Excel?
Select the merged cell, then choose Home > Merge & Center > Unmerge Cells. The individual cells return, but unmerging does not restore contents discarded during the original merge.

Why can’t I merge cells in an Excel table?
Excel does not support merged cells inside a structured table. Keep the table unmerged and place any spanning title in a worksheet row outside the table, or use formatting such as Center Across Selection where appropriate.

Related

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.