- In short
- Fills each blank cell in your selection with the value from the cell above it. This is useful for flattening grouped reports before you build a PivotTable. Select the columns that have the gaps first. Only truly empty cells are filled and you can undo the change. In-place fill-down of blanks. Your source data stays unchanged and can be reversed in one step with Undo Last.
What it is for
Fill Blanks is used to fill blank cells down with the last value above.
When to use it
Typical use: fill blank grouping cells in a subtotal-style table.
Example scenarios
- Fill blank grouping cells in a subtotal-style table.
What it needs
A range selection (merged rejected). Supported data types: text, number, date (by selection).
How to use it
- Select the range to clean.
- Run Fill Blanks from the Clean group on the XLMind Data tab.
- Confirm; in-place fill-down of blanks.
What it produces
In-place fill-down of blanks.
Effect on your data and undo
Fill Blanks writes the result over the cells you selected. One click on Undo Last brings everything back.
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
Merged cells rejected.
Limitations
Merged cells rejected.
Frequently asked questions
- Where is the output written?
- In-place fill-down of blanks.
- Are formulas affected?
- Formula cells preserved.
- How are blank cells handled?
- Blanks are the target (filled).
- 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?
- The output does not track the source afterwards; a quick rerun brings it up to date.
- Any known limits?
- Merged cells rejected.
Works well with
- To tidy the data first, use Unmerge and Fill
- A good companion is 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.