How to Unmerge Cells in Excel and Keep the Values
Merged cells look tidy and wreck everything downstream — sorting, filtering, PivotTables, lookups. The fix isn't just unmerging; it's filling the value back into every freed cell. Here's how.
Last updated: August 2026
| Merged block | Unmerged + filled | |
|---|---|---|
| Q1 (spans 3 rows) | → | Q1 / Q1 / Q1 |
| Q2 (spans 2 rows) | → | Q2 / Q2 |
Method — unmerge, then fill the blanks
- Select the range and click Merge & Center to unmerge. The value now sits only in the top-left of each old block; the rest are blank.
- Keep the range selected.
F5> Special > Blanks > OK. - Type
=, press the Up arrow, thenCtrl+Enterto fill every freed cell with the value above. - Paste Special > Values to lock it in.
The 1-click way — Tellsheet
Unmerge & Fill Down does both halves at once: it splits every merged block in the selection and repeats the merged value into each freed cell, as real values. No blank-selection dance, no paste-special — and it previews the result first. It's the fix for merged headers that break sorting, filtering, and lookups. Pairs with Fill Blanks and Merge Cells (the reverse).
Frequently asked questions
How do I unmerge and keep the value in each cell?
Unmerge, then F5 > Special > Blanks, = Up-arrow, Ctrl+Enter — or Tellsheet's Unmerge & Fill Down in one click.
Why do merged cells cause problems?
Only one cell holds the value; the rest are empty, which breaks sorting, filtering, PivotTables, and lookups.
Can I do a whole sheet at once?
Yes — select all and run Unmerge & Fill Down over the range.
How do I merge again later?
Use Merge Cells to join columns without losing data — see the Combine Columns guide.
Related Excel guides
Unmerge and fill in one click
Unmerge & Fill Down splits merged blocks and repeats the value into every row — right inside Excel.
Get Tellsheet free See pricing