Excel Merge Cells Button: Where It Is and How to Use It

In Excel for Microsoft 365 on Windows, select the cells you want to combine, then choose Home > Merge & Center in the Alignment group. Open the button’s dropdown for other merge options; note that Excel keeps only the value in the upper-left cell when it merges a selection.

Where to Find the Merge Cells Button

The merge control is on the Home tab of the Excel ribbon. Look in the Alignment group, alongside controls for horizontal and vertical alignment, text orientation, wrapping, and indentation. The main button is usually labeled Merge & Center. Depending on the ribbon width and window size, it may appear as a larger button or a compact icon with a dropdown arrow.

Clicking the main part of the button applies Merge & Center to the selected range. Clicking its dropdown arrow opens a menu with choices such as Merge & Center, Merge Across, Merge Cells, and Unmerge Cells. If the ribbon is simplified or the Excel window is narrow, expand the relevant ribbon group or widen the window to make the controls easier to see.

The button works on a selection of adjacent cells, not on cells scattered in different parts of a worksheet. For example, selecting A1:D1 and choosing Merge & Center makes those four cells one wider cell, with the content centered across it. You can select cells with the mouse or use the keyboard to move to a starting cell and extend the selection.

What the Merge Options Do

The dropdown offers different ways to combine cells and position the content. Choosing the right option matters because the results are not identical:

Merge & Center combines the selected cells into one cell and centers the retained content horizontally.
Merge Across merges cells across each row of the selected range separately. Selecting A1:C3 creates three merged cells: A1:C1, A2:C2, and A3:C3.
Merge Cells combines the selection without applying the centering change that comes with Merge & Center. The content’s alignment follows the applicable cell formatting.
Unmerge Cells separates a previously merged cell back into its original grid of cells.

These options do not combine the contents of every selected cell into a single text string. Merging changes the worksheet’s cell layout; it is not the same as joining names, labels, or numbers. If the goal is to put several values together, use a formula or another data-combination method instead of merging.

How to Merge Cells Step by Step

For a typical heading above a group of columns, use the following sequence:

Select a rectangular range of adjacent cells, such as B2:E2.
Open the Home tab and find the Alignment group.
Click the arrow beside Merge & Center.
Choose Merge & Center, Merge Across, or Merge Cells, depending on the result you need.
If Excel warns that merging keeps only the upper-left value, check the selection before confirming.

For a title above columns B through E, B2:E2 is a common choice. Type the title into B2 before merging, or enter it in the upper-left cell after merging. If you need the title centered, use Merge & Center. For a heading that should remain left-aligned, select Merge Cells and check the alignment afterward.

Before applying the command, verify the highlighted range in the worksheet and the Name Box to the left of the formula bar. A selection that accidentally includes an extra row or column can merge more of the sheet than intended. If the selected cells contain more than one entry, read Excel’s warning rather than dismissing it automatically.

What Happens to Existing Cell Contents

When a range contains data in more than one cell, Excel displays a warning that merging keeps only the upper-left value and discards the other contents. If A1 contains Region and B1 contains West, merging A1:B1 leaves Region in the merged cell; West is not appended to it. The same basic rule applies if the cells contain formulas: the upper-left cell’s content is retained, and content in the other cells is removed.

This can be surprising because the merged area visually covers all the selected cells. The cells beneath the merged area still correspond to the worksheet grid, but the merged range behaves as one cell for many editing tasks. Unmerging later restores the cell boundaries; it does not bring back values that were discarded during the merge.

If every value matters, cancel the merge and combine the data first. For example, you could place a suitable text-joining formula in a separate cell, review the result, and then decide whether a merged presentation cell is necessary. Keep an untouched copy of the original data if it may be needed for later sorting, analysis, or reporting.

Common Problems and Limitations

A frequent issue is that the Merge & Center button is unavailable or Excel refuses to merge the selection. Check these common causes:

The selection is not a suitable range. Select one contiguous rectangular block of adjacent cells rather than separate, nonadjacent cells.
The worksheet is an Excel table. Merging cells is not supported within a formatted table. If the layout truly requires a merge, convert the table to a normal range using the Table Design tab’s Convert to Range command, while considering that this removes table behavior such as structured references and automatic expansion.
The sheet is protected. Protection can prevent formatting changes. If you have permission, review the protection settings or ask the workbook owner to change them.
The merge would discard data. The warning is a safeguard. Cancel and check each cell if you are not certain the upper-left value is the one to keep.

