To unmerge cells in Excel, you use the Merge & Center button’s dropdown on the Home tab, then choose Unmerge Cells for the selected area.

Basic unmerge (single area)

  1. Select the merged cell (or range that includes merged cells). You can tell it is merged if clicking it highlights multiple grid cells but shows one address in the Name Box.
  1. Go to the Home tab.
  1. In the Alignment group, click the small arrow next to Merge & Center.
  1. Click Unmerge Cells.

Excel splits the merged cell back into individual cells and keeps the content only in the top‑left cell; the rest become blank.

Unmerge all merged cells on a sheet

If your whole sheet is full of merged cells and everything is impossible to sort or filter:

  1. Press Ctrl + A (or click the triangle at the top‑left corner of the sheet) to select the entire worksheet.
  1. Look at Merge & Center on the Home tab: if it appears highlighted, there are merged cells in the selection.
  1. Click Merge & Center once to unmerge every merged cell in the sheet at once.

Again, after this, only the upper‑left cell of each former merged block will contain the original value.

Unmerge without losing data (fill down after unmerge)

Normally, when you unmerge a column like:

  • A2:A5 merged with value “North America”
  • A6:A9 merged with value “Europe”

you end up with “North America” only in A2 and “Europe” only in A6, with blanks underneath. To keep the data visible in every row:

  1. Select the column that contains the merged cells (for example, column A).
  1. Use Home → Merge & Center → Unmerge Cells to unmerge them.
  1. With that column still selected, go to Home → Find & Select → Go To Special….
  1. Choose Blanks and click OK. Now only the blank cells in that column are selected.
  1. Type = (equals), then press the Up Arrow once, so the formula refers to the cell above (e.g., =A2 in a blank A3).
  1. Press Ctrl + Enter to apply that formula to all selected blank cells at once; each blank now shows the value above.
  1. (Optional but recommended) Copy the entire column and use Paste Special → Values so you keep the text instead of formulas.

This gives you a clean column with no merged cells and every row carrying its group label.

A quick “story” example

Imagine you get a messy report from a colleague: all region names are merged across several rows, so filtering by region breaks everything. You:

  • Select the whole sheet and unmerge all cells in one click using the Merge & Center button.
  • Then, for the “Region” column, you select it, run Go To Special → Blanks , fill the blanks with the value from above, and paste as values.

In under a minute, the report turns from unfilterable chaos into a clean table that sorts and filters perfectly.

Tiny FAQ

  • Will I lose data when unmerging?
    You won’t lose the text or value itself, but it will remain only in the top‑left cell of the previous merged area unless you use a fill‑down technique as described.
  • Where is “Unmerge” in Excel?
    It’s in the Home → Alignment group, under the Merge & Center dropdown as Unmerge Cells.

Bottom note: Information gathered from public forums or data available on the internet and portrayed here.