🗑️ Remove Empty Rows and Fill Blank Cells
Deletes rows and columns that are completely empty and fills blank cells with a value of your choice or with the value from the cell above.
What the empty cell cleaner does
- Deletes rows in which every cell is empty
- Deletes columns that have no values below the header
- Fills empty cells with a fixed value, for example N/A or 0
- Or fills empty cells with the value from the cell above — ideal for grouped reports where a name is written only once
- Dates and numbers that are copied down keep their format
Before and after: empty rows and blank cells
| Before | After |
|---|---|
| Row with no values at all | deleted |
| Region: (empty) under "West" | Region: West (fill down) |
| Phone: (empty) | Phone: N/A (fixed value) |
How to remove empty rows and fill blank cells in 3 steps
Before you start: limits and backup
- Always keep a copy of your original file as a backup and check the cleaned copy before you use it.
- Cells that contain only spaces count as empty.
- Rows that are completely empty are never filled — they are either deleted or left as they are.
- Reads .xlsx, .xls and .csv files and saves the result as a new .xlsx file.
- Only the first worksheet is cleaned. Other worksheets and title rows above your table are kept unchanged.
- Values, dates and number formats are kept. Cell colors and fonts are not carried over to the cleaned copy.
- The tools are provided free of charge and "as is". We have built and tested them with great care, but we cannot guarantee that every entry is recognized or changed correctly. As far as permitted by law, we accept no liability for results or any damage arising from their use. See Legal Notice & Disclaimer.
Why empty rows and blank cells cause problems
Empty rows and columns sneak into spreadsheets through copy-paste, exports from other programs or lists that were combined from several files. They break sorting and filtering, and blank cells cause formula errors and gaps in pivot tables.
This tool cleans that up in one step. Completely empty rows and columns are deleted. Blank cells inside your table can be filled with a value you choose, or with the value from the cell above — the classic fix for reports where a customer or region name only appears in the first row of each group.
You open the tool in your browser, pick your Excel or CSV file, choose what should happen and save a cleaned copy. Your original file is not changed and nothing is uploaded.
Common questions about empty rows and blank cells
How do I delete all empty rows in Excel?
Open your file in the tool and choose what should happen. Rows in which every cell is empty are deleted. Columns that have no values below the header can be deleted too. Cells that contain only spaces count as empty.
How do I fill blank cells with the value above?
Choose to fill empty cells with the value from the cell above. This is the usual fix for reports where a name appears only in the first row of each group. Dates and numbers that are copied down keep their format.
Can I fill blanks with N/A or 0 instead?
Yes. You can fill empty cells with a fixed value such as N/A or 0. Rows that are completely empty are never filled. They are either deleted or left as they are.
More free Excel cleanup tools
Find & Remove Duplicates
Review duplicate rows before deleting
Clean Whitespace
Remove extra and invisible spaces
Merge Columns
Combine columns with any separator