Merged cells can also complicate sorting, filtering, copying, and selecting ranges. A sort may fail or produce an error when the range includes merged cells of inconsistent sizes. A filter is easier to manage when each record has its own value in a normal cell. Merged cells can make it less obvious which row or column a value belongs to, especially in a worksheet used by several people.

When to Use a Merge and When to Avoid It

Merging is most appropriate for presentation, such as a title spanning a small group of columns above a report. It is less suitable for the body of a data table. In a table of orders, for instance, each order should have its own values in ordinary cells; merging a customer name across several order rows can interfere with filtering, sorting, and later analysis.

Consider whether the visual effect can be achieved without changing the worksheet structure. Excel’s Center Across Selection option centers a value across a selected range without actually merging its cells. To find it, select the cells, open Format Cells from the Home tab’s Alignment group dialog launcher, choose the Alignment tab, and select Center Across Selection from the Horizontal list. This can preserve separate cells for sorting and editing, although the text must be in the leftmost cell of the selected range.

Another alternative is to apply borders, fill color, or alignment to give a heading a unified appearance while leaving the underlying cells separate. For data that needs to be joined rather than merely displayed across a wider area, use a formula or store the information in separate fields as appropriate. The best choice depends on whether the worksheet is a presentation, a working data table, or both.

Keyboard, Mac, and Excel for the Web

On Windows, Excel’s ribbon KeyTips provide a keyboard route to the command. Press Alt, then H to open the Home tab’s KeyTips, then M for the merge menu, and then C for Merge & Center. This is a sequence of ribbon keys rather than a single simultaneous shortcut. KeyTips can vary with ribbon layout or localization, so follow the letters displayed on screen if the sequence differs.

On Excel for Mac, use the Home tab and the Merge & Center dropdown; the Windows Alt-key sequence is not the Mac equivalent. Keyboard access to ribbon commands can depend on macOS and Excel settings, so the visible menu is the dependable route when a shortcut is not available. Excel for the web also has a Home tab merge control, though the ribbon’s exact appearance can vary with the browser window and interface updates. In all versions, verify which cells are selected before choosing a merge command.

Unmerging Cells and Avoiding Data Loss

To reverse the layout change, select the merged cell and choose Home > Merge & Center > Unmerge Cells. The original grid boundaries return, and the retained value remains in the upper-left cell of the former merged range. The other cells are blank unless they already contain data from a later edit; unmerging does not reconstruct content that was discarded when the cells were first merged.

If you have just merged cells and realize the selection was wrong, use Undo immediately with Ctrl+Z on Windows or Command+Z on Mac. Undo can reverse the recent merge operation, but it is not a substitute for retaining a source copy when the workbook has important data or a long edit history. Before merging a large or unfamiliar range, save the workbook or make a copy, especially if other people rely on its data structure.

Frequently Asked Questions

What is the keyboard shortcut to merge cells in Excel?
On Windows, press Alt, H, M, C in sequence to choose Merge & Center through the ribbon. Use the KeyTips shown in your Excel window if the letters differ. Mac users can select the command from the Home tab because the Windows sequence does not apply.

Does merging cells combine all their text?
No. Excel retains the content of the upper-left cell and warns that content in other selected cells will be discarded. If you need the values joined, combine them separately before changing the layout.

How do I merge cells without centering the text?
Open the Merge & Center dropdown on the Home tab and choose Merge Cells. You can then set the alignment you want. Center Across Selection is another option when you want centered presentation without actually merging cells.

Can I merge cells in an Excel table?
No, Excel does not allow merged cells inside a formatted table. You can keep the table unmerged, or convert it to a range if appropriate and then merge cells outside the table structure.

Can I get data back after unmerging cells?
Unmerging restores the cell boundaries but does not restore values discarded during the merge. If you have not made other changes, Undo may reverse the merge; otherwise, recover the missing data from a saved copy or another source.

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.