Merge Cells in Excel: Steps, Options, and Tips

How-to basics · Updated November 18, 2026

To merge cells in Excel for Microsoft 365 on Windows, select the cells, then choose Home > Merge & Center. Use its drop-down to choose Merge & Center, Merge Across, or Merge Cells; Excel keeps only the content in the upper-left cell of the selected range.

What merging cells does

Merging combines two or more neighboring cells into one larger cell. For example, merging A1:D1 creates a single cell spanning four columns, which can work well for a title placed above a report. The merged cell is still identified by its upper-left address, A1 in this example. The other cells in the range no longer behave as independent cells until you unmerge them.

Merge is primarily a layout and presentation feature. It does not combine text or numbers from multiple cells, add values together, or create a new data field. If A1 contains North and B1 contains Region, merging A1:B1 does not produce North Region. Excel keeps North and discards the content from B1, after warning you that merging retains only the upper-left value.

That distinction matters because a worksheet can look tidy while becoming harder to sort, filter, copy, or use in formulas. For a report heading, merging may be appropriate. For a list of records that you expect to analyze, it is usually better to keep each value in its own cell.

How to merge cells step by step

First select a rectangular range of adjacent cells. You can drag across the cells or click the first one, hold Shift, and click the last one. Then open the Home tab and look in the Alignment group.

  1. Choose the drop-down arrow beside Merge & Center.
  2. Select the merge option that fits the layout. If you choose an option that keeps only one cell’s content, check the selection carefully before confirming Excel’s warning.
  3. Review the result. The merged range is treated as one cell, and the selected alignment option determines where its content appears.

Clicking the main Merge & Center button applies that command directly. If you want a different behavior, use the arrow rather than the main button. The button can also display the most recently used merge command, so its visible label may change after using the drop-down.

In an English-language Windows installation, ribbon KeyTips provide a keyboard route: press Alt, then H, M, and C to choose Merge & Center. These are sequential key presses, not a single chord. KeyTips can vary with the Office language and ribbon configuration, so the visible letters on your screen take priority.

Choosing the right merge option

The drop-down contains several commands because merging and alignment are not quite the same thing. Choose based on how much of the range should become a single cell and where the content should sit.

  • Merge & Center combines the selected cells into one and centers the remaining content. This is a common choice for a heading across several columns.
  • Merge Across merges cells horizontally in each row of the selection, rather than turning the entire selection into one cell. If you select A1:C2, it creates one merged cell across A1:C1 and another across A2:C2.
  • Merge Cells combines the full selection into one cell without applying horizontal centering as part of the command. Existing alignment settings can affect how its content is displayed.
  • Unmerge Cells reverses the merged layout and restores the individual cells. It does not restore content discarded when the cells were originally merged.

A useful example is a two-row report heading. If each row needs its own label stretching across columns A to C, select A1:C2 and use Merge Across. If the whole six-cell range should become one large title area, use Merge & Center or Merge Cells instead. In either case, ensure there is only one value you need to preserve in the selected range.

What happens to existing data and formatting

Before merging, Excel preserves the value in the upper-left cell of the selection and warns that other cell contents will be deleted. This applies to text, numbers, dates, and formulas. If a formula is in the upper-left cell, that formula remains; formulas in the other cells are removed. The warning is not a prompt to combine values, and clicking through it does not create a backup of the discarded entries.

For example, suppose A2 contains the word Product and B2 contains the word Code. Merging A2:B2 leaves Product as the cell content. Code is lost from the worksheet. If you need both words, combine or move them to one cell before merging, or leave the cells separate. For a clean report, you might instead put a heading in A1 and merge A1:D1 while keeping the actual column labels in row 2.

Formatting can also affect how the result looks. Excel may carry formatting from the upper-left cell across the merged area, while borders, fills, and alignment can make the larger cell appear different from the original selection. If the result looks inconsistent, use the standard formatting controls on the Home tab after merging. Consider saving a copy first if the selected cells contain important entries or a complicated layout.

How to unmerge cells and recover content

To separate a merged cell, select it and choose Home > Merge & Center > Unmerge Cells. Excel restores the underlying cell grid. The value that survived the merge remains in the upper-left cell; the other cells are blank unless you enter or restore their contents separately. Unmerging is therefore not the same as undoing the original data loss.

