Fill Blank Cells in Excel
Fill every empty cell with the value from the row above — or with a custom value. The most common data-cleaning task in one click.
Drop your Excel file here
or click to browse — .xlsx, .xls, .xlsm supported
Fill down in one click
Fills every blank cell with the last non-empty value above it — the most common data-cleaning task in Excel.
Or fill with any value
Choose "custom value" to fill all blanks with a specific number, text, or placeholder like "N/A".
100% private
All processing happens in your browser. Your spreadsheet is never sent to any server.
When Do Blank Cells Appear in Excel?
Blank cells most commonly appear in these situations, and cause problems in formulas and pivot tables:
- Database and CRM exports: Many systems export data with grouped rows — the category or department name appears only in the first row of each group, and the rows below are blank. SUMIF, VLOOKUP, and pivot tables cannot work with this format.
- Pivot table source data: When ungrouping a pivot table into a flat table, category values often appear only once per group. The fill-down operation is always required before using this data as a source.
- Manual data entry: Users often leave cells blank intentionally when the value repeats from the row above. This creates issues when the data needs to be filtered or sorted.
- Merged cell removal: When you unmerge merged cells, only the top-left cell of the merged group retains its value — the rest become blank. Fill-down restores the intended data.
The standard Excel fix is: select the column, use Go To Special to select blank cells, enter a formula referencing the cell above, and paste as values. This tool does that in one click for an entire workbook.
This Tool vs Other Fill-Down Methods
| Method | Excel Go To Special | Power Query Fill Down | This Tool |
|---|---|---|---|
| Steps required | F5 → Special → Blanks → type formula → Ctrl+Enter → Paste Values | Load to Power Query → Fill Down → Close & Load | Upload → choose option → download |
| Applies to all sheets at once | No — repeat on each sheet | No — one query per sheet | Yes — one-click "All sheets" option |
| Result type | Static values (after paste-as-values step) | Static values | Static values |
| Preserves formatting | Yes, if done correctly | Partial — may strip some styles | Yes — processes cell objects directly |
| Requires Excel installed | Yes | Yes (Excel or Power BI Desktop) | No — any browser |
| Safe to undo | Ctrl+Z (lost after save) | Re-run query | Original file untouched — always a new download |
Frequently Asked Questions
What does "fill blank cells with value above" mean?
When data is exported from databases or pivot tables, cells that share a value with the row above are often left blank. "Fill with value above" fills each blank cell with the last non-empty value in the same column, creating a complete dataset.
Can I fill blank cells with a specific value instead?
Yes. Choose "Fill with a custom value" and enter any text or number. Every blank cell in the selected scope will be filled with that value.
Can it process all sheets at once?
Yes. Select "All sheets" to apply the fill operation to every sheet in the workbook simultaneously.
Will formatting be preserved?
When filling with the value above, the tool copies the cell object including its formatting. When filling with a custom value, basic number or text type formatting is applied.
Is my file uploaded anywhere?
No. All processing happens entirely in your browser. Your file is never sent to any server.
Related Excel Cleaning Tools
Remove Blank Rows
Delete entirely empty rows from any Excel sheet in one click.
Duplicate Row Finder
Find and remove duplicate rows after filling blank cells and normalising data.
Excel Find & Replace
Replace placeholder values or zero-fills across an entire workbook.
Spreadsheet Auditor
Full audit for errors, hidden sheets, and data quality issues.
Also check for duplicate rows
After filling blank cells, run a duplicate check — filled values can reveal rows that were effectively the same but appeared different.
Find Duplicate Rows →