Steps
- Open the free online tool - Drop your .xlsx, .xls, .xlsm, .xlsb, or .csv file into the browser-based remover - nothing is uploaded.
- Let it strip empty rows - Every row where all cells are empty is removed automatically, and you see how many were found.
- Optionally remove blank columns - Tick the box to drop columns that are empty across every remaining row too.
- Download the clean file - Get a new workbook with the blanks gone, ready to sort, chart, or import.
Before You Start
- A row is only removed when every cell is empty - rows with a value in even one column are always kept.
- The classic Go To Special > Blanks method deletes any row with a blank in the selected column, which can destroy partial records - be careful with it.
- Removing blank rows before building a table or chart prevents gaps and broken ranges.
Alternative Methods
- Online tool (safest, one click) - Removes only fully empty rows, so you can't accidentally delete partial data. Works in the browser with no upload.
- Go To Special > Blanks - Select the column, press F5 > Special > Blanks, then Delete > Entire row. Fast, but it targets blanks in that one column - risky if other columns have data.
- Filter for blanks - Add a filter, tick only (Blanks), select the visible rows, delete them, then clear the filter. More controlled but multi-step.
- Sort to push blanks down - Sorting moves empty rows to the bottom where you can delete them in one block - but it changes your row order.