How to Unmerge Cells in Excel

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

Being able to merge and unmerge cells greatly improves reporting and presentation.

By definition, merging cells in Excel is a process where you join two or more adjacent cells into one larger cell.

But sometimes, mistakes happen and you would like to unmerge cells. That is, separate the large cells and break them into their original pieces.

In this article, we’ll show how to unmerge cells in Excel. We’ll also show you key combinations to do it.

Kasper Langmann, Co-founder of Spreadsheeto

Get your FREE exercise file

Before you start:

Throughout this guide, you need a data set to practice.

I’ve included one for you (for free).

Download it right below!

Download the FREE Exercise File

Download exercise file

How to unmerge cells

Let’s say you have this sheet where you mistakenly merged A2 and B2:

jan to april only 2019 monthly sales

As you can see, B2 should say “Sales”.

But before you can do anything, you will have to unmerge the merged A2B2 cell first.

To do so, make sure the merged cell is selected. Also, check that you’re in the ‘Home’ tab.

home tab on tab list

Under the ‘Alignment’ group on the Ribbon, click the ‘Merge & Center’ icon.

If the cell you’re unmerging is merged, the icon will have a gray background like it’s being pressed.

Kasper Langmann, Co-founder of Spreadsheeto

After that, the cell will now break into A2 and B2.

From there, we can now make changes to B2 without affecting A2.

Unmerge cell key combination

There’s a key combination that would let you unmerge a cell without moving your mouse.

Of course, the cell has to be selected first before the unmerging can take place.

Kasper Langmann, Co-founder of Spreadsheeto

Take note that ‘unmerge’ doesn’t have a shortcut. This key combination is only the key equivalent of the actions you have to take to unmerge a cell.

  • ‘Home’ tab: ‘Alt’ + ‘H’
  • ‘Merge & Center’: ‘Alt’ + ‘M’
  • ‘Unmerge Cells’: ‘Alt’ + ‘U’

When putting together everything, all you have to do is hold down ‘Alt’ and press ‘H’, ‘M’, and ‘U’.

Wrapping things up…

In a sense, it’s a simple two-step process: select cell and click the icon. That’s it!

Knowing how to unmerge cells is easier than knowing how to open Microsoft Excel for the first time. 😊

Kasper Langmann, Co-founder of Spreadsheeto