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

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, find the Merge Cells button on the Home tab, in the Alignment group: select the cells, open the arrow beside Merge & Center, then choose Merge Cells or another merge option. The command combines selected cells into one larger cell, but keeps only the value in the upper-left cell, so check the selection before merging.

Where to find the Merge Cells button

On the standard Excel ribbon, select the Home tab and look in the Alignment group for Merge & Center. The main button applies Merge & Center, while its dropdown arrow opens the other merge commands. If the ribbon is narrow or the Excel window is small, the Alignment group may be compressed; widen the window or expand the group to see the control. You can also use the ribbon’s search box and search for Merge Cells if you cannot locate it.

On Excel for Mac, use the Home tab and the Merge & Center dropdown as well. Excel for the web also offers merge commands on the Home tab, although the ribbon layout can differ slightly from the desktop version. The Windows KeyTips sequence is Alt, H, M, followed by C for Merge & Center, M for Merge Cells, A for Merge Across, or U for Unmerge Cells. These are ribbon sequences, not a single simultaneous key combination. Mac users should use the ribbon command; the same Windows KeyTips sequence is not the Mac equivalent.

What the merge options do

The dropdown offers several choices, and they do not all behave the same way. Choosing the right one matters when a heading covers multiple columns or rows.

  • Merge & Center merges the selected cells and centers the surviving content in the merged area. It is commonly used for a report title above several columns.
  • Merge Cells combines the selection but does not apply the centering action. The text alignment otherwise follows the formatting of the cell that remains.
  • Merge Across merges cells across each row of the selected range separately. For a selection covering A1:C2, this creates one merged cell across A1:C1 and another across A2:C2, rather than one large rectangle.
  • Unmerge Cells separates a merged area back into individual cells. It does not restore values that were discarded when the cells were first merged.

Merge Across is useful for row-by-row labels, but it is easy to mistake it for a command that merges the entire selection. Check the resulting outline and cell layout before entering more data.

How to merge cells step by step

For a basic heading, select the rectangular range that should become one cell. For example, if a report title should span columns A through D in row 1, select A1:D1. Then go to Home > Merge & Center and choose the option you want. If you choose Merge & Center, Excel centers the remaining value across the merged area. If you want the value left-aligned or otherwise aligned, select Merge Cells instead and adjust alignment separately if needed.

  1. Select the cells to combine. Make sure the range includes the intended rows and columns, and that the upper-left cell contains the value you want to keep.
  2. Open the dropdown next to Merge & Center on the Home tab.
  3. Choose Merge & Center, Merge Cells, or Merge Across. If Excel warns that only the upper-left value will be kept, read the warning before confirming.
  4. Review the result. Check the displayed text, alignment, borders, and nearby rows or columns.

A merged area still has one underlying cell address: its upper-left cell. If A1:D1 is merged, Excel treats A1 as the cell for that merged area. This is relevant when selecting the cell in a formula, editing it, or referencing it from another worksheet. Avoid assuming that every former cell in the range remains an independently usable cell.

What happens to data and formatting

Merging is a layout operation, not a way to combine the contents of several cells. If A1 contains a title and B1 contains a date, selecting A1:B1 and merging will retain the value from A1; the value in B1 is removed. Excel displays a warning when a merge would discard other cell contents. If those values matter, cancel the merge and copy or move them somewhere safe first. Putting several pieces of information into one cell with a separator is a different task and does not require merging.

After a merge, the merged cell is identified by its upper-left address. Other addresses in the former range are no longer separate editable cells. Formatting and alignment can be adjusted after merging from the Home tab, including horizontal alignment, vertical alignment, wrapping, font, fill, and borders. For a long heading, Wrap Text may help, but merged cells can make row-height behavior less convenient than ordinary cells.

Merging does not create a new value that combines the cells, and it does not make data more structured. For instance, a merged heading across January, February, and March is still just one heading cell above the columns; it is not a replacement for storing each month’s data in its own column.

When merging makes sense

Merging is most appropriate for presentation areas that are not part of the working data grid. A title above a small printed report, a label over a decorative section, or a cover-sheet heading can benefit from a wider cell. In those cases, the merged area is primarily visual and is unlikely to be sorted, filtered, or used as a data field.

