Can You Merge Cells in Excel? Options and Limits

How-to basics · Updated November 18, 2026

Yes, you can merge cells in Excel for Microsoft 365 on Windows: select the cells, then choose Home > Merge & Center. Excel combines the selected cells into one larger cell, but keeps only the content in the upper-left cell, so check the selection before merging.

What merging cells does

When you merge a range, Excel treats that range as one cell for many purposes. The merged area takes up the same rows and columns as the original cells, but only the upper-left cell remains the cell that holds the value or formula. For example, merging A1:C1 creates a single cell visually spanning three columns. It does not combine three separate values into one string.

Merging is mainly a layout and presentation feature. It can make a heading appear centered over several columns or create a larger label area in a report. It does not join data the way a text-concatenation formula would, and it does not make the selected cells into a new kind of data field. The distinction matters if you later sort, filter, copy, or calculate using the worksheet.

How to merge cells in Excel for Windows

In Excel for Microsoft 365 on Windows, use the ribbon to merge a range:

  1. Select the adjacent cells you want to combine. The selection can cover multiple columns, rows, or both.
  2. Open the Home tab and look in the Alignment group.
  3. Select Merge & Center to merge the selection and center its remaining content.

If the button shows a different merge option, select its drop-down arrow to see the available commands. Excel may display a warning if more than one selected cell contains content. Read it before proceeding: accepting the merge discards the contents of cells other than the upper-left one.

There is also a keyboard route on Windows: press Alt, then H, then M, then C to invoke the ribbon command for Merge & Center. These are sequential KeyTips, not keys to hold down together. KeyTips can vary if the ribbon or Excel version differs, so the on-screen ribbon labels are the reliable reference.

What the merge options mean

The drop-down beside Home > Merge & Center offers related commands. They do not all arrange the selection in the same way:

  • Merge & Center combines the selected cells into one and centers the remaining content horizontally.
  • Merge Across merges cells across each row of the selected range separately. Selecting A1:C3 creates three merged cells, one for each row, rather than one large A1:C3 cell.
  • Merge Cells combines the selection into one cell without applying the centering behavior of Merge & Center.
  • Unmerge Cells removes the merged layout and restores the individual cells in the range.

These differences are useful when formatting a report. For instance, Merge Across can create a row-wide label for each section of a multi-row layout. By contrast, if you select A1:C3 and choose Merge & Center, Excel creates one merged area spanning all three rows and columns. Consider the shape you need before choosing the command.

What happens to existing data

Excel does not preserve every value inside a merged range. It keeps the value or formula from the upper-left cell and removes content from the other cells in the selection. If A1 contains “Quarterly Sales,” B1 contains a date, and you merge A1:B1, only the content from A1 remains. The date is discarded from the worksheet range when the merge is accepted.

This is not the same as combining text. If you need to preserve information from multiple cells, first put the desired combined result in a separate cell or use a suitable formula, then decide how to format the result. Merging should not be used as a way to join records, labels, or numbers. It can also make it harder to select and reference individual cells later.

If the warning appears unexpectedly, choose Cancel and inspect the selected cells. Check for values, formulas, or data that may not be obvious because of column width, number formatting, or hidden rows. A blank-looking cell can still contain a formula or a value; the formula bar can help you verify the active cell’s contents.

When merging is useful—and when it is not

A merge can be reasonable for a presentation-focused worksheet where the merged range is a heading or label and the cells beneath it are not intended to be independently sorted or analyzed. For example, a title such as “Regional Revenue” might span the columns for several months in a print-ready summary. A short label spanning a designed form area is another possible use.

It is usually a poor choice for the main body of a data table. Excel’s sorting and filtering work best when each row is a consistent record and each column has its own header. A merged heading inside the data region can interrupt that structure. Merged cells are also not allowed inside an Excel table: if you convert a range to a table, you may need to unmerge cells first.

Before merging, ask what the worksheet is for. If it is primarily a report for people to read, a merge may be an acceptable visual choice. If it is a list that people will sort, filter, extend, import, or analyze, keep the cells separate and use formatting that does not change the grid structure.

