How to Merge Cells in Excel, Plus Unmerge and Fixes (2026)

Merging cells is the quickest way to give a spreadsheet a tidy heading that stretches across several columns, like a product list title or a monthly report banner. It's also one of the easiest ways to lose data without noticing, which is why I'd rather you know the catch before you click.

Everything below follows Microsoft's own support page on merging and unmerging. Microsoft says its steps cover Microsoft 365, the recent stand-alone versions and Excel for the web, so if a menu looks slightly different on your screen, look for the same button name rather than the same position.

The Merge & Center route for joining Excel cells

1. Click the first cell you want to join, then hold Shift and click the last cell in the range.
2. Go to the Home tab.
3. Click Merge & Center, then choose Merge Cells from the options.
4. Check the result. The cells now behave as one larger cell.

Microsoft's advice for a clean result is to make sure only one cell in the range holds anything. If you're merging a heading across four columns, the heading should sit in the top left cell before you start.

What Excel does with the text in merged cells

This is the part to read twice. Microsoft says only the contents of the upper-left cell stay in the merged cell, and the contents of the other cells are deleted. For languages written right to left, it's the upper-right cell instead.

Situation	What Microsoft's page says
Several cells hold text	Only the upper-left cell's text is kept; the rest is deleted
You need the other text	Copy it somewhere else in the worksheet before you merge
You merged by mistake	Press Ctrl + Z straight away to undo
You want to see the data later	Unmerging moves the kept data to the left cell

If you want to combine the text from several cells instead of throwing most of it away, merging isn't the tool. Joining text is a formula job, and it's a different task from the layout button on this page.

Merge Across, Merge Cells and Merge & Center compared

The button has a small arrow beside it, and the choices behind it do slightly different things. Microsoft names them like this:

• Merge & Center joins the cells and centres the content.
• Merge Across is listed beside it for joining without centring.
• Merge Cells joins the selected cells into one without centring.

If you'd rather not have centred text, Microsoft says you can merge and then pick left, centre or right alignment from the alignment options on the Home tab.

Unmerging cells in Excel when you change your mind

1. Click the merged cell.
2. Open the small arrow beside Merge & Center.
3. Choose Unmerge Cells.

Straight after merging, Ctrl + Z does the same job faster. Microsoft is clear that unmerging gives you back the cell layout, but it won't bring back text that was deleted when you merged. That text only returns if you copied it first or you undo immediately.

Microsoft also notes that you can't split a cell that was never merged. If a single cell holds a full name and you want first and last name in two columns, its page points you to Data, then Text to Columns, choosing Delimited and ticking Space or Comma. Make sure there are empty columns to the right first, or the split will overwrite what's there.

If Merge & Center is greyed out in Excel

Microsoft lists two causes, and both are quick to check:

1. You're still editing a cell. Press Enter or Esc so the cursor isn't blinking inside it, then select the cells again.
2. The cells sit inside an Excel table. Tables often show alternating row shading and filter arrows on the header row. Microsoft says the merge button can be unavailable for cells formatted that way, so merge in a range outside the table instead.

Menus vary by version, so if neither fix works, check which version of Excel you're using and look at the matching Microsoft page.

Finding merged cells in an Excel workbook

Merged cells cause trouble when you inherit someone else's spreadsheet and sorting or filtering behaves oddly. Microsoft says you can locate them with the Find command, so you can unmerge them in one go rather than hunting by eye.

A quick merge routine for Excel report headings

Here's the habit I'd suggest if you build reports for clients or your own team. Type the heading in the left-most cell of the row first. Select across the columns the heading should span. Merge, then check the cell reads the way you expect before you move on. If you spot an error, undo at once rather than retyping, because undo is the one reliable way to bring back text that a merge removed.

It also helps to keep a spare copy of the workbook before a big tidy-up, especially if several people edit the same file. Merging looks harmless on screen, but a stray merge in the wrong row can confuse anyone who later sorts the column.

When merging Excel cells is a bad idea for a small business

For a client quote sheet or a stock list that people will sort and filter, I'd avoid merging inside the data itself. Keep merged cells for headings and titles above the data, and leave the table underneath as plain single cells. It keeps the sheet easy for the next person to use.

Teams that live in Google rather than Microsoft can follow the same idea with my walkthrough for merging cells in Google Sheets. And if you want an assistant to help you build formulas rather than layouts, this guide to using Claude with Excel covers how to set it up.

Frequently asked questions

How do I merge cells in Excel?

Select the cells, go to the Home tab, click Merge & Center and choose Merge Cells. Only the upper-left cell's contents are kept.

Why did my text disappear when I merged cells?

Microsoft says only the upper-left cell's contents remain after a merge and the others are deleted. Press Ctrl + Z straight away to undo, or copy the text elsewhere before merging next time.

How do I unmerge cells in Excel?

Click the merged cell, open the arrow beside Merge & Center and choose Unmerge Cells. The kept data moves to the left cell.

Why is Merge & Center greyed out?

Microsoft says to check that you aren't editing a cell and that the cells aren't formatted as an Excel table.

Can I merge cells without centring the text?

Yes. Use the arrow beside Merge & Center and pick Merge Cells or Merge Across, or merge and then set the alignment you want.