For a table that people will sort, filter, analyze, or extend, avoid merging cells within the data body. Each record should generally occupy one row, with one field per column and a value in each relevant cell. If cells are merged in the middle of a list, sorting may be blocked or produce confusing results, and filters and formulas become harder to manage. A header that spans categories can be visually appealing, but a conventional single-row header is usually easier for Excel tools and other spreadsheet software to interpret.

A practical test is to ask whether the selected cells represent one visual label or multiple pieces of data. If they are multiple data fields, do not merge them. If they are one label in a report heading, merging may be suitable.

Common problems and fixes

  • The button is unavailable. Check whether the selected cells are inside an Excel table. Excel does not allow merging cells within a formatted table. If the layout genuinely needs merged cells, you can convert the table to a range using Table Design > Convert to Range, then merge cells outside the table structure. Converting removes the table’s structured behavior, so retain the table when sorting and filtering are important.
  • Excel says it will keep only the upper-left value. That warning means at least one other selected cell contains data. Cancel, inspect the range, and move or combine needed content before trying again. Do not confirm just to make the warning disappear.
  • Sorting or filtering becomes difficult. Unmerge cells in the data area and put a value in each appropriate row or column. Keep merged cells for report titles or other areas outside the dataset.
  • The text seems cut off. The merged area may be too short or too narrow, or the row height may not fit the text. Widen the columns, increase the row height, use Wrap Text, or use a non-merged layout. Very long text in a merged cell can be awkward because automatic row sizing is less dependable for merged ranges.
  • Pasting produces an error or an unexpected layout. The copied range and destination may have incompatible merged-cell shapes. Try unmerging the destination first, or copy and paste into a range with the same merged layout. Before changing a large formatted sheet, save a copy so you can restore the original arrangement.

Alternatives to merging cells

If your only goal is to center a heading over several columns without combining cells, use Center Across Selection. Select the cells, open the Format Cells dialog, choose the Alignment tab, and set Horizontal to Center Across Selection. The cells remain separate, and only the leftmost cell needs to contain the text. This often works better than merging because the underlying grid stays intact, which can help with sorting, selecting, and editing. It is a desktop formatting option; it may not be available in the same way in Excel for the web.

Other options can be better depending on the purpose:

  • Place the heading in one cell and use alignment or column widths to make the sheet readable without merging.
  • Use a separate title row above the data, keeping the actual table headers unmerged.
  • Use cell borders, fill colors, and indentation to create visual grouping while preserving separate cells.
  • For a genuine category that applies to multiple records, repeat the category in each row or use a structured table rather than a merged label.

Center Across Selection is not a data-combining feature either; it changes how text appears across selected cells. Its advantage is that the cells remain individual cells.

How to unmerge cells safely

Select any part of a merged area, then choose Home > Merge & Center > Unmerge Cells. Excel restores the individual cell boundaries. The original content remains in the upper-left cell, while the other cells are blank; Excel cannot bring back values removed during the original merge. If you unmerge by mistake immediately after merging, Ctrl+Z on Windows may undo the merge and restore the prior state, provided you have not performed other actions that change the undo history. On Mac, use Command+Z. Saving a backup before broad layout changes is a safer approach for important workbooks.

Frequently Asked Questions

Where is Merge Cells in Excel?
On Windows, go to Home > Merge & Center and open the dropdown arrow. Choose Merge Cells for a merge without centering. The same command is on the Home tab in Excel for Mac and Excel for the web, though the ribbon arrangement can vary.

Does merging cells delete data?
It can. Excel keeps the content in the upper-left cell of the selected range and discards content from the other cells if you confirm the warning. Move or preserve any values you need before merging.

What is the difference between Merge Cells and Merge & Center?
Both combine the selected cells and keep only the upper-left cell’s value. Merge & Center also centers that value in the merged area; Merge Cells does not apply that centering step.

Why can’t I merge cells in an Excel table?
Excel does not support merged cells inside a formatted table. Keep the table unmerged for sorting and filtering, or convert it to a regular range if a merge is necessary for presentation.

How do I center text across columns without merging?
Select the cells, open Format Cells, choose Alignment, and set Horizontal to Center Across Selection. This centers the text visually while leaving the cells separate.

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.