Common problems with merged cells

Several everyday Excel operations become less predictable when a worksheet contains merged ranges. Sorting a range that includes merged cells can produce an error or require you to change the selection. Filtering and structured table layouts also rely on consistent rows and columns, which merged cells can disrupt. A merged cell may cover several columns, yet it still has only one underlying value in its upper-left position.

Copying and pasting can be troublesome when the source and destination ranges have different merged-cell shapes. Excel may reject the paste or apply formatting in a way that is not what you intended. Selecting a single column or row through a merged area can also feel awkward because the merged range crosses the boundaries of individual cells.

These issues are not proof that merging is broken; they follow from the fact that the worksheet grid is no longer a simple one-cell-per-position layout in that area. If a workbook is shared with colleagues, used as a data source, or fed into another process, avoiding merges in the working data can prevent later cleanup.

Alternatives that keep cells separate

If your goal is visual alignment rather than creating a single cell, try Center Across Selection. Select the cells, open the Home tab, and use the dialog launcher in the Alignment group to open Format Cells. On the Alignment tab, choose Center Across Selection in the Horizontal list. The cells remain separate, so this can be friendlier to sorting and data handling than merging. It is most useful for a heading centered across a range; check the result in the worksheet because the displayed text depends on the neighboring cells and their contents.

Other options may fit better depending on the layout:

  • Use Center alignment on a single cell if the label does not need to span several columns.
  • Use Wrap Text to display a longer heading on multiple lines within one column, adjusting the row height if needed.
  • Widen a column or adjust row height when the issue is simply that a label does not fit.
  • Keep a heading in one cell and apply borders, fill color, or font formatting across nearby cells to create a visual section without merging them.

These alternatives preserve the normal cell grid, but they do not all produce exactly the same appearance as a merge. Choose based on whether the priority is appearance, editing convenience, or reliable data operations.

How to unmerge cells

To undo a merge, select the merged cell or range and choose Home > Merge & Center > Unmerge Cells. Excel restores the original cell boundaries. However, it does not bring back content that was removed from the non-upper-left cells when the merge was first made. Unmerging changes the layout; it is not a recovery tool for discarded values.

If you just merged the cells and have not made other changes, Ctrl+Z on Windows can undo the action and restore the prior state. On a Mac, the usual undo shortcut is Command+Z. If you have already continued editing or saved and closed the workbook, undo may no longer be available. For important data, make a copy or confirm the cell contents before merging.

Excel on Mac and Excel for the web

In Excel for Microsoft 365 on Mac, the merge commands are also available from the Home tab, in the alignment controls. The exact ribbon arrangement can differ from Windows, so look for the Merge & Center button and its menu. The Windows Alt-based KeyTips described above do not apply as a Mac shortcut; use the ribbon command or the shortcut guidance shown by your Mac version.

Excel for the web also provides cell-merging controls on the Home tab, although the interface and available options can change as Microsoft updates the web app. The same practical caution applies: merging is a layout operation, and you should verify which content will remain before accepting it. If a command is missing or behaves differently in a particular workbook, check whether the sheet is protected or whether the selected range is part of a table.

Frequently Asked Questions

Can I merge cells without losing data?
Not if multiple selected cells contain content and you accept the merge: Excel keeps only the upper-left cell’s content. Move or combine information elsewhere first if you need to retain it.

Can I merge cells in an Excel table?
No. Excel tables do not support merged cells within the table range. Unmerge the cells or redesign the layout outside the table before converting the range to a table.

What is the difference between Merge Cells and Merge & Center?
Both combine the selected cells and retain only the upper-left content. Merge & Center also centers that content horizontally; Merge Cells does not apply that centering action.

Can I sort data that contains merged cells?
Sorting may be blocked or behave inconveniently when the selected range includes merged cells. For sortable data, keep the records in an unmerged, consistent grid and use formatting for headings separately.

Does unmerging restore the deleted values?
No. Unmerge Cells restores the individual cell boundaries, but values removed from the other cells are not recovered. Undo immediately after merging, if available, or restore the information from a saved copy.

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.