If you have just merged the cells and have not made other changes, use Ctrl+Z on Windows to undo the action. On Mac, the usual undo shortcut is Command+Z. Undo can restore the previous state while the action remains in the undo history. If you have since closed the workbook, cleared the undo history, or made changes that you need to keep, recovery may not be possible from the merged range alone. Check a saved copy, version history, or the original data source if available.

A safe habit is to inspect the selected range before merging and copy any content you need to another location. This is especially important when the range was selected quickly or includes hidden rows or columns. The upper-left cell rule still applies to the selected range, not merely to the cells that are currently easy to see.

Common problems with merged cells

Merged cells can complicate worksheet operations because a rectangular block that normally contains separate cells now contains a single cell spanning several positions. The issue is most noticeable in data tables, where each row should have a consistent structure.

  • Sorting: Excel may refuse to sort a range when merged cells do not have the same dimensions throughout the sort area. Even when a sort is possible, merged layouts can make it difficult to keep labels aligned with the correct records.
  • Filtering: A merged heading can be useful above a data table, but merged cells within the records make the table less consistent and can make filtered results harder to interpret. Keep field names and record values in separate, ordinary cells.
  • Excel tables: Cells inside an Excel table cannot be merged. If the Merge command is unavailable or does not work as expected, check whether the selection is within a table. A heading can sit in a normal worksheet row above the table instead.
  • Copying and pasting: Copying a merged range into a differently sized or differently structured area can produce a size mismatch or an unexpected layout. The destination’s merged-cell structure matters too.
  • Formulas and references: A merged range has one usable cell value, associated with its upper-left cell. A formula that refers to another position in the former range may find that cell blank, so references should be checked after changing a layout.

For an analysis sheet, a reliable rule is to avoid merging inside the body of a data set. Keep one heading per column and one record per row. You can still use font size, fill color, borders, and alignment to distinguish sections without changing the shape of the data.

Alternatives when you only want centered text

If the goal is to center a heading across several columns without actually combining cells, use Center Across Selection. Select the cells, open the Format Cells dialog, go to the Alignment tab, and choose Center Across Selection from the Horizontal alignment list. The cells remain separate, so this can avoid some problems associated with merged ranges.

Another option is to place the heading in the leftmost cell and use ordinary alignment, indentation, or formatting to make it visually clear. For print-focused sheets, adjusting column widths, row heights, and page layout may achieve the intended look without merging. For a title that should span a group of columns, Center Across Selection is often a better choice when the worksheet will later be sorted or reused as data.

These alternatives do not combine values either. If the real goal is to bring text from multiple cells into one, use a formula or edit the content in a single cell rather than relying on Merge. Keeping the original entries in separate cells can also make later calculations and filtering much easier.

Excel for Mac and Excel for the web

In Excel for Mac, select the range and use the Home tab’s Merge & Center control or its drop-down. The command names and general behavior are similar to Excel for Windows, including the rule that only the upper-left cell’s content is retained. Mac keyboard shortcuts differ from Windows KeyTips; use the ribbon if you do not have a shortcut configured for your installation.

In Excel for the web, select the cells and look for Merge & Center on the Home tab. The available commands can depend on the current ribbon layout and browser window width, so the control may be grouped or shown through a menu. If you cannot find it, expand the ribbon or use the Home tab’s command search if available in your interface. The data-retention caution applies in the web version as well: merging is not a way to join the contents of several cells.

Frequently Asked Questions

How do I merge cells in Excel without losing data?
Excel’s merge command keeps only the upper-left cell’s content. Move or combine the other values before merging, or choose an alternative such as Center Across Selection if you only need a centered heading.

Can I merge cells in an Excel table?
No. Excel does not allow cells inside a formatted Excel table to be merged. Put a title in a regular worksheet row above the table, or change the layout so the table’s data cells remain separate.

What is the difference between Merge Cells and Merge & Center?
Both combine the selected range into one cell and retain the upper-left content. Merge & Center also centers that content horizontally; Merge Cells does not apply that centering as part of the command.

How do I merge cells across each row?
Select the range and choose Home > Merge & Center > Merge Across. Excel makes a separate merged cell for each row of the selection, rather than one merged cell for the entire block.

Can I undo a merge after saving and closing the file?
You can unmerge the cells, but that does not restore values discarded during the merge. Look for a workbook version, backup, or original source data if those values are needed.

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.