Merge and Center combines two or more cells into one and aligns the content in the middle

The Merge and Center feature in Excel takes multiple cells and combines them into a single cell, then centers the text horizontally and vertically within that merged space. This is useful for creating titles that span across columns, formatting headers, or organizing data visually. Excel offers several ways to merge cells, and you can also unmerge them if you change your mind.

The simplest route is the one-click Merge and Center button on the Home tab. If you need more control — like merging without centering, or keeping data from cells you're combining — you'll use the full Merge Cells dialog instead.

Key Takeaways

  • Select the cells you want to merge first, then click Merge and Center on the Home tab to combine them and center the text in one step.
  • Excel keeps only the content from the top-left cell when you merge; data in other selected cells is deleted unless you copy it first.
  • The Merge Cells dialog (accessed through Format menu) gives you options to merge without centering or to merge cells across rows.
  • You can unmerge cells at any time by selecting the merged cell and clicking Unmerge Cells in the Format menu.

Using the Merge and Center button on the Home tab

Select the cells you want to combine by clicking the first cell and dragging to the last one. If the cells are not next to each other, hold Ctrl and click each cell individually. Then look at the Home tab in the ribbon at the top of the screen.

In the Alignment group (toward the right side of the Home tab), you'll see a button with overlapping rectangles and the words "Merge and Center" below it. Click that button. Excel combines the selected cells into one and centers the text both horizontally and vertically. The merged cell takes the address of the top-left cell in your selection.

What happens to data in the cells you're merging

When you merge cells, Excel keeps only the content from the top-left cell and deletes everything in the other cells. If you have data in multiple cells that you want to keep, copy it to a safe location first — like a blank column — or type it into the merged cell after merging is complete.

If you accidentally merge cells and lose data, press Ctrl+Z immediately to undo the merge. The data will return. If you've already done other work since the merge, undo will reverse those steps too, so save your file first if you want to keep recent changes.

Merging cells without centering the text

If you want to merge cells but keep the text left-aligned (or in any other alignment), use the Merge Cells dialog instead of the Merge and Center button. Select your cells, then go to the Home tab and click the small arrow next to Merge and Center. A dropdown menu appears with options including "Merge Cells" (without centering) and "Merge and Center".

Click "Merge Cells" to combine them without changing the text alignment. The text will stay left-aligned by default. You can then change the alignment separately using the alignment buttons on the Home tab if you want.

Merging cells across multiple rows

The standard Merge and Center button works for cells in a single row or a rectangular block. If you need to merge cells in a way that spans both rows and columns — for example, merging a 3-by-2 block of cells — select all the cells you want to combine and click Merge and Center. Excel will merge them into one large cell.

If you're merging cells across rows and want to keep text at the top instead of centered, select the cells, use the dropdown next to Merge and Center, and choose "Merge Cells". Then use the alignment buttons to position the text where you want it.

Unmerging cells you've already combined

Click on the merged cell to select it. Go to the Home tab, click the dropdown arrow next to Merge and Center, and select "Unmerge Cells". Excel splits the merged cell back into its original separate cells. Any text that was in the merged cell stays in the top-left cell; the other cells become empty.

You can unmerge cells at any point, even if you merged them weeks ago. There's no limit to how many times you can merge and unmerge the same cells.

Common problems and how to fix them

If the Merge and Center button appears grayed out (disabled), you may have cells from different worksheets selected, or you may be in a protected sheet that doesn't allow merging. Check that all your selected cells are on the same sheet and that the sheet isn't locked.

If merged cells are causing problems with sorting or filtering, unmerge them first. Excel's sort and filter features don't work reliably on merged cells because they expect each column to have a separate header. After sorting or filtering, you can merge cells again if you want.

Frequently Asked Questions

Can I merge cells in a column instead of a row?

Yes. Select the cells in the column you want to merge, then click Merge and Center. Excel will combine them vertically. The text will be centered both horizontally and vertically within the merged cell.

What happens to formulas when I merge cells?

If the top-left cell contains a formula, it stays. If other cells contain formulas, they are deleted when you merge. If you need those formulas, copy them to another location first or rewrite them in the merged cell after merging.

Can I merge cells that contain different data?

You can select them and merge, but only the content from the top-left cell will remain. The data in other cells will be deleted. If you want to keep all the data, combine it into one cell manually before merging, or use a formula to concatenate the values.

Does merging cells affect how my spreadsheet prints?

No. Merged cells print the same way they appear on screen — as a single cell with centered text. The merge is purely visual and doesn't change the underlying data structure or how Excel calculates anything.

Can I merge cells in a table or pivot table?

Merging cells in an Excel table or pivot table is not recommended and may cause errors. These features expect each cell to be independent. If you need a merged header, create it outside the table or use a separate row above the table.