Are formulas affected?

Never replicates formulas (no ref shift).

Can I undo the operation?

Yes. Undo Last on the ribbon reverses it in a single step.

Does the result stay linked to the source?

What you get is static: it will not follow later edits, so rerun the tool once the data moves on.

Unmerge and Fill in Excel

Unmerge and Fill

Unmerges every merged area in the selection and copies each merged value down into the freed cells, so the data becomes filterable and sortable. Formatting is preserved and empty merged areas are skipped; you are asked to confirm first.

In short: Unmerges every merged area in the selection and copies each merged value down into the freed cells, so the data becomes filterable and sortable. Formatting is preserved and empty merged areas are skipped; you are asked to confirm first. In-place value fill of freed cells. The source table is left as it is; Undo Last brings it back if needed.

What it is for

Unmerge and Fill is used to unmerge cells and fill their value across the freed cells.

When to use it

It earns its place whenever you have to flatten a merged-header table for a PivotTable/filter.

Example scenarios

Flatten a merged-header table for a PivotTable/filter.

What it needs

A range containing merges (else 'no merged'); ≥50 areas asks confirm. Supported data types: text, number, date (by selection).

How to use it

Select the range to clean.
Run Unmerge and Fill from the Clean group on the XLMind Data tab.
Confirm; in-place value fill of freed cells.

What it produces

In-place value fill of freed cells.

Effect on your data and undo

Unmerge and Fill writes the result over the cells you selected. Undo Last reverses it whenever you need.

How it differs from similar tools

Compared with find-and-replace rounds, it processes the whole selection in a single pass with no skipped cells, and one step reverses it if needed.

Good to know

Confirmation for large operations. Merged cells rejected; size limits (≥50 areas asks confirm.).

Limitations

Merged cells rejected; size limits (≥50 areas asks confirm.).

Frequently asked questions

Where is the output written?: In-place value fill of freed cells.
Are formulas affected?: Never replicates formulas (no ref shift).
How are blank cells handled?: Blank merged areas skipped.
Can I undo the operation?: Yes. Undo Last on the ribbon reverses it in a single step.
Does the result stay linked to the source?: What you get is static: it will not follow later edits, so rerun the tool once the data moves on.
Any known limits?: Merged cells rejected; size limits (≥50 areas asks confirm.).

Works well with

As a preparation step, try Delete Empty Columns
Afterwards, try Fill Blanks
Often used alongside this tool: Data Profile

Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.